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

[ellenmurtha]

Thank you for another helpful video! I have actually been using the Patch(datasource, collection) function for the past few years after I learned it from your video "PowerApps Save Data - Patch, Collect, and ForAll" that you posted in October of 2018. In your Halloween app you referenced it as the "Save - Easy Way" to upload data into the data source. I have used it ever since and was glad to see it again to help reinforce that it is faster than some of the other methods I have tried. Thank you for all the great tips!

[nicholassauter]

Thank you so much! I have been having issues with performance and this helps me on the right track for improvements and monitoring!

[ricardobunge]

Absolutely BRILLIANT! #TIL x 2, and both of high value to clients. Thanks for taking the time to put it together!

[dougydoe]

Excellent piece Shane! Understanding how things work behind the scenes is key to becoming proficient in the use of the tool. Thank you

[jray]

This was a great video, very informative. Good to know how some things have been described as faster when they aren’t.
I’ve been using patching to the collection any changes and then patching the whole collection to the data source at once. That way I’m only hitting my external data source once

[jeanobandobacca]

Truly amazing Shane, the Patch Collection to data source tip is a revolution. Thanks!!!!

[tfs]

Great content as usual Shane... Nice to come across that patch collection trick. Keep up the good work..

[kingsleyudeagha]

Nice. Lovely to know I witnessed the string of tweets that inspired this video. Thanks for taking out the time to show this Shane.

[PowerAppsTutorial]

This is some really good stuff, Shane. Absolute gold. 😄👍👍

[MT-otsg]

Awesome - thanks a lot! I already changed my Collect(Datasource, Collection) with Patch(Datasource, Collection) in a few apps and it works much better/faster!

[oluwatobiyusuf]

Thank you Shane. I gained a lot from this video especially the patch function discovered by Matthew. I am also curious to know which functions are your favourite top 2 since WIth function is the third on your list

[Mglatje]

Great stuff again. Big thanks for sharing all your finding!! 🤩

[pranavkahol]

Hi Shane
Great Video!!!
Thank for the guidance and also love for Chewy❣️

[cesaritriago]

Great video, great content as usual!!! I always recomend your Channel to evertone Who want ti work with Powerapps 😉

[kingsleyudeagha]

Yes Mattew's syntax needs a solid recognition 👏 . Great stuff

[b.o.b]

This is massive! Thank you Shane. I work with folks in low connectivity areas so syncing performance has always been a massive issue.
For the Patch(Dataverse, Collection) is there a need to ensure that all columns are downloaded in the collection to work properly or can you use the option to only call on used columns?

[emmanuelmaceda]

Awesome Shane! Thanks for this vid! One question: if you pulled your collection via Power Automate with no metadata, would you still be able to patch as a collection? I'm guessing not because Power Apps won't be able to match the schema?

[alanmcconachie]

Your videos are all excellent but it takes me hours to watch each one as I keep having to switch back and forth to my real world problems and put the video into practise. Thanks for your insight its definitely making me a better PowerApp'er

[michelhegeraat]

Great to see this compare between Sharepoint, SQL and Dataverse, Shane. And bringing in monitor is also top-notch. Matthew's site is really packed with useful stuff and great insights.

[Waineo]

Shane, you're honestly so helpful. Thanks so much for putting all your masses of content together and pushing the human race forwards!