You’re offline. This is a read only version of the page.
202
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
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!
@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.
Share
Report
All responses (
Answers (
