Announcements
96
I have an email that requires an expression or a condition statement to be validated WITHIN the body of the email based on the value of a SharePoint list column. If the field length > 0 then include additional text. I have started playing with creating variables, but unsure of how to implement within the body section of the 'Send to email' action.
Hi @adove ,
Do you want to show the “dummy” markup dynamically based on the length of the column?
Please try if the following code will work for you. This steatement will retrun Dear <'name'> if the length is greater than 10, otherwise, it will be blank.
Share
Report
All responses (
Answers (
if(greater(length(triggerBody()?['CC']),10),concat('dear',' ',triggerBody()?['CC']),'')
More details about the WDL functions, please check it at here:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
Best regards,
Mabel
Hi @adove ,
Do you want to return texts based on the length of a SharePoint list column?
Please try inserting the following condition in the email body to see if it will meet your scenario.
if(greater(length(triggerBody()?['CC']),10),'there are more than 10 characters in this field',triggerBody()?['CC'])
The flow is configured likes below:
Best regards,
Mabel
Hi @adove , thank you for your post in the community!
I may be getting the gist of this and could potentially provide a solution but could you please post more detail and some pictures of your Flow so I can best advise?
If you have found my post helpful, please mark thumbs up.
Any other questions, just ask.
Thanks, Alan
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
