Answered

Run flow for each file

(0) Share

Report

Posted on by Scenox

Good day power automate friends,

I have a finished flow that works with the browser.
This flow is built to open an excel instance and draw data from there. I would like this same flow to run for another file in the same folder after the flow is over. Until there is a flow for all the files in the folder.

Any advice on how this could be achieved?

Thank you in advance for your answer.

Sincerely,
Robert.

Categories:

Process mining

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

vtse on at

Like
a
(0)

Report
Copy link

Link copied!

hi,
the general logic to do this is the below
get the files in the folder with the appropriate action, then use a for each loop and within the loop include the actions that you want to be executed for all these files.

Was this reply helpful? Yes No
Scenox 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Yes, it occurred to me to use get files in folder. The problem is that I can't create the appropriate action.
I don't know how work with this variable Files. Please do you have any example of notation.

Thank you a lot.

Was this reply helpful? Yes No
Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Read about the for each loop.

Was this reply helpful? Yes No
JimmyJambers 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Could someone please point out what I'm doing wrong in my "for each" loop? I feel like I'm missing something.
@vtse @Henrik_M

I have a folder of .pdf files. My flow retrieves a list of .pdf files in the folder and then I want it to iterate the "Loop condition" for each of the files in the folder. My loop condition successfully splits each .pdf file into single page pdf files and places them all in a new folder. Great! But... it will not move on to the 2nd, 3rd, and so on files in the folder. Do I need another set variable to help my for each loop increment?
Thank you in advance.

Was this reply helpful? Yes No