Definitely Microsoft provides documentation for PA Formulas however the way you explain these scenarios is simply awesome. All your Power Platform videos have great content.
@@amanchourasia1870 Will be via TH-cam live memberships once Im ready. I have already started 2 membership levels. You can check them here th-cam.com/users/rezadorranijoin
Nobody explains these concepts better than you. Some of these were a mystery to me and seemed so complicated until I saw your video. Now I can't wait to go back and update my code. Thank you!
Hi Rezza, I watched this video a few months ago and when i ran into a problem i remembered your use of coalese. IT WAS GREAT!! it got me out of a few pickles andd now it is one of my favourite go to things. You are amazing!!!
Great Video Reza! I have been building apps for over 4 years now and thought I knew it all. Definitely learnt some handy tips here - thank you for your consistency and concise videos!
Reza, this premium content! Especially the use cases really explain the strength of these functions. Thanks!! Video suggestion: "Start using these 7 Power Apps Formulas (Power Fx) part 2" ;-)
Indeed great tricks Reza Sir .Applicable to almost all business cases enhancing overall powerapps experience.Thankyou for presenting such insights .👍👍👏👏
About 8 months ago I happened to come across one of your videos and it changed my business. There are so many things I'd like to do but I'm just not fluent across the platform. I started with SharePoint (customer data source) and then moved to Power Automate (some expressions) & only scratched the surface on PAD and now I'm dabbling in Power Apps. It will take me too long to build the skill I need to deliver smart solutions across the platform. Any Ideas? By the way... Thanks for your inspiration, your content, your delivery of content and all the rest. I now need to learn how to grab your content and leverage to better my solutions until I get a little better... You're the best.
Awesome! Thanks for sharing your story Kevin. Power Platform getting started - powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/
You are amazing and your efforts to create such kinds of videos are really good. Keep up the good works. Even Microsft videos not even close to yours for sure.
@@asheerhasan5680 If question is related to video, post it in the video comments. If it is an issue you are running into, then post the issue with screenshots on the forums at powerusers.microsoft.com/
Hi Reza, quick question - @10:00 you talked about the category field with 'allow multiple selection" turned on, in my case the assigned to column has the allow multiple selection turned on , I tried similar formula you have done on the text property for the Category field into my assigned to field but getting errors - is there different method to fix the issue? please advise thank you
Hello Reza, Thank you for the great video's! Do you know if it is possible to trigger calculation of Roll-up columns on a dataverse Table through Power FX in the command Ribon?
Do you know if it is possible to trigger calculation of Roll-up columns on a dataverse Table through Power FX in the command Ribon? I am not sure if there is a method. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for making such great tutorials. I am attempting to display individual content onto a Canvas Screen without a user's text input. The field I am attempting to display is view only of text (person's name) originating from a List source. I have another field with a unique value (new entry) to help isolate the data row. If possible, would you please provide an example script.
I don’t have a sample reference for this scenario. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Very Informative Video. I have a request though, would you be able to make video that will help me create a business simulation like the classic beer game simulation ? Thanks
I make videos when I get multiple requests on a topic. This request seems very specific. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
I am assuming you are talking about customizing SP forms with Power Apps. I am working on a video idea on it. Check the Community Tab on my TH-cam channel.
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 topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Is there a way to reference the current screen so that you can reuse the same line of code for every screen instead of hardcoding the name of the screen like this? If(AssetForm.Unsaved,Notify("You have Unsaved Changes",Information,3000),Exit())
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza Since we don't have developer tenant available in India region right now. If we want to purchase license for doing RnD around data verse, model driven apps. canvas app with SharePoint & data verse which license you will suggest.
Hi Reza, I have a doubt in regards with Errors as I want to catch change conflicts or anything in regards with Dataverse tables. I do not receive any errors whatsoever. For updating a record with change made on server => updates directly without conflict If record is updated in App when its deleted on server => it creates a new record. Any idea? Is it a bug or something got changed?
It is - I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
One question : I have a dropdown control with values. if a user select value 1 or value 2 = result ok, if not result = bad. With ismatch car i evaluate the 2 values in one time...if(ismatch(dpd.selected.result="value1" or "value 2";result ok). It will be a best method than using nested if
Thank you for this video, you explain things in a very clear manner. I have a complex business case where we currently use Excel and I want to apply it using PowerApps. Would you be able to assist please?
Hi Reza, Am continuously watching your videos and suggest the new power platform developers to watch it. It's great very much easy to understand. I have requirement where I want to reply to a mail that sent by powerapps. I would like to group all the mail send for the perticular task creation to release
I keep modifying the same app and updating it based on video scenario. I probably do not have the version shown in video and this video was done a while ago. If I do share anything, it is mostly linked to my GitHub repo from video description.
I am trying to count the number of occurances of every item in a collection. Below is my desired result. How can I create the Number of occurance column? I DO NOT want to group the information. I need to show every row like I have displayed. Fruit Number of Occurrences Apple 1 Orange 1 Apple 2 Banana 1 Orange 2 Apple 3 Banana 2 Banana 3 Watermelon 1 Apple 4
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Definitely Microsoft provides documentation for PA Formulas however the way you explain these scenarios is simply awesome. All your Power Platform videos have great content.
Thank You so much for the awesome feedback.
@@RezaDorranihow to insert gallery in edit form and how to show on edit amd new form
@@amanchourasia1870 I do not have any video reference on this. I recommend posting your query on forums at powerusers.microsoft.com
@@RezaDorrani and when u r going to start your course sir?
@@amanchourasia1870 Will be via TH-cam live memberships once Im ready. I have already started 2 membership levels. You can check them here th-cam.com/users/rezadorranijoin
Nobody explains these concepts better than you. Some of these were a mystery to me and seemed so complicated until I saw your video. Now I can't wait to go back and update my code. Thank you!
Great to hear! Thank You so much for the feedback.
Very useful reminder of these formulae. The use cases especially brings them to live. Thank you for sharing.
Thank You for watching
Hi Rezza, I watched this video a few months ago and when i ran into a problem i remembered your use of coalese. IT WAS GREAT!! it got me out of a few pickles andd now it is one of my favourite go to things.
You are amazing!!!
Glad to hear this video is helpful and being used as a reference. Thanks Rohan.
The way you explained these formulae is amazing !!! Lot of concepts got cleared for me after watching this video. Thank you so much.
You’re most welcome
I am big fan of you. Any body can be expertise on apps /flow while watching your video . And you are doing good job .God bless you.
Thanks a ton 🙏
The way you explained with real-life examples is very clear and easy to understand! Cheers.
Thank You Joseph. Glad to know the examples are well explained.
Awesome tricks Reza! Will definitely use 16:30 on my current PowerApps.👍
Great 👍
Reza siempre es un placer ver tus videos. Muy agradecido por tu trabajo!
Thank You
Another wonderful and real world relevant video. Thank you!!
Glad you enjoyed it! Thanks for watching.
Amazing content - thank you. Everytime I think I have a great Power App, you show me something I need to be incorporating to make it even better.
Great Video Reza! I have been building apps for over 4 years now and thought I knew it all. Definitely learnt some handy tips here - thank you for your consistency and concise videos!
Great to hear!
very very nice walkthrough reza. I realy need to use the Coalesce function
Thank You Frank
Always a excelent content. Tks for sharing. Obrigado!
Much appreciated!
Such a great video! I needed 2 of these in my current app project. Thank you for your work!
Glad it was helpful!
Reza, this premium content! Especially the use cases really explain the strength of these functions. Thanks!!
Video suggestion: "Start using these 7 Power Apps Formulas (Power Fx) part 2" ;-)
Wow! Thanks Tom.
I like the idea of part 2 :)
Another excellent video! I see several formulas that I can use in my apps. Thanks for sharing your knowledge!
Glad it was helpful! Thanks for watching.
Thanks Reza! Very useful Video. Thank you for all your efforts.
Thanks Suji. You are most welcome.
Hello Reza, very useful content. Thanks for this video.
Glad it was helpful!
UR Explanation ossum sir , great effort .
Thanks a lot
Thank you for this amazing video. I'm not even past the second formula, and already I have learned so much to improve my capabilities!
Thank You so much!
Super helpful, thank you so much.
You're very welcome!
Thank you for sharing all this!
You are so welcome!
Sir your video is very helpful, Thank you for your work!!!
You are most welcome
Hello Reza very nice article u r one of my fav tutor for power apps
Wow, thanks
Indeed great tricks Reza Sir .Applicable to almost all business cases enhancing overall powerapps experience.Thankyou for presenting such insights .👍👍👏👏
Thank You for the amazing feedback Anoop.
Great job…Very informative and very well presented…As Usual
Thanks again!
Thanks Reza excellent as always
Thanks for listening
Another vedio with lots of new idea, thought, features thanks #powerman #powerapp
Thanks Farhan
U Done awesome videos sir ... 👏
Thank You
About 8 months ago I happened to come across one of your videos and it changed my business. There are so many things I'd like to do but I'm just not fluent across the platform. I started with SharePoint (customer data source) and then moved to Power Automate (some expressions) & only scratched the surface on PAD and now I'm dabbling in Power Apps. It will take me too long to build the skill I need to deliver smart solutions across the platform. Any Ideas? By the way... Thanks for your inspiration, your content, your delivery of content and all the rest. I now need to learn how to grab your content and leverage to better my solutions until I get a little better... You're the best.
Awesome! Thanks for sharing your story Kevin.
Power Platform getting started - powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/
that was great! thanks a lot
You're most welcome!
Thanks for awesome sharing.
My pleasure
Thank you so much for this!
Can you make 2nd part with any new or rarely known function/formulas?
I make videos when I get multiple requests on a topic. I will need a lot more folks requesting this + need more interesting formulas to showcase
@@RezaDorrani understood fair point.
You are amazing and your efforts to create such kinds of videos are really good. Keep up the good works. Even Microsft videos not even close to yours for sure.
Wow! Thank You so much for the compliments.
Very well explain and i didn't know about concurrent fonction. Love it as always
Glad to hear that!
Reza, as usual, very useful, many ta for this. Can any of these functions be used in Power Automate?
Power Automate uses a completely different expression language.
Check th-cam.com/video/O97IdCbfMQI/w-d-xo.html
Thanks for this great insight
My pleasure!
Great sir and thanks for sharing.
Thanks and welcome
@@RezaDorrani Sir If I have some queries how would I approach you?
@@asheerhasan5680 If question is related to video, post it in the video comments.
If it is an issue you are running into, then post the issue with screenshots on the forums at powerusers.microsoft.com/
Hey man, great job, it was so nice and important for us in a advanced programing
Thank You Fabio
Thank you so much for this!
You're so welcome!
Hi Reza, quick question - @10:00 you talked about the category field with 'allow multiple selection" turned on, in my case the assigned to column has the allow multiple selection turned on , I tried similar formula you have done on the text property for the Category field into my assigned to field but getting errors - is there different method to fix the issue? please advise thank you
Depends upon column type. Assigned to would mostly be a person type column. Check my video on Patch in Power Apps to see the format is expects.
super effort sir,
Thanks
As good as usual ^^
Thank You
Hello Reza, Thank you for the great video's! Do you know if it is possible to trigger calculation of Roll-up columns on a dataverse Table through Power FX in the command Ribon?
Do you know if it is possible to trigger calculation of Roll-up columns on a dataverse Table through Power FX in the command Ribon? I am not sure if there is a method.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for making such great tutorials. I am attempting to display individual content onto a Canvas Screen without a user's text input. The field I am attempting to display is view only of text (person's name) originating from a List source. I have another field with a unique value (new entry) to help isolate the data row. If possible, would you please provide an example script.
I don’t have a sample reference for this scenario. I would recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani Thanks for the quick response. I was able to figure it out by using the LookUp command. Thanks again.
Thank you Reza, useful video as always, are you from Iran?
I come from this world :)
Thanks Reza
👍
Thanks, Sir your video very helpfull
Glad to hear that
very nice video
Thanks
Superb!
Thank you! Cheers!
Very Informative Video. I have a request though, would you be able to make video that will help me create a business simulation like the classic beer game simulation ? Thanks
I make videos when I get multiple requests on a topic. This request seems very specific. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Can you please let me know how you have open Edit PowerApps form on default Edit button at 17:44
If its a customize form then too its have a good width which I struggle to set
17:44 - Showcases a SharePoint form. That is not Power Apps.
I am assuming you are talking about customizing SP forms with Power Apps.
I am working on a video idea on it.
Check the Community Tab on my TH-cam channel.
Hi Reza,
Can you make a comprehensive video on PCF components in Power Apps and how to deploy them in production please.
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 topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hello Reza thank you so much, is there a way to use Errors checking on Form before submitting and how please. Thanks. ♥
Errors is for after submission.
For before submissions there is a Forms.Valid property.
Is there a way to reference the current screen so that you can reuse the same line of code for every screen instead of hardcoding the name of the screen like this? If(AssetForm.Unsaved,Notify("You have Unsaved Changes",Information,3000),Exit())
App.ActiveScreen I guess
Hello Reza, is it possible to calculate XIRR a financial ROI formula in power Apps.
I have no clue what XIRR financial calculation looks like
@@RezaDorrani thankyou for replying.
How can I do normal subtraction from text input with pre-defined dropdown value
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza
Since we don't have developer tenant available in India region right now. If we want to purchase license for doing RnD around data verse, model driven apps. canvas app with SharePoint & data verse which license you will suggest.
Developer tenant is not available anywhere anymore.
You can create something known as a development environment. Check documentation on this.
Hi Reza, regarding basic commands, do you know how do I get the app name or app id from inside the canvas code?
I believe you need to query the admin connectors to get that info. No basic command available as of now - Nov 5th 2021 :)
@@RezaDorrani ok, I was trying to avoid it. Thanks a lot!
Hi Reza,
I have a doubt in regards with Errors as I want to catch change conflicts or anything in regards with Dataverse tables.
I do not receive any errors whatsoever.
For updating a record with change made on server => updates directly without conflict
If record is updated in App when its deleted on server => it creates a new record.
Any idea? Is it a bug or something got changed?
Not aware of this scenario as I have not used Errors in context of Dataverse actions.
Hey Reza, is that possible to to create PowerApps form if the data source is azure data lake?
I have not tried with azure data lake. I will recommend you check on the forums at powerusers.microsoft.com/
Hi, i got a question. What is the formula to subtract (math function) between 2 numbers using powerapps. I got error when using (-)
It is -
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Can You please send powerapps interview questions
I dont have them
One question : I have a dropdown control with values. if a user select value 1 or value 2 = result ok, if not result = bad.
With ismatch car i evaluate the 2 values in one time...if(ismatch(dpd.selected.result="value1" or "value 2";result ok). It will be a best method than using nested if
If( dpd.selected.result="value1" || dpd.selected.result="value 2",'result ok','result not ok')
will also work.
@@RezaDorrani thank you reza. It s what i did finally.
Thank you for this video, you explain things in a very clear manner.
I have a complex business case where we currently use Excel and I want to apply it using PowerApps.
Would you be able to assist please?
Thanks.
My email address is in the About Me tab of my TH-cam channel.
@@RezaDorrani I've sent you an email
Did you get my email?
@@husseinrefaat2287 Got it and responded.
@@RezaDorrani Thank you for responding and for helping me out.
Hi Reza,
Am continuously watching your videos and suggest the new power platform developers to watch it. It's great very much easy to understand.
I have requirement where I want to reply to a mail that sent by powerapps. I would like to group all the mail send for the perticular task creation to release
I do not have a video on your mail scenario.
I will recommend you check on the forums at powerusers.microsoft.com/
Tuyệt vời.
Thanks
Reza May You Share Me this Asset Management Application It will Be very Help full to understand the concept or functionality
I keep modifying the same app and updating it based on video scenario. I probably do not have the version shown in video and this video was done a while ago.
If I do share anything, it is mostly linked to my GitHub repo from video description.
@@RezaDorrani Please share latest application if u have
@@keepitsimplenaruto6912 It would probably be in my github repo. You will need to scan through it.
k wil search thnks
@@RezaDorrani Gm Reza ,hi May u please send me the repo link i am not able to find assets management repo
I am trying to count the number of occurances of every item in a collection. Below is my desired result. How can I create the Number of occurance column? I DO NOT want to group the information. I need to show every row like I have displayed.
Fruit Number of Occurrences
Apple 1
Orange 1
Apple 2
Banana 1
Orange 2
Apple 3
Banana 2
Banana 3
Watermelon 1
Apple 4
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
After Sonu Nigam, you're my favourite celebrity 🤗
Thanks man
How can a man be so good. lol
Wow! Thank You :)
can you train me for powerapps
I do not provide 1:1 training
@@RezaDorrani can I have your WhatsApp number please
Check channel memberships. I have gone live with a training tier that you can sign up for now.
th-cam.com/users/rezadorranijoin
Are you from IRAN ?
No.
But I am from this world :)
👍🏾
👍