Is there any limit using foreach action in power automate?

Question

In my power automate flow, I use a "List rows present in a table" action in Excel Online(OneDrive) and next action is an for each action.

And I found the flow stopped after it get 256 rows. Dose it configured in for each action or in the "List rows present in a table" action. How can I read all rows and the rows is over 200000. I know it is quite a lot and do you have any other option to handle this kind of data?

Answer 1

Hi digiinfra dev,

Power Automate is currently not supported in the Q&A forum.

Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

Thank you for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

I got the same problem but when listing in sharepoint table holding more than 5000 records.
It should be the same, so what worked for me?

Power Automate supports pagination for the "List rows present in a table" action, which allows you to retrieve rows in batches. To configure pagination:

• Edit the "List rows present in a table" action:
• Click on the ellipsis (three dots) in the upper right corner of the action.
• Select Settings.
  • Enable Pagination and set the threshold to a value higher than 256. For instance, you might set it to 10,000 or the maximum value allowed, which is 50,000.