Power Platform Community Forum Thread Details

Hello,

I setup a flow with reoccurance.

In an excel table, there are different columns and there are 2 columns named "email" and "status".

I want a flow to check each row in this table when the status is modified to "closed", an email will be sent to the email address showed in this row.

How to make it? Thank you.

Categories:

Building flows

1. In your flow, add the List rows present in a table action.

2. Select Excel for Business as the connector.
Choose the file where your data is stored. Make sure the file is in OneDrive or SharePoint, as Power Automate cannot check local files.
Select the table that contains the "email" and "status" columns.
Add an Apply to each action to loop through all rows in the table. Use the value from the previous step as input.

3. Inside the loop, add a Condition action. In the first box, select the Status column from Excel. Choose is equal to. In the third box, type "closed".

4. In the Yes branch (if the status is "closed"), add the Send an email action. Choose Outlook or any email provider you use. In the To field, select the Email column from Excel (dynamic content). In the Subject, type a message like "Your request is now closed". In the Body, write a message like "Hello, your request has been marked as closed."