Solved: Excel 256 Row Limit in MS Power Automate

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

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

• About
• Latest Posts

Shane Bartholomeusz

G’day, I’m a technical solutions consultant based in Perth, Australia that specialises in the Microsoft technology stack, including .NET, Dynamics 365, Azure and general web development etc.

This blog is my place to share my thoughts, helpful solutions and just random nerdy stuff.

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