cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChadVKealey
Impactful Individual
Impactful Individual

Excel (Business) - List rows present in a table: 256 row limit, any way around it?

I know with some of the other Excel "get rows" or "get tables" actions, there is a "Maximum Get Count" property that can be increased to 2048. However, the "List rows present in a table (Preview)" action does not have that property. There is a "Top Count" property, which I've set to 2048 (see below), but the Flow I'm using is still only getting 256 rows from the file. In this file, there are typically going to be 1,000 or fewer rows, so this would be an ideal solution if I could get around the 256-row limit. Any help would be appreciated.

2018-05-16_16-25-31.png

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

 

You can get more rows returned by setting a higher value for the pagination settings.

 

  1. Go to "List rows present in table" action
  2. Select the options elipses ("...")
  3. Select 'Settings'
  4. Enable Pagination
  5. Set an appropriate row limit

 

 

ListRows _ Microsoft Flow.png

ListRows _ Microsoft Flow.Settings.png

View solution in original post

17 REPLIES 17
v-yuazh-msft
Community Support
Community Support

Hi @  ChadVKealey,

 

 

The action "List rows present in a table" of Excel (Business) connector have the 256 rows limit in microsoft flow currently.

 

If you would like the limit of action "List rows present in a table" of Excel (Business) connector would be 2048 rows,

I afraid that there is no way to achieve your needs in Microsoft Flow currently.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Regards,
Alice Zhang

What happened to the "Get Rows" option? It worked really well, now I don't see it anymore. We only see "List rows present in a table"

 

Thanks

I am having the exact same issue. This is really frustrating! Any way around this? 

Franck_Garcia
Advocate II
Advocate II

Same issue and still no fix from Microsoft Smiley Sad


Anonymous
Not applicable

 

You can get more rows returned by setting a higher value for the pagination settings.

 

  1. Go to "List rows present in table" action
  2. Select the options elipses ("...")
  3. Select 'Settings'
  4. Enable Pagination
  5. Set an appropriate row limit

 

 

ListRows _ Microsoft Flow.png

ListRows _ Microsoft Flow.Settings.png

View solution in original post

Hi BSouthby,

 

I have tested it with 400 rows. It worked.

 

Thank you !

Anonymous
Not applicable

@Franck_Garcia, you're welcome!

Anonymous
Not applicable

@Anonymous 

 

Thank you for your direction , after I modify this config , it can get my excel data more than 256 rows !!!!

 

20190920-3.JPG

Anonymous
Not applicable

Great news @Anonymous !  Good luck with your Flows!!

Pigination works!

The pagination setting works. I tested it with 500. However, the problem is the run-time increases quite significantly if I go above 1000. 

Any idea what the upper limit of pagination setting is?

KrishnaV
Super User III
Super User III

Hi,

 

I have tested pagination with 3500 and it worked seamlessly, but performance is significantly bad, I hope that helps you.

 

Thank you,

Krishna


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Very cool, thank you!

KrishnaV
Super User III
Super User III

Just to be more precise it took 52 min for populating 5470 records from excel to Sharepoint after I change the pagination from 256 to 3500 🙂

 

Regards,

Krishna


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
RachelRig
Advocate V
Advocate V

Is there a way Microsoft can make limits like this more easily KNOWN? These things are not obvious. The Flow runs happily through 256 items and there's no warning -- nothing. We only found out after a significant business impact was detected.

Hi @RachelRig,

 

Follow this article you will come to know more insight on Flow and its limitations:
https://docs.microsoft.com/en-us/power-automate/limits-and-config

 


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

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 (8,863)