Show field values in outlook email only if condition satisfies

(0) Share

Report

Posted on by OK29

388

Hi,

I have a power automate email flow and it's sending email when item is created in sharepoint list. In email, all list column values are in the email body. But I want to show column values only if condition satisfies.

Ex: If Column 1 value is greater than 75% then only I want to show in email body.

If column 2 string contains "xxxx" then only show in email body otherwise hide....etc

Is this possible? If yes, how to achieve this?

In email

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

vivekpande18 894 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @aaedla ,
Yes this is possible by dynamically creating the html body content for the email.

1- create thel array of the internal name of the columns which you want to add conditionally.
2. Loop through alll the internal names and create the expression to get the column value.

Thanks
Vivek pande

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @aaedla ,

For those columns which need to check conditions, you can create a number of variables with if function in their expressions.

E.g. Column1

variable1:

if(greater(triggerOutputs()?['body/Column1'], 0.75),triggerOutputs()?['body/Column1'],'')

You can use these variables in body of Send an Email action.

Best regards,

Was this reply helpful? Yes No