Unanswered

Condition statement WITHIN the email body

(1) Share

Report

Posted on by adove

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

AlanPs1 2,471 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-yamao-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
adove 96 on at

Like (0)

Report

Inside the body of a 'Send an email' action I have the following "dummy" markup.

If the SharePoint column <'First Name'> contains text
then write the following:
Dear <'First Name'>,
We are pleased to announce...

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (2)

Report
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.

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

Was this reply helpful? Yes No