Answered

Loop Through all Indexes

Like (0) Share

Report

Posted on 6 Dec 2019 16:55:41 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:

I have the same question (0)

All responses (5)

Answers (2)

abm abm 32,585 Most Valuable Professional on 06 Dec 2019 at 17:12:18

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

Was this reply helpful? Yes No
Community Power Pla... on 06 Dec 2019 at 17:40:03

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:

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on 06 Dec 2019 at 17:42:05

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/

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on 09 Dec 2019 at 05:54:15

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,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on 13 Dec 2019 at 14:09:02

Like (0)

Report

Re: Loop Through all Indexes

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

Was this reply helpful? Yes No