This video on is a stepbystep tutorial on performing Bulk Data Operations in PowerApps with a SharePoint List. We will bulk create, update, copy, delete & import records into our Gallery as an Editable Grid. Important to Patch multiple records without using the ForAll function for better performance. We will store the bulk records in a Collection and directly Patch our SharePoint List with the Collection data.
Video includes a bonus tip of importing bulk data import into gallery (grid) from an Excel file (CSV).
Here's a link to download the Bulk Update Editable Grid from my GitHub repo:
https://github.com/rdorrani/PowerApps...
Power Apps Editable Grid Part 1 :
• Editable Grid in Power Apps | SharePo...
Background Image Generator from Hiro ( / mofumofu_dance )
https://powerusers.microsoft.com/t5/C...
#PowerApps #SharePoint #Excel #EditableGrid #Patch #BulkUpdate
Video covers the following:
✅ Create gallery checkboxes for bulk item selection (with check all feature)
✅ Add / Create multiple records / items in SharePoint from Power Apps
✅ Update multiple records / items in SharePoint from Power Apps
✅ Delete multiple records / items from Gallery & SharePoint from Power Apps
✅ Copy multiple records / items in SharePoint from Power Apps
✅ Import (copy & paste) Excel data into Power Apps & Save in SharePoint
✅ Record grid updates in a collection and patch all the changes with a single query (performance boost)
Table of Contents:
00:00 Intro
00:32 PowerApps Gallery as Editable Grid
01:08 Add Checkboxes to Gallery control in PowerApps
05:12 Build Create Items in SharePoint List from Power Apps
06:57 Build Copy Items in Gallery based on checkbox selection
09:40 Delete multiple items from Gallery and Patch to SharePoint
12:09 Bulk Edit / Update Items in Gallery and Patch to data source
16:32 Import data from Excel into collection & load in Gallery (copy paste from excel / csv)
24:26 Subscribe to Reza Dorrani Channel