PowerApps bulk update collection with Patch

This video on PowerApps bulk update collection with Patch walks you through how to efficiently perform bulk update of records using Patch function in Power Apps. We will bulk add, copy & delete filtered items from a gallery. We will perform bulk operations using Microsoft Dataverse & SharePoint as a data source. Important to Patch multiple records without using the ForAll function for better performance. Instead, we will store the bulk records in a Collection and directly Patch our data source with the Collection data.

Download the solution (includes App and tables) from my GitHub repo.

My good friend Matt also wrote a nice blog article on using Patch with collection data -

#PowerApps #Patch #BulkUpdate #BulkCopy #BulkPatch

[mikhailk]

Reza, I regret that I cannot give one million likes for this video. I have reduced the time it takes to save the entries to my SharePoint list right now from 2 minutes to just 6 seconds thanks to your video. And it took me less than 5 minutes to change the code. Thank you so much for your tutorial, it has been a great help!

[hsaxena]

Where were you all these years. I have been struggling with PowerApps and flow for bulk update. Thank you so much. I'll implement these changes ASAP.

[Vihushrihu]

Reza, my search for a clear, conceptual instructor has ended. I have found a great mentor and teacher in you. You are awesome brother !

[saxhigh]

Exactly what i needed to see right now. Thanks Reza. Official doc's are not covering these scenarios and even the blog you shared doesn't go beyond the speed aspects. Shame documentation or blogs aren't more available.

[richardbird]

Outstanding Reza... please continue making these videos as they are pure gold

[debpriyaacharya]

Awesome, after struggling with several issues, it is always your video that provides the best solution.

[ThisIsFrederic]

Hi Reza
Thank you for taking the time to share your knowledge with us!
I have created a similar app with a bulk select feature, using Dataverse as a backend. Once records have been patched into the database (code of the On Select button being totally executed), the gallery may take a few seconds to reflect the changes made.
In that case, end-user can still select an item in the gallery that looks brand new, and click update. Consequently, because the new database ID of the record is not yet showing in the gallery, a duplicate record is created upon patching.
And since there is no On Refresh event for galleries, it's difficult to know when the gallery reflects the changes made in the backend (refreshes are not synchronous).
I am sure you have already faced this use case, and I am curious to know how you are dealing with it. Thanks!

[tenisviejos]

Reza, this is a godsend. It's brilliant how much time and performance you get by doing things the proper way.

[bhainsley]

Valuable, valuable technique and tutorial. Thank you for your patience in developing this resource.

[Bekesam]

Thanks Reza! Really needed the performance enhancement you provided!!

[ehabatme]

Great Video.
Bulk operation is a must activity in PowerApps

[unni]

Hi Reza you are genie whenever i end up road block in power apps i search and always found a solution or you guided me to the same awesome content each and everyone of them

[ricardoirineo]

For reference, if someone wants to use the ID of added items in this method, you do need to include the ID column in your collection, otherwise the ID won't be present in the returning collection. You can use Blank() as the value to add new items, the Patch return collection will include the correct ID value then.

[lauramay]

Hello Reza, I find your videos such a valuable resource. Thank you.

[vpavan]

Great video and learning morning morning. I have implemented the collection technique for delete and update but never tried the copy / duplicate approach, good tip Reza!

[revanerraboina]

I have learnt a lot from your videos more than I have learnt in my 4 years of B.E... Reza, could you please create a video on how to create the view that is being presented in this video with the drop downs and buttons?

[JoStone]

Reza, this is great and helps me to achieve better performance and make a lot of things easier. Thank you so much!

[ankushjain]

oh waaow ..this technique help alot .Thanks so much Reza for a great tutorial

[vkrish]

Great tutorial!!..my long time search for a clear instructor has ended as you have consistently proved your expertise. Thank you Reza!!!

[marcvilleneuve]

Awesome video, just what I needed at this time👋