Power Apps Bulk Data Operations | Create, Update, Delete, Copy & Import | SharePoint List
105.4 هزار بار بازدید -
3 سال پیش
-
This video on is a
This video on is a step-by-step 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 (Twitter: 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
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 (Twitter: 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
3 سال پیش
در تاریخ 1400/06/30 منتشر شده
است.
105,445
بـار بازدید شده