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?
Solved! Go to 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,
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,
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
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,
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
16 | |
14 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
18 | |
10 | |
8 | |
6 |