Forum Discussion

Nate_willy's avatar
Nate_willy
Copper Contributor
Apr 11, 2023

Calculated Column Syntax Error Not Supported

Hello,   I've built an MS Form that feeds to a SharePoint List via Power Automate. In the Form, I have a good bit of branching to make it more customer friendly. However, in the SharePoint List, th...
Lists
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Apr 11, 2023

Nate_willy Try using this formula: 

 

=CONCATENATE(TRIM([Base]),IF(ISBLANK(TRIM([Courtney Housing])),""," "),TRIM([Courtney Housing]),IF(ISBLANK(TRIM([Foster Housing])),""," "),TRIM([Foster Housing]),IF(ISBLANK(TRIM([Kadena Housing])),""," "),TRIM([Kadena Housing]),IF(ISBLANK(TRIM([Lester Housing])),""," "),TRIM([Lester Housing]),IF(ISBLANK(TRIM([McT Housing])),""," "),TRIM([McT Housing]),IF(ISBLANK(TRIM([Shields Housing])),""," "),TRIM([Shields Housing]),IF(ISBLANK(TRIM([Kinser Housing])),""," "),TRIM([Kinser Housing]))

 

Notes:

  1. Make sure you are using correct display names of your columns in the formula. Column names are case sensitive. For safer side, enclose all column names with square brackets
  2. Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma ( , ).
  3. You can add up to 30 parameters inside concatenate function.

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.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources