5 Power Apps Performance Tips

[@venkatasubbaraopolisettymv3802]

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

[@ShanesCows]

I appreciate your kind words. 😎 Have an awesome day!

[@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.

[@ShanesCows]

Glad it was helpful! Thanks

[@afasbender]

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

[@ShanesCows]

Happy to help!

[@anujpathak1817]

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

[@ShanesCows]

Thanks and noted. Have a good day!

[@geralddahl9159]

Agreed re request for formulas video, and can you please consider unpacking concurrency somewhere (in a video or a short)? Thanks, @ShanesCows

[@katielux357]

Hey Shane, is Formulas an upcoming feature we need to turn on? Perhaps "Named formulas"?

[@thomasnott9367]

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?

[@ShanesCows]

Nope, Patch doesn't have an OnSuccess. So with Patch it would be a ; and then whatever you want to happen next.

[@thomasnott9367]

@@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.

[@ericcross6017]

Always appreciate your videos Shane. Thanks so much!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@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

[@ShanesCows]

Thanks Warren! Awesome jobs in the forums. You are a ROCK STAR! 🧑‍🎤

[@stefancochrane2723]

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.

[@ShanesCows]

Nice. That is perfect! 😎

[@rachael5063]

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?

[@ShanesCows]

Sorry, I haven't done that one.

[@imax8307]

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.

[@ShanesCows]

Glad it was helpful! So many little performance mistakes people can make.

[@Mishralock10]

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?

[@ShanesCows]

I will think about it but I haven't done anything like that so far.

[@Mishralock10]

Thanks @@ShanesCows , looking forward to it 🙌

[@ConfidencePoint1]

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

[@ShanesCows]

Go to www.powerapps911.com and you can put something in our Free help and see if we can offer any ideas.

[@MMKhat-gl8km]

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

[@ShanesCows]

It only reads not sends as far as I know.

[@kaushar.]

Thank you Shane. This is amazing.

[@ShanesCows]

Happy to help!

[@nacimhoc]

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

[@ShanesCows]

Glad it was helpful!

[@rayromych5534]

Great explanations, thanks a lot for your work!

[@ShanesCows]

You are welcome!

[@saeedsm57]

Absolutely useful! Thanks!

[@ShanesCows]

That is great to hear. Thanks

[@marksmith8021]

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?

[@ShanesCows]

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

[@marksmith8021]

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

[@ShanesCows]

@@marksmith8021 hit us through www.powerapps911.com contact form. We are happy to help non-profits and have discounts.

[@bhanuprakashbysani3071]

Is there any timeout will be there for respond to powerapps/ powerautomate action ?

[@ShanesCows]

90 seconds.

[@bhanuprakashbysani3071]

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...

[@GroverParkGeorge]

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

[@ShanesCows]

IT is pretty cool. I should probably do a full video on Formulas. 🤔

[@OzStomper]

​@@ShanesCowsYES PLEASE!

[@oluwatobipaul6171]

This came me handy. Thank you Shane

[@ShanesCows]

Always happy to help and appreciate your nice comments.😎

[@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.

[@ShanesCows]

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. :)

[@KrishnaveniJothi]

Hi Shane, Is there an option to get WiFi name we are connected to using power apps?

[@ShanesCows]

Nope. Sorry

[@KrishnaveniJothi]

@@ShanesCows oh OK thanks

[@andreykhazhevskiy3230]

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.

[@paolovr1970]

Thanks SHANE

[@ShanesCows]

You are welcome. Have a great week!

[@manojkumarleo]

You are the boss

[@ShanesCows]

Thanks

[@radiosonicfan1726]

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

[@ShanesCows]

That is a fair request. :)

[@willardallen4097]

The current plan is to develop copilot to the point that it can fix everything else, it seems.