web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
Your Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Gallery / Power Apps - Webinars and Video Gallery / Bulk Data Operations (Creat...

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

Views (1274)
RezaDorrani Profile Picture Posted by RezaDorrani 12,145

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

Categories:

 Canvas Apps General PowerApps

Comments

  • Alice_Belle Profile Picture Alice_Belle
    Posted at
    Bulk Data Operations (Create, Update, Copy, Delete, Import) in Power Apps from SharePoint list.

    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?

    Alice_Belle_0-1680062297293.png

    Alice_Belle_1-1680062550481.png

     

    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.

    Alice_Belle_2-1680062589438.png

     

    Thank you in advance for your guidance. Appreciate it. 

     

    Kind regards,

    Alice

     

     

  • Jibu Profile Picture Jibu 4
    Posted at
    Bulk Data Operations (Create, Update, Copy, Delete, Import) in Power Apps from SharePoint list.

    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