Start using these 7 Power Apps Formulas (Power Fx)

Поделиться
HTML-код
  • Опубликовано: 8 сен 2024

Комментарии • 174

  • @surajporwal9405
    @surajporwal9405 2 года назад +20

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thank You so much for the awesome feedback.

    • @amanchourasia1870
      @amanchourasia1870 Год назад

      @@RezaDorranihow to insert gallery in edit form and how to show on edit amd new form

    • @RezaDorrani
      @RezaDorrani  Год назад

      @@amanchourasia1870 I do not have any video reference on this. I recommend posting your query on forums at powerusers.microsoft.com

    • @amanchourasia1870
      @amanchourasia1870 Год назад

      @@RezaDorrani and when u r going to start your course sir?

    • @RezaDorrani
      @RezaDorrani  Год назад

      @@amanchourasia1870 Will be via RUclips live memberships once Im ready. I have already started 2 membership levels. You can check them here ruclips.net/user/rezadorranijoin

  • @davidc9652
    @davidc9652 2 года назад +3

    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!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Great to hear! Thank You so much for the feedback.

  • @rohanshaw1827
    @rohanshaw1827 2 года назад +2

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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Glad to hear this video is helpful and being used as a reference. Thanks Rohan.

  • @dougydoe
    @dougydoe 2 года назад +2

    Very useful reminder of these formulae. The use cases especially brings them to live. Thank you for sharing.

  • @kashiffaisal5254
    @kashiffaisal5254 Год назад +1

    The way you explained these formulae is amazing !!! Lot of concepts got cleared for me after watching this video. Thank you so much.

  • @joew00
    @joew00 2 года назад +2

    The way you explained with real-life examples is very clear and easy to understand! Cheers.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thank You Joseph. Glad to know the examples are well explained.

  • @sksachingupta1
    @sksachingupta1 2 года назад +1

    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.

  • @mdhidayat5706
    @mdhidayat5706 2 года назад +2

    Awesome tricks Reza! Will definitely use 16:30 on my current PowerApps.👍

  • @michaeldeabreu2020
    @michaeldeabreu2020 2 года назад +2

    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!

  • @Ajlon1
    @Ajlon1 6 месяцев назад

    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.

  • @blazehawkins2759
    @blazehawkins2759 2 года назад +1

    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!

  • @jasonkirkdottech
    @jasonkirkdottech 2 года назад +2

    Such a great video! I needed 2 of these in my current app project. Thank you for your work!

  • @AnoopKumar-qx8to
    @AnoopKumar-qx8to 2 года назад +2

    Indeed great tricks Reza Sir .Applicable to almost all business cases enhancing overall powerapps experience.Thankyou for presenting such insights .👍👍👏👏

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      Thank You for the amazing feedback Anoop.

  • @franknielsen3219
    @franknielsen3219 2 года назад +1

    very very nice walkthrough reza. I realy need to use the Coalesce function

  • @kevinjoseph9023
    @kevinjoseph9023 2 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Awesome! Thanks for sharing your story Kevin.
      Power Platform getting started - powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/

  • @SAULSM17
    @SAULSM17 Год назад +2

    Reza siempre es un placer ver tus videos. Muy agradecido por tu trabajo!

  • @TDevolder
    @TDevolder 2 года назад +1

    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" ;-)

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      Wow! Thanks Tom.
      I like the idea of part 2 :)

  • @mehrdadameli2430
    @mehrdadameli2430 9 месяцев назад +1

    that was great! thanks a lot

  • @alexandrebormio
    @alexandrebormio 2 года назад +2

    Always a excelent content. Tks for sharing. Obrigado!

  • @Bekesam
    @Bekesam 2 года назад +1

    Another wonderful and real world relevant video. Thank you!!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Glad you enjoyed it! Thanks for watching.

  • @jt9228
    @jt9228 2 года назад +1

    Another excellent video! I see several formulas that I can use in my apps. Thanks for sharing your knowledge!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Glad it was helpful! Thanks for watching.

  • @FarhanKhan-lr4tv
    @FarhanKhan-lr4tv 2 года назад +1

    Another vedio with lots of new idea, thought, features thanks #powerman #powerapp

  • @miryam5390
    @miryam5390 6 месяцев назад +1

    Super helpful, thank you so much.

  • @shanthimachunuru1100
    @shanthimachunuru1100 Год назад +1

    U Done awesome videos sir ... 👏

  • @shanthimachunuru1100
    @shanthimachunuru1100 Год назад +1

    UR Explanation ossum sir , great effort .

  • @acesaket
    @acesaket 2 года назад +1

    Sir your video is very helpful, Thank you for your work!!!

  • @pavelsheludkov7241
    @pavelsheludkov7241 2 года назад +1

    Thank you for sharing all this!

  • @AsifKhan_official
    @AsifKhan_official 2 года назад +1

    Hello Reza very nice article u r one of my fav tutor for power apps

  • @sujisam5508
    @sujisam5508 2 года назад +1

    Thanks Reza! Very useful Video. Thank you for all your efforts.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thanks Suji. You are most welcome.

  • @FCSSOFTWAREDEVELOPMENT
    @FCSSOFTWAREDEVELOPMENT Год назад +1

    super effort sir,

  • @jray1429
    @jray1429 2 года назад +1

    Great job…Very informative and very well presented…As Usual

  • @matteoganci1329
    @matteoganci1329 2 года назад +1

    Hello Reza, very useful content. Thanks for this video.

  • @quincychentw
    @quincychentw 2 года назад +1

    Thanks for awesome sharing.

  • @lvimal2003
    @lvimal2003 2 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Wow! Thank You so much for the compliments.

  • @oluwatobiyusuf
    @oluwatobiyusuf 2 года назад +1

    Thanks for this great insight

  • @fabioalex9698
    @fabioalex9698 2 года назад +1

    Hey man, great job, it was so nice and important for us in a advanced programing

  • @NKBobcat
    @NKBobcat 2 года назад +1

    Thank you so much for this!

  • @anantchirmade600
    @anantchirmade600 Год назад +1

    Thank you so much for this!
    Can you make 2nd part with any new or rarely known function/formulas?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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

    • @anantchirmade600
      @anantchirmade600 Год назад +1

      @@RezaDorrani understood fair point.

  • @thrilled2bits
    @thrilled2bits Год назад +1

    Reza, as usual, very useful, many ta for this. Can any of these functions be used in Power Automate?

    • @RezaDorrani
      @RezaDorrani  Год назад

      Power Automate uses a completely different expression language.
      Check ruclips.net/video/O97IdCbfMQI/видео.html

  • @anthonyleduc
    @anthonyleduc 2 года назад

    Very well explain and i didn't know about concurrent fonction. Love it as always

  • @rahil_islamic_786
    @rahil_islamic_786 2 года назад +1

    Thanks, Sir your video very helpfull

  • @sundrapillay6668
    @sundrapillay6668 2 года назад +1

    Thanks Reza excellent as always

  • @asheerhasan5680
    @asheerhasan5680 2 года назад +1

    Great sir and thanks for sharing.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      Thanks and welcome

    • @asheerhasan5680
      @asheerhasan5680 2 года назад

      @@RezaDorrani Sir If I have some queries how would I approach you?

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

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

  • @SHAli1474
    @SHAli1474 2 года назад +1

    Thanks Reza

  • @freddyjimenez6328
    @freddyjimenez6328 Год назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  Год назад

      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

    • @freddyjimenez6328
      @freddyjimenez6328 Год назад +1

      @@RezaDorrani Thanks for the quick response. I was able to figure it out by using the LookUp command. Thanks again.

  • @TiberiuGociu
    @TiberiuGociu 2 года назад +1

    Superb!

  • @arnabdas6250
    @arnabdas6250 2 года назад +1

    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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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

  • @MrAnonymous3333
    @MrAnonymous3333 5 месяцев назад

    Hi Reza,
    Can you make a comprehensive video on PCF components in Power Apps and how to deploy them in production please.

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      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.

  • @bbuyzen
    @bbuyzen Год назад +1

    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?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @shahramab7
    @shahramab7 2 года назад

    Thank you Reza, useful video as always, are you from Iran?

  • @nguyenminhthien3669
    @nguyenminhthien3669 2 года назад +1

    Tuyệt vời.

  • @jdriele
    @jdriele 2 года назад +1

    As good as usual ^^

  • @mr.madhanbabu1493
    @mr.madhanbabu1493 2 года назад +1

    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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      I do not have a video on your mail scenario.
      I will recommend you check on the forums at powerusers.microsoft.com/

  • @DataisKing
    @DataisKing 2 года назад

    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())

  • @ramolestoreinc.8175
    @ramolestoreinc.8175 2 года назад

    Hello Reza thank you so much, is there a way to use Errors checking on Form before submitting and how please. Thanks. ♥

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Errors is for after submission.
      For before submissions there is a Forms.Valid property.

  • @husseinrefaat2287
    @husseinrefaat2287 2 года назад

    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?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thanks.
      My email address is in the About Me tab of my RUclips channel.

    • @husseinrefaat2287
      @husseinrefaat2287 2 года назад

      @@RezaDorrani I've sent you an email

    • @husseinrefaat2287
      @husseinrefaat2287 2 года назад

      Did you get my email?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      @@husseinrefaat2287 Got it and responded.

    • @husseinrefaat2287
      @husseinrefaat2287 2 года назад

      @@RezaDorrani Thank you for responding and for helping me out.

  • @Heisshena
    @Heisshena Год назад

    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

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @sandeepthota8642
    @sandeepthota8642 6 месяцев назад

    Hi Reza, Can You please send powerapps interview questions

  • @ethanrebello269
    @ethanrebello269 Год назад

    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?

    • @RezaDorrani
      @RezaDorrani  Год назад

      Not aware of this scenario as I have not used Errors in context of Dataverse actions.

  • @anthonyleduc
    @anthonyleduc 2 года назад

    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

    • @RezaDorrani
      @RezaDorrani  2 года назад +2

      If( dpd.selected.result="value1" || dpd.selected.result="value 2",'result ok','result not ok')
      will also work.

    • @anthonyleduc
      @anthonyleduc 2 года назад

      @@RezaDorrani thank you reza. It s what i did finally.

  • @ajayrathod7777
    @ajayrathod7777 4 месяца назад

    How can I do normal subtraction from text input with pre-defined dropdown value

    • @RezaDorrani
      @RezaDorrani  4 месяца назад +1

      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.

  • @excel-k-sir
    @excel-k-sir 9 месяцев назад

    Hello Reza, is it possible to calculate XIRR a financial ROI formula in power Apps.

    • @RezaDorrani
      @RezaDorrani  9 месяцев назад

      I have no clue what XIRR financial calculation looks like

    • @excel-k-sir
      @excel-k-sir 9 месяцев назад +1

      @@RezaDorrani thankyou for replying.

  • @nadyranakylla4426
    @nadyranakylla4426 Год назад

    Hi, i got a question. What is the formula to subtract (math function) between 2 numbers using powerapps. I got error when using (-)

    • @RezaDorrani
      @RezaDorrani  Год назад

      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

  • @fla1910
    @fla1910 2 года назад

    Hi Reza, regarding basic commands, do you know how do I get the app name or app id from inside the canvas code?

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      I believe you need to query the admin connectors to get that info. No basic command available as of now - Nov 5th 2021 :)

    • @fla1910
      @fla1910 2 года назад +1

      @@RezaDorrani ok, I was trying to avoid it. Thanks a lot!

  • @marcelschliebitz4021
    @marcelschliebitz4021 2 года назад +1

    How can a man be so good. lol

  • @hannawg7747
    @hannawg7747 2 года назад

    Hey Reza, is that possible to to create PowerApps form if the data source is azure data lake?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      I have not tried with azure data lake. I will recommend you check on the forums at powerusers.microsoft.com/

  • @keepitsimplenaruto6912
    @keepitsimplenaruto6912 Год назад

    Reza May You Share Me this Asset Management Application It will Be very Help full to understand the concept or functionality

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

    • @keepitsimplenaruto6912
      @keepitsimplenaruto6912 Год назад

      @@RezaDorrani Please share latest application if u have

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      @@keepitsimplenaruto6912 It would probably be in my github repo. You will need to scan through it.

    • @keepitsimplenaruto6912
      @keepitsimplenaruto6912 Год назад +1

      k wil search thnks

    • @keepitsimplenaruto6912
      @keepitsimplenaruto6912 Год назад

      @@RezaDorrani Gm Reza ,hi May u please send me the repo link i am not able to find assets management repo

  • @DataisKing
    @DataisKing Год назад

    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

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @itubeHirschberg
    @itubeHirschberg 2 года назад

    👍🏾

  • @anshulipec1
    @anshulipec1 2 года назад

    Can you please let me know how you have open Edit PowerApps form on default Edit button at 17:44

    • @anshulipec1
      @anshulipec1 2 года назад

      If its a customize form then too its have a good width which I struggle to set

    • @RezaDorrani
      @RezaDorrani  2 года назад

      17:44 - Showcases a SharePoint form. That is not Power Apps.

    • @RezaDorrani
      @RezaDorrani  2 года назад

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

  • @Viipiin
    @Viipiin 2 года назад +1

    After Sonu Nigam, you're my favourite celebrity 🤗

  • @adarshdixit2758
    @adarshdixit2758 Год назад

    can you train me for powerapps

    • @RezaDorrani
      @RezaDorrani  Год назад

      I do not provide 1:1 training

    • @adarshdixit2758
      @adarshdixit2758 Год назад

      @@RezaDorrani can I have your WhatsApp number please

    • @RezaDorrani
      @RezaDorrani  Год назад

      Check channel memberships. I have gone live with a training tier that you can sign up for now.
      ruclips.net/user/rezadorranijoin

  • @Samskrithii
    @Samskrithii 2 года назад

    Are you from IRAN ?

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      No.
      But I am from this world :)