Bulk Data Operations (Create, Update, Copy, Delete, Import) in Power Apps from SharePoint list.

RezaDorrani · ‎09-21-2021

Hello everyone,

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).

Topics covered:

✅ Create checkboxes for bulk item selection

✅ Create multiple records

✅ Update multiple records

✅ Delete multiple records

✅ Copy multiple records

✅ Import (copy & paste) Excel data

✅ Record grid updates in a collection and patch all the changes with a single query (performance boost)

#PowerPlatform #SharePoint #BulkUpdates #EditableGrid

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

watch?v=P6yqIpjmPrs

Jibu · ‎08-15-2022

Hello @RezaDorrani ,

I am a fan of your videos and has been using these to make apps related to my work. Recently I was making an app which needs to get data from CSV file to the sahrepoint list, but I am facing an error in the final code when I try to Patch the details to sharepoint list.

I have a column which is a lookup column in sharepoint and the second column is a text field, but in the code an error is coming that the data type of these arguments are not 'Record'. Can you please help with this?

Thanks and Regards

jibu Jacob Joy

Alice_Belle · ‎03-28-2023

Hi Reza, I encountered 2 problems from this video when I tried to replicate the apps. Seeking your kind assistance to guide me on how to resolve:

1. Bulk update from csv - there is error prompted for the logic "Result", may i know how can I fix this?

2. GridGallery - copy paste directly from Form to to the GridGallery creates additional lines item for Approver column. As per your advise, instead of ComboBox, i changed it to DropDown List, however, may i know how can i fix the dropdown list to view the contacts similar to combobox view? Currently there is no data in the "Approver" even though there are data in the Sharepoint List.

Thank you in advance for your guidance. Appreciate it.

Kind regards,

Alice