Power Platform Community Forum Thread Details

PAD flow is gradually slowing down on every iteration of for each loop

I made a simple Excel file with one column of 1000 rows.
The flow opens this file (its a local file, on C:) and also opens an empty Excel file.
Then it iterates through all rows of the first Excel file.
Within the loop it reads a cell from first Excel and inserts into second Excel file (practically copying it…).
I read the actual datetime on 1) start of the loop, 2) after reading data, 3) after writing data, 4) end of the loop
I write these timestamps is second Excel's B,C,D,E columns to evaluate them.

What I noticed that every step within the loop is gradually taking longer time to finish.
Copying the 1st row is 0.2sec, 10th row 0.4sec, 25th row 0.7sec, 50th row 1.4sec, 100th row 3sec, 400th row ~10sec.
The actions above (1-4) are getting evenly slower, not only one of them.

I had a web automation flow (copying data from Excel to an internal web app) and I noticed this slowing down, first I thought the web app is broken.
But testing it with two local excel files assured me that its the PAD and not the website.

What is happening here?
Is there a solution on this?

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate