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,
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.
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
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.