SharePoint Batch Update, Create, & Upsert

Download Page & Microsoft Community Thread: https://powerusers.microsoft.com/t5/P...
Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team.
In the meantime, here is a Google drive link to a zip folder with solution imports for most of my projects: https://drive.google.com/file/d/1-hZm...

David Wyatt's Flow Optimization Post: https://www.linkedin.com/pulse/top-5-...

Microsoft Batch API Documentation: https://learn.microsoft.com/en-us/sha...

Paul Murana's TachyTelic Blog: https://www.tachytelic.net/2021/06/po...


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.


Venmo
https://venmo.com/u/Tyler-Kolota

PayPal
https://www.paypal.com/paypalme/takol...

Buy Me a Coffee
https://www.buymeacoffee.com/takolota


Thanks for any feedback,
And reach out on LinkedIn (  / kolota  ) if you want to hire me to consult or build more custom Microsoft solutions for you.