Announcements
Hi,
i see there is a limitation with excel trigger that it can only get 5000 records, but in mycase i'm having files with 4000,8000,12000 and i was unable to get more than 5000, is there a way where we can get more than 5000 records from excel
@Sharuk Yes this can be done, you can do batching and then read excel.
Please check this blog : https://piyushksingh.com/2020/07/06/power-automate-read-excel-file/
The blog has link from which you can also download the flow and run it on your environment. Don't forget to download and try.
--------------------------------------------------------------------------------If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Hey @Sharuk
You can want to try something similar to mention in the thread -https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-more-than-256-rows-from-excel-using-Pagination-in/td-p/595774
I have included it below for your convenience.
Reading in batches will resolve your issue.
Create a variable varRowCount and set the value to 0.
In the List rows present in a table action, set Skip count to varRowCount.
Use Do Until loop repeat the batches. In every iteration, increase the varRowCount value by 250. You can read any number of rows with this approach.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 286
David_MA 256 Super User 2026 Season 1
Expiscornovus 225 Most Valuable Professional
