Announcements
Does anyone have a solution to bulk update content to a sql table using a csv file. I found a solution to import new records based on the end of Reza's video here: Power Apps Bulk Data Operations | Create, Update, Delete, Copy & Import | SharePoint List - YouTube.
But would it be possible to do the same to bulk update data using a lookup function on a collection?
Thanks
This really does depend on the datasource and end table. If it is a one off i have regularly done this by adding the data as an excel online or static table to an app temporarily and using ForAll and Patch to do it. If its a more regular thing i look to powerautomate
You could also try using this batch SQL CRUD template:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 409 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 252 Most Valuable Professional
