Announcements
Hi All,
On the sharepoint list, I have a column named as SalesID which consist of unique ID's. However, there are few blank fields as well. Currently, I am using below Concat function in which I also want to add an if function that says if SalesID is blank then the output will also be blank and if it consist of an ID then concat('https://crm.myshn.net/lightning/r/Opportunity/',triggerOutputs()?['body/SalesID'],'/view')
Compose input - string(triggerOutputs()?['body/SalesID'])
Are you getting an error?
I want to add an if function within the existing concat function.
If function should include if SalesID is blank then the output will also be blank and if it consist of an ID in that case use the concat function.
Move the Initialize variable at the very top. Set it initially to blank.
You can then just use the condition action and set the variable inside the yes and no branch accordingly. Makes sense?
Please suggest an alternate solution without the condition action.
if(empty(triggerOutputs()?['body/SalesID']),'',concat('https://crm.myshn.net/lightning/r/Opportunity/',triggerOutputs()?['body/SalesID'],'/view'))
Thank you so much. This helped 🤗
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 784
Valantis 589
Haque 522
