Forum Discussion

SXT3410's avatar
SXT3410
Copper Contributor
May 31, 2023

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 been unsuccessful.

 

We are trying to build a column [HaveShipped] to populate Yes/No if there is a data in [Shipped Date] a single text column. The formula is valid but when looking at the list it is wrong. Here is the formula we used:

=IF(ISBLANK([Shipped Date]), FALSE, TRUE)

 

I am curious if this may have to do with the data being imported through our flow we created. Is SharePoint recognizing there is data when there really isn’t? Have anyone encounter this issue before and is there a solution?


Screen shot below shows [Shipped Date] empty but the calculated column [HaveShipped] mark as Yes. This is not what we want.

 

 

Thanks in advance!

 

 

SharePoint Online

4 Replies

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Jun 01, 2023

    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.

    • SXT3410's avatar
      SXT3410
      Copper Contributor
      Jun 05, 2023
      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)
  • suvi-15's avatar
    suvi-15
    Brass Contributor
    Jun 01, 2023

    SXT3410  Have you tried to insert row manually not through import, check if blank condition working or not. May be Shipped Date has value as " ", like may be space or something there. Just check that once if not.

     

    Br,

    Suvi

    • SXT3410's avatar
      SXT3410
      Copper Contributor
      Jun 05, 2023
      Yes I entered a new row and it works correctly. This had to do with the import of data, for some odd reason the flow imported a blank space maybe. After opening a row that was imported through flow, I added a ship date and then removed it then it worked correctly, this indicated that the blank column had something in it.

Resources