Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

30.000 rows data excel update to sharepoint list

(0) ShareShare
ReportReport
Posted on by 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:

firda59_0-1689671304515.png

 

Can anyone help me? Thankyou.

  • rzaneti Profile Picture
    rzaneti 3,386 on at
    Re: 30.000 rows data excel update to sharepoint list

    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.

  • firda59 Profile Picture
    firda59 372 on at
    Re: 30.000 rows data excel update to sharepoint list

    Dear @Koen5 

     

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

     

    Thank you

  • Unknown geen idee Profile Picture
    Unknown geen idee 1,755 on at
    Re: 30.000 rows data excel update to sharepoint list

    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

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard