Conditional text

[msmith]

Using the "Send using email" action, how can I change or make text visible based on data within a list. For example I have 4 yes/no columns and I only want to display everything that equals Yes to be in the body of the email. 

[v-xida-msft · Accepted solution]

HI @msmith,

Could you please share a bit more about your SharePoint list?

Do you want to filter items of SharePoint list based on 4 yes/no columns which are all equal to Yes and then contain them in the body of the email?

Further, could you please show more details about your scenario?

I assume that you want to filter items of SharePoint list based on 4 yes/no columns which are all equal to Yes and then contain them in the body of the email, I have made a test on my side and please take a try with the following workaround:

• Add a proper trigger, here I use Flow button trigger.
• Add a "Get items" action, specify Site Address and List Name.
• Add a "Filter array" action, From set to output of "Get items" action, click "Edit in advanced mode", type the following formula:

• @and(equals(item()?['Column1'], true),equals(item()?['Column2'], true),equals(item()?['Column3'], true),equals(item()?['Column4'], true))

  Add a "Select" action, From set to output of "Filter array" action, within Map entry, type the entry as below:

  Within key box, type the column name that you want to show up.Within value box, type the following formula:

item()?['ColumnNameOfYourSharePointList']

• Add a "Create HTML table" action, From set to output of "Select" action.
• Add a "Send an email" action, Body field set to output of "Create HTML table" action, Is HTML set to Yes.

Image reference:

The flow works successfully as below:

Best regardS,

Kris