Top 25 Power Apps Tips, Tricks & Best Practices for Makers
Вставка
- Опубліковано 6 сер 2024
- This Power App Tutorial video includes TOP 25 Microsoft Power Apps tips, tricks and best practices. The Tips, Examples, performance optimization techniques and How To's showcased in video are built keeping Power App makers (beginner, intermediate) in mind.
Top 25 PowerApps Tips & Tricks include:
🟣 Select the right data sources for your Power Apps
🟣 Power Apps connectors
🟣 Know your PowerApps license
🟣 Limit number of data connections in Power Apps
🟣 Power Apps coding standards and guidelines
🟣 Code commenting and formatting
🟣 Formula Reference Guide for PowerApps
🟣 Use Monitor Tool
🟣 Power Apps UI design, using HTML control, Modern fluent controls, UI inspiration, etc.
🟣 Power Apps Components and Component Libraries
🟣 Make configurable components, 10 reusable components & Creator Kit
🟣 Power Apps Delegation for Beginners (working with 500 or 200 delegable limit)
🟣 Minimize Power App controls (not more than 500 per App)
🟣 Optimize Power Apps On Start function
🟣 App Checker: Remove unused variables and media files
🟣 Reset multiple controls in Power Apps
🟣 Avoid if condition for Boolean outputs
🟣 Nested if else Vs Switch function - Power Fx
🟣 Using With function to avoid repeated formulas
🟣 Use Variables and Collections
🟣 Cache lookup data, avoid N:1 query in Galleries, nested galleries
🟣 Use Version Notes and Publish Power Apps regularly
🔗 Helpful Links:
PowerApps canvas app coding standards and guidelines:
pahandsonlab.blob.core.window...
Power Apps Formula Reference:
learn.microsoft.com/en-us/pow...
Comparing Microsoft Lists, Dataverse for Teams, and Dataverse:
learn.microsoft.com/en-us/pow...
Tips and best practices to improve performance of canvas apps:
learn.microsoft.com/en-us/pow...
powerapps.microsoft.com/en-us...
Power Platform Release Planner:
experience.dynamics.com/relea...
Power Apps Components:
• Power Apps Components
learn.microsoft.com/en-us/pow...
powerapps.microsoft.com/en-us...
Power Apps Delegation:
• Power Apps Delegation ...
learn.microsoft.com/en-us/pow...
Debug Power Apps with Monitor:
learn.microsoft.com/en-us/pow...
Power Apps Playlist for Beginners:
• Power Apps for Beginners
Power Apps Playlist:
• Power Apps
CoE Toolkit Theming Components:
learn.microsoft.com/en-us/pow...
Common sources of slow performance for a canvas app:
learn.microsoft.com/en-us/pow...
Power Apps WITH Function:
learn.microsoft.com/en-us/pow...
Microsoft HR uses the Power Platform to transform employee experiences:
powerapps.microsoft.com/lv-lv...
#PowerApps #PowerPlatform
Table of Contents:
00:00 - Introduction to Top 25 Power Apps Tips, Tricks & Best Practices for Makers
00:21 - Select the best data source for Power Apps
01:07 - PowerApps connectors (standard vs premium)
01:33 - How to find out your license in Power Apps (license plans)
02:07 - Limit data connections in Power Apps
03:49 - Power Apps Canvas coding standards and guidelines
05:11 - Comments in Power Apps formula bar - single line and block comments
05:55 - PowerApps formula reference (Power Fx)
07:13 - How to get latest authoring version of Power Apps and Track release planner (new features)
08:25 - Power Apps design ideas and examples
10:02 - Hide the top navigation bar when running Power App
10:40 - Use Components in Power Apps
11:51 - Examples of Power Apps Components
12:43 - Power Apps delegation for Beginners
14:32 - Using Monitor tool in Power Apps
16:04 - Power Apps performance optimization - Limit number of controls
17:46 - Optimize App OnStart function
19:21 - Power Apps performance improvements - remove unused variables and media
20:05 - Power Apps formula optimization
20:43 - Bulk reset controls in Power Apps
21:44 - Power Apps Switch Function
22:15 - Power Apps With function
23:19 - Use Power Apps variables
24:23 - Cache data to Power Apps collections for improved performance
25:35 - Power Apps Version Notes
26:19 - Re Publish your Power Apps
26:48 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani - Наука та технологія
I always learn something new from you Reza! That mass reset method of resetting controls was 🤯. Thank you as always for your contributions and efforts to the Power Platform community!
Happy to hear that! Thanks so much for watching.
@@RezaDorrani Was that reset function the correct way around? Your video has the variable set to false then true. However Microsoft states it's the other way around.
"Reset property can be done from a Button control with the formula Reset = Button.Pressed or from a variable with Reset = MyVar and toggling MyVar with the formula Button.OnSelect = Set( MyVar, true ); Set( MyVar, false )."
@@craigl75 It does not matter as long as variable state is changed to true at one instant.
Both should work.
Applied it immediately to my app but unfortunately is does not work with the modern checkbox control. Any solution?
Hi Mr Reza please kindly advise i hv an error when trying to retrieve data from the network
How to solve the issue sir ?
Thank you Reza! Brilliant, this one 25-minute video worth a year of experience for someone.
Thanks Pavel
Never clicked on a video as quickly as I did for this one. Appreciate the content as always!
Blaze(ing) ⚡
Thanks so much!
Great tip on limiting the number of controls. I went from 64 button controls to 8 galleries to control my app navigation. Thanks!
Fantastic!
I Recently started developing apps in power apps and thank god I discovered your channel. I was able to put together what I just needed in matter of days thanks to your awesome content. Thanks for putting these invaluable videos together.
Awesome! So glad to hear that. Thanks so much for watching and learning from the videos
Thanks, Reza, I've learned a ton from all your videos. I really appreciate you and all your work.
Thank You Rob 🙏
Great video, I did a best practice presentation a few weeks ago and several of your top 25 was on my list with some additional information. Enjoyed your video, thank you
Thanks Shawn!
Your videos have been an absolute lifesaver for me as I've been diving into the world of PowerApps. Your explanations are clear, your tutorials are well-structured, and you make learning this complex tool seem so much easier.
I really appreciate the time and effort you put into creating these tutorials. They've not only helped me in my professional work but have also sparked my interest in exploring more about PowerApps. Keep up the fantastic work, and please know that your efforts are making a real difference for learners like me. Looking forward to more amazing content from your channel! 👏🙌😊
Thank You so much for your kind words.
I am so happy to hear the feedback. You made my day!
Regards,
Reza
Thanks for a great video. Your help to Power Platform community is immense.
Most welcome Sampath
Great video Reza. I learn a lot from the 25 tips and tricks. Thank you Reza
Glad to hear that! Thanks for watching.
thank you Reza for all your videos. I learn a lot to optimize my devs and find solutions to realize them
Happy to hear that!
Always learning something new, keep up the good work, and thank you for the insightful information.
Thanks Anathi
Incredible video again Reza. You are the best!
Thank You Richard!
Reza you are a continual wealth of knowledge! Thank you again for sharing your insights and helping us to build apps more efficiently.
Thanks so much
Brilliant! Thank you, Reza!
Most welcome
Thank you so much for sharing your knowledge with the world. I have learned so much from watching your videos.
Most welcome and thanks so much for watching the videos.
Helpful tips given in the video. Thanks.
Happy to hear that. Thanks for watching.
Thank you so much for sharing Reza! 👍
Most welcome!
Very Important video. Thank you!
Most welcome
Excellent video Reza, you make things so easy to understand, thank you for the explanations.👍
My pleasure!
You are so freaking amazing! I am learning so much.
Thank you!
Great video as always.
I don’t know if your content is only targeted to developers, it would be nice to have content for ops in teams, staging and production environments after you publish your app.
ALM, solution management best practices, ETL (dataflows), integration with power automate, powerapps monitor in production scenarios
Cheers 🤜🤛
Solutions & Env. Variables - ua-cam.com/video/Xo-TvZ9N3BM/v-deo.html & ua-cam.com/video/BFGcXSAgawM/v-deo.html
Dataflows is in my backlog.
Appreciate this video Reza! It was packed full of helpful tips. Learned a lot from this video.
Thanks Brian
Thank you Master ,Magician Reza !
You are very welcome
Excellent tips. Thank you!
You are so welcome!
Just fabulous !! (As always) 🙂
Thank You 😊
Awesome! You said Hello everyone again! 😃
Someone reminded me that I forgot in last few videos :)
Was it you? 😊
Thank you Reza, you're the best 👏
Thanks
Thanks Reza. You're the best. ❤️
Thanks Safa
Great video! 🌟
Thank You
Awesome as always
Thank you so much!
absolutely fantastic thank you Reza
Most welcome
Today something we learned newly. Thanks Reza brother
Most welcome 🙏
Reza 🎉. Hurray some of the best tips ever. 👏 great job
Yay! Thank you!
Such a valuable content from you reza thanks a lot for the awesome content keep help to people's....by your videos...
Thanks a ton
Just clicked like like before viewing. #NoRegrets 👍🏻
Thank You for always being supportive of the videos!
This was really a useful video. Thanks Sir.
Most welcome
Excellent stuff, Reza.
Many thanks!
Best tip is at 26:48... thx for the great content, Reza!
Thanks Tom :)
This is awesome Reza.
Thanks
Awesome work RD
Thank you! Cheers!
excellent , thank you so much
Welcome!
These practices make aap more performant shopping with the best user experience
Glad to hear that
What a content !!! Too good. I joined you from 1st tip... what flawless presentation.
Thanks Prashant. So happy to hear the feedback. This was a tough video to build.
@@RezaDorrani Literally.. the edits, the details, that was like pro editing... No one will skip a single second.. so much of new things I saw today. Really happy to find you.
@@prashantvedpathak3067 Much appreciated! I spent hours editing this one. Glad to know it was well worth it.
@@RezaDorrani I found you on LinkedIn. I have reposted. Many will know now. Following you back on LinkedIn now. Please carry on the great work.
@@prashantvedpathak3067 Thanks for sharing
Thanks!
Thank You
Very informative, Thanks Reza
Thanks Ali
Wow thanks !
Most welcome!
The most famous person of Power Platform on the web🤩
Wow! Thank You 😊
Fantastic 😊
Thank you! Cheers!
Wow thanks Reza 🙏🙏🙏
Welcome
excellent sir,
Thanks
Great Tips & Tricks 🎉🎉
Glad you like them!
Awesome 👏
Thank you! Cheers!
Thanks again Reza
Most welcome!
Nice one, Reza 👏 i was hoping you would cover the named formulas as well.
That was covered in a different video. Check ua-cam.com/video/_I4tpoLI8aw/v-deo.html
Thanks Reza 👍👍💥💥
Thanks for watching Spen
Wow! Not Top 5 or Top 10 tips but 25 tips!!
Hope they were all worth it!
you are a legend, keep going
Wow! I’m no legend but I will try and keep going :)
@@RezaDorrani what you do for us is so helpful and save us time and efforts to the journey of learning
Thank you
Most welcome
Awesome
Thanks
Hello Reza, Many thanks for this tutorial. I wish if you can please make a detailed video on Creator Kit. It would be great if you can explain how to use it, the features of it with small use cases with example. This would be a great tutorial in my opinion as there is not much stuff available yet. Many thanks.!!
Thanks.
I make videos when I receive multiple requests on a topic. Every 6-8 months I ask subscribers for topic suggestions on Community tab of my channel. Most voted ideas get added to my backlog. I recommend posting this idea whenever I make the next topic suggestion post
@@RezaDorrani sure Reza, I will definitely vote for that the the pole is open next time. Many thanks..!!
Very useful tips Reza
Thanks a lot
Thanks Raza! You got to create complete PowerApps course. From beginner to expert. I will definately pay for this one!
Glad to hear that! I do have plans for live training in future. Nothing final as of now.
Agreed! If we can have a series if videos from beginners to expert level with examples that would be great
@@royalhandloom That would be a series of live training videos.
Based on a specific use case. Service Agreements haha. Warts and all including resolving issues. Brave but real!
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ua-cam.com/users/rezadorranijoin
Hey it’s my video recommendation! ❤
Hope the recommendation was worth it!
Hi Reza, great content as always, can you make a role-based power app tutorial in near future??
I have done that in the past :)
ua-cam.com/video/J-hMMXrKMVE/v-deo.html & ua-cam.com/video/fbDQH0vIsN8/v-deo.html
@@RezaDorrani cheers Reza!
Thanks Reza
👍
Hi Reza , again a master piece from you. One of the details that App should not contain more than 500 controls. Is there any easy way through which i can count the total number of controls of my App ?
I don’t believe there is a direct way to count. You can use the code review tool. It shows number of controls per screen.
Hi Reza, thanks for th video.
Do we have similar video for model driven apps? Here most of the tips are related to canvas.
I do not have a video on tips for model-driven apps
Top notch explanation! Simply brilliant and very useful for power app developers.
Glad it was useful. Thanks Anandh!
Very knowleadgable video. From which app or software you have install in your laptop to create video
Thanks!
I use Camtasia
@@RezaDorrani I suppose you must be using License version of Camtasia. How much one have to pay to buy the license version ?
@@LearnPowerPlatformWithAbhinav Yes, I have the licensed version. Check price on camtasia web page.
Thank u for the videos!
i have a question, off topic, but i didnt find answer..
i have a managed metadata column in sharepoint. it's open and aloowing fill in. it works in sp.
in powerapps there is a combobox with this column. i was wondering how users can add new item in powerapps?
Thank in advance
I have done not work with managed metadata columns in power apps.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani 🙏
Hi Reza, is container or group considered a component as well which will add the count of components in an app?
Container - Yes.
Group - I am not sure.
Hi Reza, Thanks for the video. Is there any chance that getting this service desk solution for my lab practice. Thank you
I have already shared that in a different video!
ua-cam.com/video/1o2L0DADzKQ/v-deo.html (video pinned comment has the link)
@@RezaDorrani Thank you for quick reply.
@@RezaDorrani I didn't find the SharePoint List for the Responsive app. Could you please share it. Thank you
hi razen thanks alt you are superb but i have a question i have sharepoint list and powerapps canvas for Ticketing System app what should i do to avoid delegation on one year i have more than 2000 record
list will be full if record get 5000 ? powerapps will be slow if list have more than 5000 ?
Check delegation playlist on my channel
@@RezaDorrani thanks
Great Work
Can we have in-depth use of Monitor Tool PLEASE
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
@@RezaDorrani Thanks for Quick Response
Currently, can you point me to the reference material around Monitor
@@v75tan powerapps.microsoft.com/en-us/blog/introducing-monitor-to-debug-apps-and-improve-performance/
learn.microsoft.com/en-us/power-apps/maker/monitor-canvasapps
mr reza did u have a video that create de header in his video in help desk canvas? blueone rounded edges
ua-cam.com/video/REN93Y-kME8/v-deo.html
thanks sir
Hi Reza, Nice Videos.
Do you know, how to insert emojis from PowerApps to DB and then fetch it back according to the selection made by individual user??
Emojis are text. So inserting them is just like inserting text.
I tried a couple of ways , but not getting anywhere , will highly appreciate you making a small content on that too .
@@nitishjillundra9664 I make videos only when I get multiple requests on a topic. I have ideas with over 50+ requests in my backlog.
I would recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Reza, thanks for the video. Question... i have a gallery for which the "items" property is a base collection with about a dozen columms added using the "addcolumns" funstion. I have recently stored this group of data as a named formula... do you think that this is a good idea or no? Does the named formula slow this down or speed it up?
Named formulas improve app and screen load performance as they are declarative in nature. They do not improve gallery performance.
+ Currently, named formulas is an experimental feature.
@@RezaDorrani So I should convert back to the datasources with the columns appended then I guess. Thank you
@@coreybailey9161 It wont make a difference in performance either ways. Addcolumns is a non delegable function. It will load data in memory in app and perform the action.
@@RezaDorrani You're right, However, What I was trying to avoid was constantly calling the lookup functions from the "AddColumns". I guess I just assumed that if I converted this into named formula, then extra calls may be avoided.
@@coreybailey9161 Im not sure about that. Because it depends on the pattern being implemented.
Hello Reza, how can I join two separate sharepoint lists to use one data source for one gallery in powerapps
I do not have a video reference on this scenario, but I have that idea in my backlog.
Just a doubt as its recommended not to use more than 30 data sources on each app so will it also count the local collections objects?
That does not include local collections
Please help in creating an application in the power app for exit interview questions.
I make videos more on features than specific apps. My rule for video requests is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.”
Is there are anyway to automate the re-publishing process?
I believe there is a flow action for it. Check the documentation around flow connectors.
who to get information from in tow SharePoint list in one gallery ( label1 from DataSource )( label2 from DataSource) i need filter 2 column and in your video, you use lookup with filter one only when use same code with filter two column i get error
I do not have a video reference on this scenario. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, sort with SharePoint choice field in powerapps is not working .. showing error.. any idea.. it is working with text ,date fields
ua-cam.com/video/6KlI1iZ_KD0/v-deo.html
@@RezaDorrani watched already, i achieved it by AddColumns and DropColumns functions.
what is the best solutions for searching the large number of data sets then? if we cannot search more than 500 that's a huge drawback.
That is with SharePoint as a data source. StartsWith is delegable.
Check playlist on delegation (link in video description) for workarounds.
How I can solve my problem!? I tried more than one device and the problem is still there, as when I try to add pictures or a gallery, it does not respond.
I recommend posting issues with screenshots on forums at powerusers.microsoft.com
What code lang is this? I think I need some basic training
Power Fx (excel like)
@@RezaDorrani thank you!
Reza where have you mean all of my (PowerApps) life
I have been right here creating content for over 3 years now.
I guess I’m a silent contributor :)
Great video, thank you. I sent you an email. Please kindly check your emails.
If your email includes an issue or query you need help with, then I would recommend to please post your issue/query with screenshots on the forums at powerusers.microsoft.com
Note: I receive 100s of emails with requests for help and it is not possible to do so. Forums is the best place for posting issues.
I also go to forums to assist but only in my free time.
There is a problem on using the tips at 23:30. If you update the item that referring to varItem, the form will not be refreshed after you update the form. Users have to go back to the gallery and click on the button again in order to refresh. There is no problem if myGallery.selected it using.
Typically when form is updated, you would want to direct user to a success screen or take user back to gallery to see the updates.
You could also simply pass the unique id of the item when gallery selected and use Lookup function to get item based on that ID to set the Item property of form.