Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 503 Super User 2025 Season 2
Tomac 321 Moderator
abm abm 237 Most Valuable Professional
