web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / HOW TO SUCCESSFULLY UP...
Power Automate
Suggested Answer

HOW TO SUCCESSFULLY UPDATE A SHAREPOINT LIST OF ABOUT 60000 RECORDS FROM AN EXCEL FILE

(1) ShareShare
ReportReport
Posted on by 2
I have a sharepoint list having about 60000 plus records, and i need to update the record with a new file from excel. theres a column known as "Account No" in the excel table, the record matches that in the "Title" of the sharepoint list.
I want to update the sharepoint list if the record exist, else it should create a new record. i have been running this for days now and the flow will either keep throttling or run for ever.
i even split the data into 5000 records in different tables and made different flows for them but still to no avail.
Please can someone help me with the best setting to use, the best way to do this or even if theres an alternative to it
Screenshot 2024-08-18 153749.jpg
Screenshot 2024-08-18 154021.jpg
Screenshot 2024-08-18 153905.jpg
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,968 Moderator on at
    HI,
     
    A couple of suggestions.
     
    1. Create a View, that ONLY has the field being updated, the search column, and any required columns (for instance Title, or any other required) and use that in your Get Items, this will shrink that down
     
    2. In your Yes side, you are using an Apply to each, Don't, you have the single record you need correct?
    Then access the columns directly, using the path
    Remember you only got back 1 record (or should have) so the same way you go the length, you can use the [0] to mean the "first" record returned in the Get items, then just use the proper paths ?[0]?['FIeld1']
     
    This will remove it.
     
    3. Realistically you should be using a Do Until, And i don't see how you are breaking it into 5k chunks in these flows
     
    Lastly, I do not know what your environment limtations are because I dont know the contract you have.
     
    Is every record IN the excel for sure needing to be updated? If not, can you filter out of the 60K in the file, to only those you really need?
     
  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at
    Consider using the SharePoint batch API.
  • takolota1 Profile Picture
    4,980 Moderator on at
    You can batch update & batch create SharePoint items at around 1000 rows per minute using this template

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 252 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 169

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard