cancel
Showing results for 
Search instead for 
Did you mean: 

Increase the number of rows you can retrieve with one of the Excel connectors (list rows, get rows)

Dear Microsoft,

 

Can you please increase the number of rows you can retrieve with one of the Excel connectors from SharePoint and Onedrive to a proper number?

 

It has been increased (for onedrive at least) to 2048 rows but it feels underwhelming and not logical as, for example, a for each can process 5000 lines.

 

My question is to at least increase the limit to 5000 as most Excel files contain many many lines on which you want to do certain operations.

 

Thanks in advance!

 

With kind regards,

 

Joseph

Status: New
Comments
Level: Power Up

I am not sure why there is a limit at all here. I am currently working with spreadsheets of almost 100,000 rows. Even if you need to grab the data in chunks, it would be really helpful to be able to grab all of my data.

Level: Powered On

It appears the legacy "Get Rows" connector had a limitation of 2048 but the "List rows present in a table" connector has a limitation of 255. Neither the advanced option "Top Count" nor the settings "Threshold" values make a change to this 255 limitation 

>