Answered

Loop Through all Indexes

(0) Share

Report

Posted on by Community Power Pla...

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:

All responses (5)

Answers (2)

Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Loop Through all Indexes

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

v-bacao-msft on at

Like (1)

Report

Re: Loop Through all Indexes

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,
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Loop Through all Indexes

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/
Community Power Pla... on at

Like (1)

Report

Re: Loop Through all Indexes

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:
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Loop Through all Indexes

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