Answered

Looping my Power Automate flow for each row in Excel Online table

(1) Share

Report

Posted on by wmb996

Hi. I've created a flow that uses an Excel Online table, looks at each row ("For a selected row") to see if it meets three criterion, and, if Yes, sends a custom email. I tested this out and it worked great!

Only issue: I set it to run for a selected row so it stops after the first row. How do I loop this to run for each row each time the flow is run?

Thanks in advance!

Categories:

Building flows

2023_09_05_21_36_...

I have the same question (0)

All responses (3)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@wmb996 You need to use a List Rows Present in a Table action. However, if you are looking for rows that meet specific criteria—I'd recommend using a Filter Array action. Please refer to a YT Tutorial I recently uploaded.

This section talks about how the filter array action works and it's a lot more efficient than looping through each item in your Excel table.

Refer to this section of the tutorial on how to include more than one condition in a Filter Array action.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @wmb996

"For a selected row" action works on single row as name suggests. If you want to process multiple rows, then you may create a manual flow or schedule flow which when runs fetch & process the records present in excel sheet. Once you have set up the trigger action, you may use the below actions:

1. "List rows present in a table"- It will fetch the records from the excel sheet. You may pass filter query to filter the records and there are many more. If there is more than one filter clause, you may use "filter array" action to filter records.

2. "Apply to each" action to loop the records obtained from step 1.

3. You may add condition and other actions as per your need.

All triggers & actions details for excel connector are mentioned in the below link:

Excel Online (Business) - Connectors | Microsoft Learn

I hope you will find this useful.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Verified answer

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @wmb996 ,

That trigger is designed for a single row, if you need to loop through rows and send emails, you will need a different trigger. Here's one of many examples, a manual trigger where daily, someone wants to send an email to each email per row asking for a status update or similar example.

Send you add the dynamic content Email in Send Email (V2) action, it will automatically wrap itself in an apply to each and as the name suggests, for each row, it will send a dynamic email related to that row for the email associated on that row. So essentially if you already have a working flow, you can modify pretty quickly to get this implemented.

Now for your three filter conditions, you do that in your List Rows present in a table action using an OData filter query.

Here's a three-filter query example:

status eq 'open' and assignedto eq 'Team1' and vendor eq 1

If this helps you resolve your problem, please mark as a solution to help others find this for similar problems.

Was this reply helpful? Yes No