SharePoint Batch Update, Create, & Upsert

Download Page & Microsoft Community Thread: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-Create-and-Upsert-SharePoint-Lists/td-p/1365410

David Wyatt’s Flow Optimization Post: https://www.linkedin.com/pulse/top-5-ways-optimize-your-flows-david-wyatt/?trackingId=X9bMmnTZ2QBuu48HJ29wQA%3D%3D

Microsoft Batch API Documentation: https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/make-batch-requests-with-the-rest-apis

Paul Murana’s TachyTelic Blog: https://www.tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

Compared to the using the basic Apply to Each, Get items, & Update item approach on large amounts of data, this method requires a small fraction of the API calls towards the daily action limit and drastically reduces flow run-times.

It’s currently set to take data from any Excel sheet and update records in SharePoint with corresponding data. It works with any potential Power Automate data-source, including HTTP API GET requests, but Excel provides a simple example.

Part of it works like a Vlookup function where it identifies if a row of updated data in Excel has some set values in it and matches it to the SharePoint record ID with those set values. Then it uses the batch update method to update those SharePoint records and it uses the batch create method to create new items for any records without a match.