Announcements
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 286
David_MA 256 Super User 2026 Season 1
Expiscornovus 225 Most Valuable Professional
