Hello,
I have more than 20k rows excel data. I want to grab that data, so my sharepoint list can update automatically by trigger 'new item is created'.
this is my flow:
Can anyone help me? Thankyou.
Hi @firda59,
Do you need to do any transformation on the data before uploading it in SharePoint List?
A possible solution here is to use some Office Scripts (which is basically a 'VBA', but available in Excel web and integrated with Power Platform) extract it and return to Power Automate. This approach also has a limitation: each script can run for at maximum 120 seconds, so it probably would require more than 1 script to capture all 30k rows from your table.
Here are some reference links about this tool:
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration
http://digitalmill.net/2023/06/19/get-started-with-office-scripts/
http://digitalmill.net/2023/06/10/office-scripts-the-new-vba/
If you think that this approach can fit your needs, we can write a Script for that.
Dear @Koen5
I tried using pagination, but it just can read 5000rows, do you know another way to get more than that?
Thank you
Dear F,
You probably are stuck with the default limit on the rows the 'List rows in table' action.
Go to this action, top right hand side 3-dots ... and select the settings where you can change something called 'Pagination', which allows for more than the default rows to be read.
Happy flowing,
Koen