cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sharuk
Helper III
Helper III

getting excel records

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

2 REPLIES 2
jinivthakkar
Resident Rockstar
Resident Rockstar

@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-... 

 

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!

 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (71,051)