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
New Member

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.

Regular Visitor

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 

New Member

Does not look like this request has garnered much attention since 2018, but for whatever its worth, I join in the call to increase the number of rows to make it (hopefully) unlimited.  We pull data from a worldwide online training log and create various Sharepoint lists from it.  As this is the first year for us, we are currently OK with a couple of thousand entries, but it is very likely that we will need substantially more as soon as 2021.  Increasing the row count would be a huge help.