cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kmk
Helper V
Helper V

How to get more than 256 rows from excel using Pagination in each iteration

Hi Mates,

It seems like limitation on getting rows from Excel, i can not get more than 256 rows, 

yes i tried to set 1000 at Maximum Get Count but still i can get only 256 items from excel, by any chance can we get/set with other options ..?

1. By any chance can we get 1000 or 500 at a time with help of Pagination option ...? where each time it can retrieve specified or 256 items in each loop, but it has to loop all the items and update.

yes i have googled but no luck.

Your help would be really appreciated.

3 REPLIES 3
kmk
Helper V
Helper V

Hi On top of that i turned on Pagination, updated with item threshold  5000,

from excel no issue looping items,

but during writing/inserting it throws error like "Flow run timed out. Please try again" at 1060 item means its updated till 1059 items around.

How can get rid out of this time out  issue during inserting.

 

 

@kmk 

 

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.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

 

thank you so much @rsaikrishna  , i  did just what you suggested for my excel table with 40K rows and it worked magically 😉

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (3,932)