30.000 rows data excel update to sharepoint list

(0) Share

Report

Posted on by firda59

372

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report

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

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Dear @Koen5

I tried using pagination, but it just can read 5000rows, do you know another way to get more than that?

Thank you

Was this reply helpful? Yes No
rzaneti 4,262 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No