SharePoint Batch Update, Create, & Upsert
9.9 هزار بار بازدید -
12 ماه پیش
-
Download Page & Microsoft Community
Download Page & Microsoft Community Thread: https://powerusers.microsoft.com/t5/P...
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 (LinkedIn: kolota) if you want to hire me to consult or build more custom Microsoft solutions for you.
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 (LinkedIn: kolota) if you want to hire me to consult or build more custom Microsoft solutions for you.
12 ماه پیش
در تاریخ 1402/04/27 منتشر شده
است.
9,909
بـار بازدید شده