5 Power Apps Performance Tips

#powerapps #PowerPlatform #CanvasApps #performance

Struggling with Power Apps performance issues? In this insightful video, Shane Young, a seasoned Power Apps expert, dives deep into practical solutions for common performance challenges faced by Power Apps developers. Whether you're dealing with race conditions, the N+1 problem, SharePoint limitations, or optimizing your app for offline use, this video has got you covered.

Key Highlights:

Understanding Race Conditions: Learn how to manage expectations in Power Apps, ensuring that processes complete in the correct order for optimal performance.

Tackling the N+1 Problem: Discover strategies to reduce unnecessary network calls in your Power Apps galleries, enhancing speed and efficiency.

Optimizing SharePoint as a Data Source: Get expert tips on managing large SharePoint lists, simplifying data models, and when to consider switching to Dataverse or SQL Server for better scalability.

Streamlining the OnStart Event: Find out how to prevent slow app loading times by efficiently using the OnStart event, including tips on concurrent functions and static collections.
Building Efficient Offline Apps: Learn how to minimize data load for offline Power Apps, focusing on essential data to improve performance and reduce corruption risks.

Efficient Bulk Operations: Explore smarter ways to handle bulk operations in Power Apps, and why Power Automate might be a better choice for complex tasks.

This video is a must-watch for anyone looking to enhance their Power Apps' performance, from beginners to seasoned developers. Shane Young brings his extensive experience and practical approach to help you solve real-world Power Apps performance issues. Don't let performance hiccups slow down your Power Apps projects!

Up your Power Apps Skills Today!

0:00 Start
0:24 Power Apps Race Conditions
6:12 Power Apps N + 1 Problem
10:27 SharePoint is TOO BIG
16:50 Power Apps OnStart Delay
19:42 Power Apps Bulk Activities

Do you need some help with something that you are working on, contact us!

PowerApps911

Let's connect on social!

[venkatasubbaraopolisettymv]

Its a must watch video for all power app developers! Thanks Shane for taking time to make this.

[afasbender]

Brilliant as always Shane! You've saved so many of my (work) days, thank you!!

[NarsimhaBanala]

Thank you for the video, Shane! There's valuable information in there that every Power Apps enthusiast should be aware of. These tips are essential for optimizing the performance.

[ericcross]

Always appreciate your videos Shane. Thanks so much!

[stefancochrane]

Thanks, Shane! Even if the SPO list will only have 500 or so items per year, we put in a plan for archiving data in SPO lists. In much larger lists, we set up a list per year.

[GroverParkGeorge]

I LOVE the ability to put app constants and Enums into formulas.

[anujpathak]

Hi Shane very nice video.I always like your way of presenting the topic it really makes me stick to watch the entire video without skipping for 1 secs. Please create video on how to use formulas

[rayromych]

Great explanations, thanks a lot for your work!

[practicalpowerapps]

Great video as usual Shane and another one I will regularly reference in forum responses. In particular, your observation on complex column types and their problems/limitations is a barrow I have been pushing for a long time, so some supporting comments are very useful.
On the list size issue, I have a number of lists and libraries over 50k, which are child lists with a numeric join to the ID of the parent and so far, have not seen any performance degradation on iPads in the field when the data is queried, so I hope this continues. I am however looking at archiving if this happens.

Warren Belz

[ConfidencePoint]

Great video Shane. I’m facing the n+1 issue in a similar way as you described but the solution seems tricky as I cannot use collection due to heavy data.
Where can I write to you describing the issue

[rachael]

Thanks, Shane! This is really helpful! Do you have a video on how to set up an app for inventory space? Essentially like hotel "reservations" and show a chart on how full the space is every day based on "check-in" and "check-out" dates?

[MMKhat-glkm]

Hello young,
Thanks for all your videos,
I have a question about the function NFC.
I need to sent a " text or number" with NFC in power apps.
I find just the readNFC function to read but to sent I can't do that.

Best regards

[nacimhoc]

Amazing informations given in this video !! Thanks for sharing your knowledge

[thomasnott]

You know with the on submit form button, does this also work with patch? So always put code into the onsuccess on the form after a patch is done on a button?

[imax]

Great video, really useful. I think for some users it's easy to get a working solution but understanding performance at scale is not so obvious.

[andreykhazhevskiy]

Pulling 235 lookups per item in a collection. It is slow, but gives a report that otherwise would be impossible to pull as there is a limit to clearcollect. Any thoughts how to make this run better?

[jjayceeb]

Hi, i have problem in switching screen. Example i navigate to screen 2 .the display is not appearing at the same time. But if i navigate to the next screen its working fine. Please help.

[myrwong]

Regarding SharePoint list size, you tossed around numbers like 10's of thousands on the top end. I have one that currently just passed 600, 000 records. No problems yet, performance for what I'm doing with it is fine. Anything I should watch for? I do reporting from it in Power BI. This 600k table is a child table and have a screen where it shows the child records (usually about 10) for the selected parent. Again, performance seems fine. Also, something you didn't mention was indexing of columns in a list, I did that for those that I filter on frequently. How important is that? Thanks for all you videos by the way.

[Mishralock]

Thanks, Shane, for consistently dropping fantastic videos. I'm currently working on a solution that involves creating an Azure OpenAI-powered chatbot using Power Automate, with Dataverse as the data source. The number of tables could be extensive, and they will all be interconnected. Could you please share a video on building such a chatbot with high accuracy and minimal hallucination?

[radiosonicfan]

Wish Power Apps would stop resizing my other cards when I drag and drop. Instead of fancy AI, give me Microsoft some simple fixes.