Unanswered

repeating flow steps for data extraction from email to excel

(0) Share

Report

Posted on by crylo678

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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

harshdeol 441 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
crylo678 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
harshdeol 441 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No