Problem
When processing Excel files containing over within Microsoft Power Automate (or Azure Logic Apps), you might notice that only the first 256 rows will be returned …
What The? What's Going On Here?

Solution
Well it turns out that by default Microsoft Power Automate limits you to fetching the first 256 rows … however you can increase this limit in the following way
- Navigate to SETTINGS on the Excel step
- Enable Pagination
- Set the Threshold above 256 e.g. 5000.


Latest posts by Shane Bartholomeusz (see all)
- Azure CRON Expression – Cheat Sheet - 14th January 2021
- How To: Win 10 Screen Sharing - 17th December 2020
- How To: Unlock Protected Excel Spreadsheet - 11th November 2020
27th May 2020 at 3:51 am
Is there a maximum number of rows that can be pulled through this method?