Answered

Loop Through all Indexes

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hello Team,

I'm creating a flow to send emails for different people. In the "Get a Row", I chose "Key Column" is Index and "Key Value" is 19. However, this works only for index 19th. I have 25+ people (with indexes) and I want to loop through all indexes to send email to all, not specific index 19. So, I use "Initialize variable" to create a variable to store indexes. But I don't know how it works?

What I have so far is:

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Instead of using Get a row try using List rows. This will return everything. Add a foreach loop to iterate the results.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I changed to List Rows and "Apply to Each" to loop through the value.
So, how does it know that I want to loop through the indexes? and we don't need the "Initialize Variable" anymore?
My goal is I have this data in Excel onlne, I want to check "StatusDescription" == "In Progress", so I email to resourceEmailAddress. I want to look through the index to check all of them. Thank you.

s:

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Thanks for your reply.

Please see my blog. This might help.

https://mydevexperience.wordpress.com/2019/09/25/microsoft-flow-excel-list-rows-present-in-a-table/

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try to refer the following methods to configure Flow.

If you want to send a specific email message to each user, then you can refer to the following methods to achieve your needs.

If you want to send only one email to all users, you can refer to this method. Use array variables to store all email addresses.

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft
Thanks so much for your answer. It helps me a lot.

Was this reply helpful? Yes No