Shane Bartholomeusz

Geek and lover of all things tech related

Solved: Excel 256 Row Limit in MS Power Automate


Whilst reading Excel files within Microsoft Power Automate (or Azure Logic Apps), you might notice that only the first 256 rows will be imported …

Hmmm …. What is Going On Here?

Microsoft Flow and Excel Logos


By default Microsoft Power Automate limits you to fetching the first 256 rows … however you can increase this limit in the following way.

This setting will effectively instruct Power Automate to fetch batches of 5000 rows at a time therefore bypassing the Excel 256 row limit.

  1. Navigate to SETTINGS on the Excel step
  2. Enable Pagination
  3. Set the Threshold above 256 e.g. 5000.
Microsoft Flow Excel
Microsoft Flow Screenshot
Shane Bartholomeusz


  1. Is there a maximum number of rows that can be pulled through this method?

  2. hi, this one really helped me a lot, thankyou

Leave a Reply

© 2024 Shane Bartholomeusz

Theme by Anders NorenUp ↑