Top 25 Power Apps Tips, Tricks & Best Practices for Makers

[@brendanbowen7097]

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!

[@RezaDorrani]

Happy to hear that! Thanks so much for watching.

[@craigl75]

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

[@RezaDorrani]

@@craigl75 It does not matter as long as variable state is changed to true at one instant. Both should work.

[@BrechtLattre]

Applied it immediately to my app but unfortunately is does not work with the modern checkbox control. Any solution?

[@TheAu4812555]

Hi Mr Reza please kindly advise i hv an error when trying to retrieve data from the network How to solve the issue sir ?

[@VigneshSugumar]

Thanks!

[@RezaDorrani]

Thank You

[@blazehawkins2759]

Never clicked on a video as quickly as I did for this one. Appreciate the content as always!

[@RezaDorrani]

Blaze(ing) ⚡ Thanks so much!

[@pavelsheludkov7241]

Thank you Reza! Brilliant, this one 25-minute video worth a year of experience for someone.

[@RezaDorrani]

Thanks Pavel

[@mohammadm2571]

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.

[@RezaDorrani]

Awesome! So glad to hear that. Thanks so much for watching and learning from the videos

[@TDevolder]

Best tip is at 26:48... thx for the great content, Reza!

[@RezaDorrani]

Thanks Tom :)

[@markm7013]

Great tip on limiting the number of controls. I went from 64 button controls to 8 galleries to control my app navigation. Thanks!

[@RezaDorrani]

Fantastic!

[@chap666ish]

Excellent stuff, Reza.

[@RezaDorrani]

Many thanks!

Just clicked like like before viewing. #NoRegrets 👍🏻

[@RezaDorrani]

Thank You for always being supportive of the videos!

[@mrnock2]

Incredible video again Reza. You are the best!

[@RezaDorrani]

Thank You Richard!

[@GhettoLenin]

Awesome! You said Hello everyone again! 😃

[@RezaDorrani]

Someone reminded me that I forgot in last few videos :) Was it you? 😊

[@musicmannot]

Awesome work RD

[@RezaDorrani]

Thank you! Cheers!

[@sivachagaleti6614]

This is awesome Reza.

[@RezaDorrani]

Thanks

[@smugada]

Thanks for a great video. Your help to Power Platform community is immense.

[@RezaDorrani]

Most welcome Sampath

[@oluwatobipaul6171]

Great video Reza. I learn a lot from the 25 tips and tricks. Thank you Reza

[@RezaDorrani]

Glad to hear that! Thanks for watching.

[@tluu8501]

Wow! Not Top 5 or Top 10 tips but 25 tips!!

[@RezaDorrani]

Hope they were all worth it!

[@robbolles4742]

Thanks, Reza, I've learned a ton from all your videos. I really appreciate you and all your work.

[@RezaDorrani]

Thank You Rob 🙏

[@gauravgoyal5]

Helpful tips given in the video. Thanks.

[@RezaDorrani]

Happy to hear that. Thanks for watching.

[@14gigigirl]

Reza you are a continual wealth of knowledge! Thank you again for sharing your insights and helping us to build apps more efficiently.

[@RezaDorrani]

Thanks so much

[@asjadlakhani8659]

Just fabulous !! (As always) 🙂

[@RezaDorrani]

Thank You 😊

[@Tobemeisfun]

Great video! 🌟

[@RezaDorrani]

Thank You

[@buithe1987]

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! 👏🙌😊

[@RezaDorrani]

Thank You so much for your kind words. I am so happy to hear the feedback. You made my day! Regards, Reza

[@carlosjulianpenagos3279]

Thank you Reza, you're the best 👏

[@RezaDorrani]

Thanks

[@S0nny1984]

You are so freaking amazing! I am learning so much.

[@RezaDorrani]

Thank you!

[@HaiNguyenMD]

Thank you so much for sharing your knowledge with the world. I have learned so much from watching your videos.

[@RezaDorrani]

Most welcome and thanks so much for watching the videos.

[@robi62000]

thank you Reza for all your videos. I learn a lot to optimize my devs and find solutions to realize them

[@RezaDorrani]

Happy to hear that!

[@arpitmalviya6234]

Thank you Master ,Magician Reza !

[@RezaDorrani]

You are very welcome

[@prashantvedpathak3067]

What a content !!! Too good. I joined you from 1st tip... what flawless presentation.

[@RezaDorrani]

Thanks Prashant. So happy to hear the feedback. This was a tough video to build.

[@prashantvedpathak3067]

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

[@RezaDorrani]

@@prashantvedpathak3067 Much appreciated! I spent hours editing this one. Glad to know it was well worth it.

[@prashantvedpathak3067]

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

[@RezaDorrani]

@@prashantvedpathak3067 Thanks for sharing

[@misganawkibret603]

Very Important video. Thank you!

[@RezaDorrani]

Most welcome

[@jasonmoreton461]

Excellent video Reza, you make things so easy to understand, thank you for the explanations.👍

[@RezaDorrani]

My pleasure!

[@anathipretty5414]

Always learning something new, keep up the good work, and thank you for the insightful information.

[@RezaDorrani]

Thanks Anathi

[@benoau]

absolutely fantastic thank you Reza

[@RezaDorrani]

Most welcome

[@luisjimenez8760]

Awesome as always

[@RezaDorrani]

Thank you so much!

[@shawnsissenwein]

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

[@RezaDorrani]

Thanks Shawn!

[@Shanepaulwalker]

Excellent tips. Thank you!

[@RezaDorrani]

You are so welcome!

[@vishaljhaveri7565]

This was really a useful video. Thanks Sir.

[@RezaDorrani]

Most welcome

[@godkeebler]

Reza 🎉. Hurray some of the best tips ever. 👏 great job

[@RezaDorrani]

Yay! Thank you!

[@andreasvanbergen9696]

Thank you so much for sharing Reza! 👍

[@RezaDorrani]

Most welcome!

[@ssalkan]

Thanks Reza. You're the best. ❤️

[@RezaDorrani]

Thanks Safa

[@gkakun]

Thanks Raza! You got to create complete PowerApps course. From beginner to expert. I will definately pay for this one!

[@RezaDorrani]

Glad to hear that! I do have plans for live training in future. Nothing final as of now.

[@royalhandloom]

Agreed! If we can have a series if videos from beginners to expert level with examples that would be great

[@RezaDorrani]

@@royalhandloom That would be a series of live training videos.

[@musicmannot]

Based on a specific use case. Service Agreements haha. Warts and all including resolving issues. Brave but real!

[@RezaDorrani]

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzbin.infojoin

[@SHAli1474]

Very informative, Thanks Reza

[@RezaDorrani]

Thanks Ali

[@JetLife423]

Appreciate this video Reza! It was packed full of helpful tips. Learned a lot from this video.

[@RezaDorrani]

Thanks Brian

[@dhayanandkalimidi67]

Today something we learned newly. Thanks Reza brother

[@RezaDorrani]

Most welcome 🙏

[@vasylsalyk165]

Brilliant! Thank you, Reza!

[@RezaDorrani]

Most welcome

[@LearnPowerPlatformWithAbhinav]

Very knowleadgable video. From which app or software you have install in your laptop to create video

[@RezaDorrani]

Thanks! I use Camtasia

[@LearnPowerPlatformWithAbhinav]

@@RezaDorrani I suppose you must be using License version of Camtasia. How much one have to pay to buy the license version ?

[@RezaDorrani]

@@LearnPowerPlatformWithAbhinav Yes, I have the licensed version. Check price on camtasia web page.

[@anithasaraswathi4864]

excellent , thank you so much

[@RezaDorrani]

Welcome!

[@lalasahebgaikwad1154]

Great Tips & Tricks 🎉🎉

[@RezaDorrani]

Glad you like them!

[@vigneshm7011]

Awesome 👏

[@RezaDorrani]

Thank you! Cheers!

[@FCSSOFTWAREDEVELOPMENT]

excellent sir,

[@RezaDorrani]

Thanks

[@paolovr1970]

Wow thanks Reza 🙏🙏🙏

[@RezaDorrani]

Welcome

[@leszek5806]

Wow thanks !

[@RezaDorrani]

Most welcome!

[@DroneEyes]

Very useful tips Reza

[@RezaDorrani]

Thanks a lot

[@SadekInfos7392]

you are a legend, keep going

[@RezaDorrani]

Wow! I’m no legend but I will try and keep going :)

[@SadekInfos7392]

@@RezaDorrani what you do for us is so helpful and save us time and efforts to the journey of learning

[@ronbakker1300]

Thanks again Reza

[@RezaDorrani]

Most welcome!

[@Plainace]

Hey it’s my video recommendation! ❤

[@RezaDorrani]

Hope the recommendation was worth it!

[@spen2431]

Thanks Reza 👍👍💥💥

[@RezaDorrani]

Thanks for watching Spen

[@roopj2452]

These practices make aap more performant shopping with the best user experience

[@RezaDorrani]

Glad to hear that

[@madhanlakshmanan5113]

Such a valuable content from you reza thanks a lot for the awesome content keep help to people's....by your videos...

[@RezaDorrani]

Thanks a ton

[@manjunath5727]

Hi Reza, thanks for th video. Do we have similar video for model driven apps? Here most of the tips are related to canvas.

[@RezaDorrani]

I do not have a video on tips for model-driven apps

[@v75tan]

Great Work Can we have in-depth use of Monitor Tool PLEASE

[@RezaDorrani]

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

[@v75tan]

​@@RezaDorrani Thanks for Quick Response Currently, can you point me to the reference material around Monitor

[@RezaDorrani]

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

[@DataisKing]

Fantastic 😊

[@RezaDorrani]

Thank you! Cheers!

[@akshaynm]

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

[@RezaDorrani]

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

[@akshaynm]

@@RezaDorrani sure Reza, I will definitely vote for that the the pole is open next time. Many thanks..!!

[@vivekm75murali]

Nice one, Reza 👏 i was hoping you would cover the named formulas as well.

[@RezaDorrani]

That was covered in a different video. Check kzbin.info/www/bejne/lXqXpaOlga5rl9k

[@sainathp991]

Awesome

[@RezaDorrani]

Thanks

[@AnandhAdhithan]

Top notch explanation! Simply brilliant and very useful for power app developers.

[@RezaDorrani]

Glad it was useful. Thanks Anandh!

[@isaiah53_1]

Thank you

[@RezaDorrani]

Most welcome

[@freddyccix]

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 🤜🤛

[@RezaDorrani]

Solutions & Env. Variables - kzbin.info/www/bejne/jqCQhamQbrNmeK8 & kzbin.info/www/bejne/eHeqlIuJdsyUra8 Dataflows is in my backlog.

[@moviesfortheblind4012]

Hi Reza, great content as always, can you make a role-based power app tutorial in near future??

[@RezaDorrani]

I have done that in the past :) kzbin.info/www/bejne/gF7LfoCOp7CAjKc & kzbin.info/www/bejne/nJOngntmq66mhJo

[@moviesfortheblind4012]

@@RezaDorrani cheers Reza!

[@sundrapillay6668]

Thanks Reza

[@RezaDorrani]

👍

[@andresgiannakis9760]

mr reza did u have a video that create de header in his video in help desk canvas? blueone rounded edges

[@RezaDorrani]

kzbin.info/www/bejne/iHaxamaPYtCAe5o

[@andresgiannakis9760]

thanks sir

[@5394prashant]

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 ?

[@RezaDorrani]

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.

[@njbsu]

Hi Reza, is container or group considered a component as well which will add the count of components in an app?

[@RezaDorrani]

Container - Yes. Group - I am not sure.

[@sganpisetty]

Hi Reza, Thanks for the video. Is there any chance that getting this service desk solution for my lab practice. Thank you

[@RezaDorrani]

I have already shared that in a different video! kzbin.info/www/bejne/Z6CVfWN6dqmtgbM (video pinned comment has the link)

[@sganpisetty]

@@RezaDorrani Thank you for quick reply.

[@sganpisetty]

@@RezaDorrani I didn't find the SharePoint List for the Responsive app. Could you please share it. Thank you

[@waellkhanji3466]

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 ?

[@RezaDorrani]

Check delegation playlist on my channel

[@waellkhanji3466]

@@RezaDorrani thanks

[@SiblingsInNetherlands]

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

[@RezaDorrani]

Emojis are text. So inserting them is just like inserting text.

[@SiblingsInNetherlands]

I tried a couple of ways , but not getting anywhere , will highly appreciate you making a small content on that too .

[@RezaDorrani]

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

[@aviaa2481]

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

[@RezaDorrani]

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

[@aviaa2481]

@@RezaDorrani 🙏

[@coreybailey9161]

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?

[@RezaDorrani]

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.

[@coreybailey9161]

@@RezaDorrani So I should convert back to the datasources with the columns appended then I guess. Thank you

[@RezaDorrani]

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

[@coreybailey9161]

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

[@RezaDorrani]

@@coreybailey9161 Im not sure about that. Because it depends on the pattern being implemented.

[@RafathKhansWorld]

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?

[@RezaDorrani]

That does not include local collections

[@pavelsheludkov7241]

Is there are anyway to automate the re-publishing process?

[@RezaDorrani]

I believe there is a flow action for it. Check the documentation around flow connectors.

[@TheRohit0011]

Please help in creating an application in the power app for exit interview questions.

[@RezaDorrani]

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

[@MoonGameDev]

Tip: Ensure there are less than 300 controls per screen. I was trying to create a single page (screen) application, but it will reduce the performance past 300 controls.

[@RezaDorrani]

Thanks for sharing

[@shubhangidhindale4173]

Hello Reza, how can I join two separate sharepoint lists to use one data source for one gallery in powerapps

[@RezaDorrani]

I do not have a video reference on this scenario, but I have that idea in my backlog.

[@ABCD-ABCDEFGH]

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.

[@RezaDorrani]

That is with SharePoint as a data source. StartsWith is delegable. Check playlist on delegation (link in video description) for workarounds.

[@rmanojkumar9353]

Hi Reza, sort with SharePoint choice field in powerapps is not working .. showing error.. any idea.. it is working with text ,date fields

[@RezaDorrani]

kzbin.info/www/bejne/bHzPemSfj8R-epI

[@rmanojkumar9353]

@@RezaDorrani watched already, i achieved it by AddColumns and DropColumns functions.

[@chrundlethegreat2251]

What code lang is this? I think I need some basic training

[@RezaDorrani]

Power Fx (excel like)

[@chrundlethegreat2251]

@@RezaDorrani thank you!

[@waellkhanji3466]

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

[@RezaDorrani]

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

[@mimi002008]

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.

[@RezaDorrani]

I recommend posting issues with screenshots on forums at powerusers.microsoft.com

[@gerryha4693]

Reza where have you mean all of my (PowerApps) life

[@RezaDorrani]

I have been right here creating content for over 3 years now. I guess I’m a silent contributor :)

[@feliciam.2425]

Great video, thank you. I sent you an email. Please kindly check your emails.

[@RezaDorrani]

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.

[@titahaver6290]

The most famous person of Power Platform on the web🤩

[@RezaDorrani]

Wow! Thank You 😊

[@legendgod]

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.

[@RezaDorrani]

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.