Creating a flow to copy rows to an email based on a value in a specified column

[J0hn]

Hello,

I am wanting to create a flow that takes rows and copy's them to an email body from an excel table based on a value in a column.

I have the below Table that shows 6 columns i want to send a manager a copy of only there employees based on the department code. So for example the manager for department code 200 would see John Young and John Does rows. I would have this reoccure every week.

Any help would be much appreciated, Thanks.

[v-bacao-msft · Accepted solution]

Hi @J0hn ,

Please consider using html table to display the filtered rows.

Please refer to the following method to configure Flow.

• Initialize array variable to store HTML content, configure List rows present in a table to get all rows.
• Use Condition to filter the rows with Department Code equal to 200 and append the rows to the array variable.
• Finally configure HTML table and Send email action. Note that we need to set Is html field to Yes.

Tips: when configuring Condition, if the field type is Number, you don't need to use string() function.

Image reference:

Details of Apply to each:

Please take a try.

Best Regards,

[J0hn]

This Worked Perfectly! Thank you for your help.