Answered

Improve speed of filed in folder loop

(0) Share

Report

Posted on by adrianstensrud

I have just managed to create my first PAD flow to extract some password protected zipped archived from a OneDrive folder, to another, based on the date the files were modified. However, I have thousands of zipped archives in the folder, and my flow spends over a minute to finish, even though I am only extracting 12 zipped archives.

I have sorted the "Get files in folder" by descending order on the last modified date, so the extraction takes a few seconds, but after that, it keeps looping through the rest of the files. How may I modify my flow to first only get the zipped archives that was modified within the last 4 days, and then loop through and extract the zipped archives?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

adrianstensrud 33 on at

Like (0)

Report
Copy link

Link copied!

Solved by adding another for-loop first, that moves all files that are older into another folder, and then I loop through them, as I will no longer have a lot of files to loop through in the main folder anymore

Was this reply helpful? Yes No
Gidi 601 on at

Like (0)

Report
Copy link

Link copied!

If the files are sorted descending by date already, I would suggest to add an Else command in the inner if statement of the for each loop with ‚Exit Loop‘ action.

Was this reply helpful? Yes No
adrianstensrud 33 on at

Like (0)

Report
Copy link

Link copied!

Ok. What do you suggest I populate it with?

Was this reply helpful? Yes No