Problem
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?
Solution
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
- Navigate to SETTINGS on the Excel step
- Enable Pagination
- Set the Threshold above 256 e.g. 5000.
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.
This blog is my place to share my thoughts, helpful solutions and just random nerdy stuff.
Latest posts by Shane Bartholomeusz (see all)
- Why You Should Use Firefox Containers - 18th March 2020
- Fixed: WCF Test Client Max Size Error - 13th February 2020
- Meet the Azure CLI - 16th January 2020
Leave a Reply