Unanswered

Power Automate limits the lines processed even after increasing the limit, how to solve this?

Like (0) Share

Report

Posted on 10 Feb 2022 10:28:10 by MarcoW91

I am trying to adjust the flow so it can get up to 10000 lines. BUt it limits it somewhere near 318 lines. I increased the limit, but it still limits the amount of lines? How can this be fixed?

for the rest I only have insert data and update data in excel flows (together with some approvals/mails) If I put something in the first row everything works, so in the rest of the flow is no issue

Could someone please assist?

I have the free version.

All responses (6)

Answers (0)

MarcoW91 23 on 10 Feb 2022 at 14:00:58

Like (0)

Report

Re: Power Automate limits the lines processed even after increasing the limit, how to solve this?

It was solved, seems a space in the conditioning was causing the error
Ellis Karim 11,179 Super User 2025 Season 2 on 10 Feb 2022 at 13:59:52

Like (0)

Report

Re: Power Automate limits the lines processed even after increasing the limit, how to solve this?

Can you share your flow?

Ellis
MarcoW91 23 on 10 Feb 2022 at 13:57:05

Like (0)

Report

Re: Power Automate limits the lines processed even after increasing the limit, how to solve this?

Hi Ellis,

It seems it finds all rows, but it just doesn't continue applying the conditions on it (if column contains yes), would there be some other way which is causing this error?
Ellis Karim 11,179 Super User 2025 Season 2 on 10 Feb 2022 at 13:45:24

Like (0)

Report

Re: Power Automate limits the lines processed even after increasing the limit, how to solve this?

Check the Excel file and the actual number of rows in the table. Your Excel file may have 10,000 (ten thousand) rows, but the table you have defined in Excel may only include 318 rows?

For example, the following Excel table has 15,000 rows:

I can count the number of rows using the length() function:
The function returns a count of 15,000 rows:

Beyond 20,000 (or around that number, the maximum number of rows Excel can read in Power Automate was increased from 5000) - you will need to a use "paging" within the flow. See: Power Automate: Read Excel File.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
MarcoW91 23 on 10 Feb 2022 at 13:11:00

Like (0)

Report

Re: Power Automate limits the lines processed even after increasing the limit, how to solve this?

I also tried it to changing to 100000 but after line 320 or so it doesn't continue, do you know what could be wrong?
Ellis Karim 11,179 Super User 2025 Season 2 on 10 Feb 2022 at 12:43:02

Like (0)

Report

Re: Power Automate limits the lines processed even after increasing the limit, how to solve this?

Try setting the Threshold to 11,000. You have it currently set to just 2,000:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.