You’re offline. This is a read only version of the page.
2
I just finished my first flow. It extracts data out of an email and populates an excel spreadsheet. The one piece I can't figure out is how to make some of the flow steps repeat when there are multiple sets of data in a single email. For example, i'm tracking order numbers, part numbers and error messages. one order may only contain data for a single part where the next order may have data for five part numbers.
thanks in advance for your help!
Hi @crylo678 ,
Please add the "Apply to each" in the beginning and configure it to iterate on Array values. All the required Actions should be inside the Apply to each. For more information, please refer to following Microsoft documentation: Use the apply to each action in Power Automate to loop through an array of items. (contains video) - Power Automate | Microsoft Learn
-------------------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.
Thank you,
Harsh Deol
here is a snip of my flow, first step was when an email is received. I need the apply to each to occur for all of these compose steps as well as the add row to excel. Does the apply to each go at the beginning or at the end?
Hi @crylo678 ,
You can use loops to repeat certain steps based on a condition. Please use the "Apply to Each" Action to iterate over the extracted data. This is where you handle scenarios where there are multiple sets of data in a single email.
If you will provide the more details, I will be happy to help you further.
---------------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.
Thank you,
Harsh Deol
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
