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.
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
Dear @Koen5
I tried using pagination, but it just can read 5000rows, do you know another way to get more than that?
Thank you
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://insider.microsoft365.com/en-us/blog/automate-tasks-with-office-scripts-in-excel-for-windows-and-mac
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration
https://learn.microsoft.com/en-us/office/dev/scripts/resources/vba-differences#:~:text=VBA%20doesn't%20have%20a,workflows%20without%20even%20opening%20Excel.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tomac 532 Moderator
Michael E. Gernaey 461 Super User 2025 Season 2
chiaraalina 256
