Answered

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

(12) Share

Report

Posted on by ChadVKealey

1,393

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.

Categories:

Using connectors

I have the same question (0)

All responses (25)

Answers (1)

v-yuazh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
rrranta 45 on at

Like (1)

Report

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

Was this reply helpful? Yes No
RobinV86 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Franck_Garcia 29 on at

Like (0)

Report

Same issue and still no fix from Microsoft

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (62)

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

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

2 people found this reply helpful.

Was this reply helpful? Yes No
Franck_Garcia 29 on at

Like (0)

Report

Hi BSouthby,

I have tested it with 400 rows. It worked.

Thank you !

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@Franck_Garcia, you're welcome!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Pigination works!

Was this reply helpful? Yes No