Add-PnPField is not working for data type "Calculated". Getting error

[sivakumarkaturi]

HI Team,

I am using the SharePoint Online Version.
Task : Creating the List and Columns using Pnp Powershell
Issue: Add-PnPField is not working for one of the data type "Calculated" type.

Support: Required the support for correct syntax for creating the calculated column in list using PnP Powershell command

Command i am using :
Add-PnPField -List $listTitle -DisplayName "ThisBirthDay" -InternalName "ThisBirthDay" -Type Calculated -AddToDefaultView

WIth Regards
Siva kumar K

[erwinvanhunen]

There is currently no direct support in one cmdlet for this. I will work on an update for this. Until this update is available you will have to fall back to using Add-PnPFieldFromXml cmdlet which allows you to send in the full xml definition of the field and set the formula like that.