5 Power Apps Performance Tips
ฝัง
- เผยแพร่เมื่อ 1 ส.ค. 2024
- #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!
www.powerapps911.com/up-your-...
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!
www.powerapps911.com/contact
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane - วิทยาศาสตร์และเทคโนโลยี
Its a must watch video for all power app developers! Thanks Shane for taking time to make this.
I appreciate your kind words. 😎 Have an awesome day!
Brilliant as always Shane! You've saved so many of my (work) days, thank you!!
Happy to help!
Always appreciate your videos Shane. Thanks so much!
Happy to help. Have a great day. 🐶
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.
Glad it was helpful! Thanks
Absolutely useful! Thanks!
That is great to hear. Thanks
Great explanations, thanks a lot for your work!
You are welcome!
Thank you Shane. This is amazing.
Happy to help!
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
Thanks Warren! Awesome jobs in the forums. You are a ROCK STAR! 🧑🎤
This came me handy. Thank you Shane
Always happy to help and appreciate your nice comments.😎
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.
Nice. That is perfect! 😎
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
Thanks and noted. Have a good day!
Agreed re request for formulas video, and can you please consider unpacking concurrency somewhere (in a video or a short)? Thanks, @ShanesCows
Hey Shane, is Formulas an upcoming feature we need to turn on? Perhaps "Named formulas"?
I LOVE the ability to put app constants and Enums into formulas.
IT is pretty cool. I should probably do a full video on Formulas. 🤔
@@ShanesCowsYES PLEASE!
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.
Glad it was helpful! So many little performance mistakes people can make.
Amazing informations given in this video !! Thanks for sharing your knowledge
Glad it was helpful!
Thanks SHANE
You are welcome. Have a great week!
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?
Sorry, I haven't done that one.
You are the boss
Thanks
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
Go to www.powerapps911.com and you can put something in our Free help and see if we can offer any ideas.
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?
I will think about it but I haven't done anything like that so far.
Thanks @@ShanesCows , looking forward to it 🙌
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.
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?
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
It only reads not sends as far as I know.
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?
Nope, Patch doesn't have an OnSuccess. So with Patch it would be a ; and then whatever you want to happen next.
@@ShanesCows ah cool, thought as much! Just wanted to make sure, thanks for taking your time out to reply. Your videos have really helped me in my job. Thanks.
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.
Yeah, I should have mentioned Indexing. That helps. As for list size. This is a classic example of "it depends". :) If you are mostly writing data it works fine at large sizes. If you are trying to search and edit data the number comes down. I had a customer management app that had 30,000 records in SharePoint that ran terrible because it was very transactional.
If your app is working as is, don't over think it. :)
Is there any timeout will be there for respond to powerapps/ powerautomate action ?
90 seconds.
Thank you Shane for quick response, it would be great if you can explain how to handle that kind of scenario in your future videos...
Hi Shane, we have several powersapps that have been running for about 2 years. In the last two weeks we have gotten "Error when trying to retrieve data from the network". We haven't changed any SQL data sources. We use the app from within Teams (old teams and new teams)
Any suggestions to look at?
Most likely someone changed some of the Azure firewall permissions. I would check and see if any of this helps learn.microsoft.com/en-us/power-platform/admin/online-requirements
Man u are fast! I will look into it. I am also interested in having my team join your 911 support team. We are a Non Profit food bank and a bunch of hacks
@@marksmith8021 hit us through www.powerapps911.com contact form. We are happy to help non-profits and have discounts.
Hi Shane,
Is there an option to get WiFi name we are connected to using power apps?
Nope. Sorry
@@ShanesCows oh OK thanks
Wish Power Apps would stop resizing my other cards when I drag and drop. Instead of fancy AI, give me Microsoft some simple fixes.
That is a fair request. :)
The current plan is to develop copilot to the point that it can fix everything else, it seems.