Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : Sfmquy99b4QE7N/XskLsQ9
Power Platform Community / Forums / Power Automate - Building Flows / Slow sharepoint update
Power Automate - Building Flows
Answered

Slow sharepoint update

Like (0) ShareShare
ReportReport
Posted on 23 Sep 2020 08:59:47 by Thansson 512

Hi

 

I have made a flow to update from excel in document to a sharepoint list on the same sharepoint place.

(For use in a powerApp). Runs without failure.

 

There are about 1600 rows to be updated, this takes more than 1 hour. We have to do this 3 times a day, so this is to slow for us.

 

The flow stops at 1600 rows, I have the settings to 5000?

 

Is there a way to make this faster?

 

 

Snap.JPG

  • Thansson Profile Picture
    Thansson 512 on 20 Jun 2022 at 05:33:06
    Re: Slow sharepoint update

    Hi @takolota 

     

    Thank you I will try your solution.

     

    Right now I'am using MS Access, so will be happy with a bette way

     

    Regards

     

    Tony

  • takolota1 Profile Picture
    takolota1 4,917 Moderator on 14 Jun 2022 at 02:27:37
    Re: Slow sharepoint update

    You could try using a batch update to really speed things up & reduce the number of API calls required.

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-External-Data/td-p/1365410

  • Thansson Profile Picture
    Thansson 512 on 23 Sep 2020 at 13:38:26
    Re: Slow sharepoint updatek

    Ok not good

     

    Do you know why it only update 1600 rows, I have 1637 rows ?

  • Verified answer
    ChristianAbata Profile Picture
    ChristianAbata 8,949 Most Valuable Professional on 23 Sep 2020 at 13:29:11
    Re: Slow sharepoint update

    @Thansson  I don't see more ways, see the time depends on the API allways and if the API is slow reading your flow is slow too

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans