{"id":133,"date":"2018-01-05T12:41:20","date_gmt":"2018-01-05T20:41:20","guid":{"rendered":""},"modified":"2025-06-11T08:10:20","modified_gmt":"2025-06-11T15:10:20","slug":"bulk-update-using-forall-and-patch","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/bulk-update-using-forall-and-patch\/","title":{"rendered":"How to bulk update records in PowerApps"},"content":{"rendered":"

A lot of you would have come across a scenario where you want to bulk update records.<\/p>\n

Maybe you are taking some photos and want to upload them all at once. Or you want to flip certain flags in your data and update the source. Or you have to submit a timesheet with a week\u2019s data at once.<\/p>\n

I\u2019ve detailed out different solutions to achieve this in the blog below.<\/p>\n

Scenario<\/h1>\n

Assume you have a checklist of tasks to do. When you are done with a few tasks you can mark them as complete. You could extend this scenario to a Product Launch checklist, Home Inspection checklist and so on.<\/p>\n

I\u2019ve created a simple checklist where I can check off tasks related to my blogging or posting on social media. I\u2019ll not get into the details of building the app here. Below is the excel screenshot containing the Checklist items. My table on the excel is called as ChecklistItems. <\/b>You can find the excel here<\/a>.<\/p>\n

I\u2019m using Collections to demo this. The approach works for any backend of your choice.<\/p>\n

\"clip_image001\"<\/a><\/p>\n

I\u2019ve imported excel data as static data into my PowerApps application. On the OnStart, I collect the excel ChecklistItems<\/b> data into ChecklistItemsSource<\/b> collection. Throughout the application we will use the ChecklistItemsSource<\/strong> as our source data.<\/p>\n

We have a simple 2 screen application<\/p>\n