Forum Discussion
SharePoint Calculated Column IF(ISBLANK
Hello, We are able to import data to a SharePoint List from our on prem server using Power Automate SQL connector. Now we are trying to create calculated columns based off the imported data but b...
SXT3410 I just tried this same formula given by you in our SharePoint list and it is working fine for me.
Column Settings:
Output:
You can also create a simple Yes/No column in list and update it's value from power automate flow itself while adding/updating item in SharePoint.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- It should have worked correctly but this indicated there must be something in the Shipped Date Column. After adjusting my formula to the one below, it works! I guess the flow was importing a space? Still confused how it happened.
=IF([Shipped Date]="",FALSE,TRUE)
