cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
BEND-Arriva

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

Submitted by Advocate I on โ€Ž08-08-2018 02:17 AM

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
4 Comments (4 New)
Comments
Berney
New Member
โ€Ž01-08-2019 10:52 AM

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.

MOConnell
Frequent Visitor
โ€Ž05-22-2019 02:03 AM

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 

Rideguy
New Member
โ€Ž05-26-2020 12:49 PM

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.

svenerikhabergb
Regular Visitor
โ€Ž10-25-2020 04:43 PM

Hi, 

 

I found a post that might help a bit at least, from Suresh Koorella. 

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/256-rows-limit-getting-rows-from-excel/td-p/...

 

I'm not sure how much you can override it with, but I have set it to 5000, and it seems to work. However it is quite slow in loading, so 100000 rows might take quite a while. Maybe consider using flow to move file to a location ans let another mechanisme load the data perhaps?