PowerApps Performance Optimization - Use Monitor to understand Patch of data sources

There are a lot of Power Apps Performance Optimization myths out there. In this video we will do our best to debunk them. And how do we debunk a myth? By using the PowerApps Monitor Tool to test different Patch formulas. We discuss LookUps, Variables, With, and even hard coded records and their effect on performance. Good news? One way is clearly better than all of the rest. 😍 Then we go a step further and talk about bulk uploads using ForAll, Collect, and even Patch itself. I learned a new technique here and the best part. One is exponentially faster than the others. As far as Data Sources go, we cover them all also. SharePoint, SQL Server, and Dataverse performance are all discussed.

0:00 It Starts
2:06 Overview of the data sources for PowerApps Performance tuning. SharePoint, SQL Server, Microsoft Dataverse
2:38 Patch with a Lookup inside vs. Patch inside of a With that does the LookUp
4:02 Myths about With. The With function doesn't do magic.
4:48 Using the PowerApps Monitor tool for PowerApps Performance Monitoring
10:02 Does setting a variable first make Patch faster? Nope
11:10 Patch using the ID directly is faster.
14:13 Talk about Microsoft SQL Server behaves exactly like SharePoint Online does in these scenarios
15:09 Talk about how Dataverse uses a GUID for the primary key
16:11 Lets discuss bulk updates to the data source starting with ForAll
18:20 Proving that Collect is not faster than ForAll for creating new records in SharePoint and SQL
19:38 Quick comparison of ForAll vs. Collect including how they deal with new vs. existing records
20:17 A new way to use Patch with collections for the ultimate in performance
25:29 Explaining how Collect acts differently for Dataverse vs. SharePoint or SQL
26:04 Explaining some of the weirdness you may see in Monitor, especially when you are trying to make the same update twice in a row
28:54 PowerApps Monitor Settings

Matthew Devaney blog post https://www.matthewdevaney.com/patch-...

Power Apps Consulting and training at https://www.PowerApps911.com