MS Flow that insert row with custom value one by one

[Majingcth]

I have a MS flow that insert a row to an excel table, I also have below mapping:

Mary	mary@gmail.com
Peter	peter@gmail.com
John	john@gmail.com

I would like the flow to insert row with the email above updated one by one, which means if Row 1 I pick mary@gmail.com, then pick peter@gmail.com at Row 2 and  john@gmail.com at Row 3 etc. Then loop back to mary@gmail.com.

Any quick way I can build this logic please?

[v-bacao-msft]

Hi @Majingcth ,

Please try to store these three emails in an array variable, then iterate through the array and insert it into the Excel table.

Best Regards,

[Majingcth]

This not exactly what I want.

I want: where I add row 1, add with email 1, add email 2 when adding row 2 etc....

I hope I am clear enough

[v-bacao-msft · Accepted solution]

Hi @Majingcth ,

Could you explain your needs with screenshots? I am afraid I did not understand your needs before.

The method I provide is to use the properties of the array to traverse the elements in turn by Apply to each, so that the purpose of inserting the email contained in the array in order can be achieved.

What kind of problem did you have after using the method I provided? Please let us know so that I can improve my method.

Best Regards,