Shane Bartholomeusz

Technical Solutions Consultant

Solved: Excel 256 Row Limit in MS Flow


When processing Excel files containing over within Microsoft Flow, you might notice that only the first 256 rows will be returned …

What The? What's Going On Here?

Microsoft Flow and Excel Logos


Well it turns out that by default Microsoft Flow limits you to fetching the first 256 rows … however you can increase this limit in the following way

  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
Latest posts by Shane Bartholomeusz (see all)

1 Comment

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

Leave a Reply

© 2020 Shane Bartholomeusz

Theme by Anders NorenUp ↑