About
Patch multiple rows in Power Apps like a Jedi!
Using the Patch function in Power Apps is a common way to create and edit multiple rows of data in a data source. There are different ways to use patch, so this sample app gives a detailed overview on three methods:
1) For All
2) Schema matching / Upsert
3) JSON / Parse JSON
Breakdown
Each method has its own screen, where you can understand the performance when used against 100 rows of sample data:
There is also a comparison screen where you can view each method, side-by-side. The limit of sample data you can generate is capped at 500 rows:
Install
Download the PatchMultipleRecordsExamples_1_0_0_1.zip file, then follow this Microsoft Learn Article to import the solution into your chosen environment. Play the app to interact with the walkthrough functionality.
The solution is unmanaged, so you can open in edit mode to see the underlying code and patterns.
License
The solution contains x3 Dataverse tables. Please import the solution into an environment where you have access to interact with Dataverse. You can create a developer environment which gives you access to Dataverse without needing a Power Apps Premium license.
Shoutout
To @RandyHayes for reaching out and providing extra context and guidance with the ForAll approach. Solution updated to reflect his excellent knowledge on this subject.
------------------------------------------------------------------------------------------------------------------------------
Feel free to visit my blog for weekly tips!
https://platformsofpower.net
