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.
@KrishnaV Paul Muran shows a way to upload batch entries to sharepoint which willy significantly reduce time.
https://www.youtube.com/watch?v=2dV7fI4GUYU&t=135s&ab_channel=PaulMurana
https://www.tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/
Probably not use Power Automate. There are more efficient ways to process that amount of data. Which you use depends on what you want/need to do with it.
What if we have more than 10,000 records in excel. What we have to do?
Speed it up on your "Apply to each Loop"
Hi! My task is much more difficult. More than 16 thousand rows to process.
It's been 1 hour and I'm still waiting...
I think it should be possible to break it down into sub-cycles in order to go through 500 rows first and get the result, then another 500, and so on.
Worked perfectly. Thank you!
how long it took to process 3500 rows in excel?
Hi @Anonymous,
Follow this article you will come to know more insight on Flow and its limitations:
https://docs.microsoft.com/en-us/power-automate/limits-and-config
Is there a way Microsoft can make limits like this more easily KNOWN? These things are not obvious. The Flow runs happily through 256 items and there's no warning -- nothing. We only found out after a significant business impact was detected.
Just to be more precise it took 52 min for populating 5470 records from excel to Sharepoint after I change the pagination from 256 to 3500 🙂
Regards,
Krishna