cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChadVKealey Kudo Kingpin
Kudo Kingpin

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
Highlighted
BSouthby Advocate II
Advocate II

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

 

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

15 REPLIES 15
Community Support
Community Support

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

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

rrranta Advocate I
Advocate I

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

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

RobinV86 Helper I
Helper I

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

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

Franck_Garcia Advocate II
Advocate II

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

Same issue and still no fix from Microsoft Smiley Sad


Highlighted
BSouthby Advocate II
Advocate II

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

 

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

Franck_Garcia Advocate II
Advocate II

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

Hi BSouthby,

 

I have tested it with 400 rows. It worked.

 

Thank you !

BSouthby Advocate II
Advocate II

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

@Franck_Garcia, you're welcome!

JACK_LAI Helper II
Helper II

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

@BSouthby 

 

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

 

20190920-3.JPG

BSouthby Advocate II
Advocate II

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

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

DenisSkorskiy1
New Member

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

Pigination works!

timothyliangbmo
New Member

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

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

Kav Helper I
Helper I

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

Any idea what the upper limit of pagination setting is?

KrishnaV Continued Contributor
Continued Contributor

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

Hi,

 

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

 

Thank you,

Krishna

Kav Helper I
Helper I

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

Very cool, thank you!

KrishnaV Continued Contributor
Continued Contributor

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

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (5,878)