PowerApps call Power Automate flow with parameters

Поделиться
HTML-код
  • Опубликовано: 5 сен 2020
  • #PowerAppsFlow #CallFlowPowerApps #PowerApps #PowerAutomate
    In this video on PowerApps call Power Automate flow with parameters, we will explore integration between Power Automate flow and PowerApps.
    We will explore calling a flow form a Power Apps button click, sending data from Power Apps to Power Automate flow and create a record in a SharePoint list.
    Topics covered:
    ✔️ Call flow from Power Apps
    ✔️ Pass parameters from Power Apps to flow
    ✔️ Update flow and re-associate with Power App
    ✔️ Naming standards for params
    ✔️ Param data types and type conversions
    ✔️ Best practices
    ✔️ Tips & Tricks
    Send a collection or gallery data from Power Apps to flow - Pass as JSON - • PowerApps upload multi...

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

  • @shawnlloyd7526
    @shawnlloyd7526 3 года назад +7

    Awesome! So many PowerApps / Flow mystery's solved!

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

      Thank you for the wonderful feedback.

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

    Thank you! Perfect tutorial 😁 I really appreciate you taking the time to point out mistakes we might make along the way and how to resolve them. Great stuff!

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

    Another fantastic lesson. I did not know about the issue with the trigger carrying forward old variables as parameters. I couldn't figure out why my parameters were not changing.! Thank you so much!

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

      In flow - Delete the flow trigger and re-add the parameters using ask in power apps.
      In Power Apps - Remove the flow connection from data sources and re-add it.

  • @teresaagustin5191
    @teresaagustin5191 3 года назад +1

    Thank you for providing these tips Reza. I'm sure they will make my first foray into calling a flow from PowerApps much easier.

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

      Glad this was useful. Thanks for watching Teresa.

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

    THANK YOU for explaining. I couldn't find anything online to explain this. You are great, thanks.

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

      Thank you for watching and I agree there is not much out there on this topic.

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

    Your channel is fast becoming very essential for me. Thank you for posting these.

  • @dreamweaver9962
    @dreamweaver9962 3 года назад +3

    What a wonderful video. It took days for me to find the solutions for the issues you mentioned. So this will be really helpful for everyone who is going to use powerapps flow.

  • @gladysaguilera2290
    @gladysaguilera2290 Месяц назад +1

    excelent video, I was stuck in this part and now is working, thank you

  • @arshad801
    @arshad801 3 года назад +1

    Short and to the point content..thnx Reza i will start using this in my apps from today..

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

      Great to know you will start using it. Thanks for watching.

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

    Great. Simple demos that saves lots of time for lots of people.

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

      Glad to hear that! Thank You.

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

    So many valuable tips in so little time. Awsome video Reza! Thanks a lot!

  • @venukolar7999
    @venukolar7999 8 месяцев назад +1

    Very clear and precise explanation, thank you, Sir.

  • @user-ox7zt9oq6x
    @user-ox7zt9oq6x 3 года назад +2

    It is very clear and hits the point. Thank you!!!

  • @mahendrenmunisamy9834
    @mahendrenmunisamy9834 3 года назад +1

    This is a great video!! A great big thank you, especially for pointing out details regarding the Date format.

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

      Thank you for watching and appreciate the feedback.

  • @frenamakenson9844
    @frenamakenson9844 3 года назад +1

    So Many good tips ... just in one simple video, Thank you my man

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

      You are most welcome and thanks for watching

  • @soesantoss
    @soesantoss 3 года назад

    Your tip on 6:44 saved my project, tks.

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

    Again super informative, thanks a lot Reza.

  • @vinayayinapurapu
    @vinayayinapurapu 3 года назад +1

    Short and simple but very useful...

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

      Thank you Vinay.
      The goal of the Flow Quick Tips series is to keep it simple and effective. Have many more tips planned for the quick tips playlist that will be coming soon - ruclips.net/video/emAhLzVG9bM/видео.html

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

    4:28 "Here is another tip, don't do that". Holy cow the audible laugh that I made when I heard that.😂

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

    You are a legend sir, this helped me greatly thank you

  • @user-lz6gf6uq4e
    @user-lz6gf6uq4e 9 месяцев назад +1

    i just need to thank you for all your effort

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

    Amazing!
    I was really need soluction for that.
    Thanks for helping

  • @user-bx7cc2jb9t
    @user-bx7cc2jb9t 11 месяцев назад +1

    Wow, must say the re-association and the trigger code did saved lot of my time and ofcourse great insight. Looking forward for more such tips

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

      Most welcome

    • @user-bx7cc2jb9t
      @user-bx7cc2jb9t 11 месяцев назад

      @@RezaDorrani could you enlighten on this error message: .Run failed: ScrubbedSensitiveData. The flow was working fine and couple of test entries were successfully inserted to a SharePoint list. That is when a warning got in the flow: "You may break your POwerApps Triggered flow with the changes on the triggers". And the later the click from the powerapp form ended with the above error.
      Activities done:
      After the successful run, added an create item action in the flow.
      I tried removing and readding the flow in the Powerapp and entering the run statement, but didn't fixed.
      Any tip or troubleshooting/suggestions please.

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

      I have not come across this issue hence not sure what the resolution is.
      I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

    • @user-bx7cc2jb9t
      @user-bx7cc2jb9t 11 месяцев назад +1

      @@RezaDorrani Sure. Thanks again for your prompt reply

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

    Thank you ! Perfect tutorial.

  • @vishakhapatil8646
    @vishakhapatil8646 3 года назад +1

    Great tips and explanation!!! Thanks a ton :)

  • @monsalveclashroyale2766
    @monsalveclashroyale2766 7 месяцев назад +1

    Eres mi ídolo 👏👏 muchas gracias 🫡🇨🇱

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

    Such clear explanation..

  • @Flowmi
    @Flowmi 3 года назад +1

    Yes this was amazing! Please keep making more videos! 👽

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

      Thank you. I try my best to post 1 video per week. Goal is to make sure each video is relevant and tackles a common problem.

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

    Very helpful!! Thank you so much

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

    You saved my life! Thanks a lot! :D

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

      Glad to know the video was helpful. Thanks for watching.

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

    thanks a lot, this really helped me!

  • @UmeshKumar-ox3zp
    @UmeshKumar-ox3zp 2 года назад +1

    Excellent teacher!!!

  • @praveenmanne3438
    @praveenmanne3438 3 года назад +1

    Great video! Clear explanation

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

    Hi Reza, great content. Big fan!

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

    4:29 Here is another tip "DO NOT DO THAT!!!!" - lol I love this guy! 😀

  • @babajidebantale
    @babajidebantale 3 года назад +1

    Thanks for the tips.

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

    Thank you. Very useful indeed.

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

    Thank you for sharing

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

      Thanks you for watching Sundra

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

    The great videos Thanks

  • @Linuxian
    @Linuxian 10 месяцев назад +1

    Thanks!

  • @garcialex06
    @garcialex06 11 месяцев назад +1

    Awesome! I was lost about the date format issie. Best regards!

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

      Glad it was helpful!

    • @garcialex06
      @garcialex06 11 месяцев назад

      @@RezaDorrani It was for sure! In fact I recently posted a question on the Power Platform group in LinkedIn. Can I tag you there so you take a sight?

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

      @@garcialex06 I would not have the bandwidth to take a look. You can try posting on LinkedIn or the forums at powerusers.microsoft.com

    • @garcialex06
      @garcialex06 11 месяцев назад

      @@RezaDorrani posted on LI and tagged you. Hope you can read it!

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

      @@garcialex06 I will mostly not as I get 100s of requests a day and currently I have no bandwidth.

  • @danielrumbak2530
    @danielrumbak2530 3 года назад +1

    Thank G-d for Reza!

  • @_cimbora
    @_cimbora 3 года назад

    Super

  • @macm7730
    @macm7730 3 года назад +1

    Great as always! Big thank you for sharing and explaining everything so well in all of your video. I've a quick question, I've created a flow for generating a Word Template for Patient Statement...and then converting it into PDF. I'm running this flow for individual patients and the data is coming from SQL Stored Procedure to Word Template to PDF. These PDF files are being generated and stored over the SharePoint. Instead of 50 separate files I’m
    trying to merge everything in one PDF file. I didn't find appropriate Action in
    PowerApps flow for merging all the PDFs into one. Is there a way of doing this using PowerApps Flow?

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

      Thanks for watching and thanks for the feedback.
      Create a large pdf file merging multiple pdfs would require you to use 3rd party connectors.
      I think Plumsail connector has that option.

    • @macm7730
      @macm7730 3 года назад +3

      @@RezaDorrani Wow... You know everything. Thank you so much for providing a direction :) I'll google and read more about this now

  • @Lagging69
    @Lagging69 3 года назад +1

    This is perfect and well explained as always. Though I learned this before from one of your own tutorials on how to upload documents through PowerApps to SharePoint Document Library.
    But I have a question Reza, I've been told this a few times from different clients to approve, reject and/or return flows directly through power apps, basically they want task forms or task approvals to be actioned through power apps directly. I made it happen with a custom task list on SharePoint for tasks. Do you think its the only approach or there could be some other way to achieve this?

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

      Thanks for your feedback and for supporting my channel.
      Currently customizing task forms in flow approvals is not an option. Your approach of running the list forms based on a data source (SharePoint) is valid since that is currently the only way to get customized task forms.

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

    Great tutorial!
    One question: When the flow is executed by pressing that button will the flow create the SharePoint entry with the account of the flow creator or with the account of the PowerApps user? I would prefer it to be the Flow creator but I am not sure

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

      Thanks.
      I believe it would be the person clicking the button.

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

    Very simple introduction to power apps! Great video! This concept is super valuable when you want to send data from one data source to another data source. I’m currently struggling with figuring out how to create a task item in a separate custom list based on a multiple choice selection (PS thanks for the checkbox video) in a request form/list. Example, user is requesting access to specific rooms. Then based on the selected rooms, it creates a task item for each selected rooms’ responsible person to either approve or reject. Any thoughts?

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

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

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

    Thank you for the tutorial!! Have a question - how to process if the field does not contain any data from the powerapp? So in the example if the count field is null and the flow is called.

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

      You can always check param value in flow or app and accordingly take action.

  • @atsuawoonor-sefe3270
    @atsuawoonor-sefe3270 3 года назад +1

    Simple and to point, permit me, how do handle multiple choices in the run function. I have a data card value which has multiple options to choose

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

      Never tried with multiple choices. My guess would be you pass the data as a delimited string and then read that info in flow.

  • @homie900120
    @homie900120 3 года назад +1

    Actually you can rename parameters after flow is created. Simply export flow, unzip it, find proper JSON file, in that file rename every instance of old variable to new name. You can also remove variables same way.

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

      True. My goal was to show the simple way in the flow experience itself. Export, unzip, manipulate JSON etc. is not so citizen dev friendly + if users makes a mistake in the JSON the flow could get corrupted.

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

    So well explained, many thanks! Just a related question in that, in my app I have a main screen which is passing the values to another screen. How can I get the values from the second screen to the flow? I get the error that the function has invalid arguments although that it is a text.

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

      First check if you are getting the value on your second screen. Invalid arguments normally means the number of params passed is not correct or data type sent is not correct.
      I will also recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

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

    Hi Rezza, great content as always.
    Can you suggest the best approach in the scenario below.
    I have a Power App with 5 flows inside it, developed by someone, now flows are causing some errors and in order to resolve those, i wanted to re attach those flows to the app, but I don't know the exact places in the app, where those flows have been configured, how can I resolve this problem. ?

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

      If you remove the flow association from the App, you will receive errors in App where flow is called.
      The App checker will let you know where those errors are.

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

    Hi Reza, Great video for Power Automate and Power Apps integration. How can we know that item is created successfully from power apps using power automate?

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

      You can send a response back from power automate to power apps.

  • @Mx81
    @Mx81 3 года назад +1

    If possible: please include some tips how to update/expand a flow after the flow was already connected to the app.

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

      That is part of this video. I showcase how you can modify the flow and then reconnect with your App.

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

    Great video, Can I ask if its drop-down box, then how "Run" will work. since .text is not working and items have option1, 2, 3...and so on!

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

      You can read text value of dropdown.
      Looks like yours is a combo box with multiple values. You can pass those values as a string of concatenated options and then split it in flow.

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

    Great videos - you do an excellent job planning out the what ifs :) ./....
    question on a weird requirement please: in my powerapp, I need to populate 2 dropdown value fields:
    1. the sharepoint urls the user has access to
    2. the lists on a selected sharepoint url in field 1.
    I was thinking of calling powerautomate to get and return this data to the powerapp, but how can i do that? Do you have a video showing how to return data from a powerauotmate to a powerapp ? Also wondering if I can just get this data from PowerApp without having to build/call powerAutomate..
    THANKS for any guidance!

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

      Thank You!
      You will need to query flow and send data back to Power Apps. I do not have a video on that one yet (reason is because sending array of data back to power apps from flow requires a PREMIUM license - as of today).
      You will need to use flow to get the data as this will involve API calls.

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

      @@RezaDorrani thanks for the quick reply and for the info… your videos are awesome…looking forward to watching the lot….

  • @gogiputkaradze
    @gogiputkaradze 3 года назад

    Hi Reza, what time are you starting the live stream? I live in The Netherlands and according to RUclips it starts at 02:00 but I can't see if it's 2PM or 2AM local time. Thank you in advance.

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

      Dont worry. Its just a premiere. You can watch it at your own convenience on RUclips anytime once it premieres.
      Thank you for following my channel 😊

    • @gogiputkaradze
      @gogiputkaradze 3 года назад +1

      @@RezaDorrani Great! of course, YW! Have a nice day :)

  • @rengon9611
    @rengon9611 3 года назад +1

    In what scenario would we call a flow? Patch function would also save data to that list correct?

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

      Hi Ren, Typically we call flow from Power Apps to leverage flow features like start an approval, call a web service etc. The video is focussed around tips and tricks when calling a flow. The scenario for adding a SP item can easily be done in Power Apps using Patch or form control (Just used it as an example to keep the demo simple).
      I have done several videos where calling a flow from Power Apps was an ideal use case:
      ruclips.net/video/r3UC3TMXhlI/видео.html
      ruclips.net/video/qsIn0mytC_8/видео.html
      ruclips.net/video/yXvDj60-3YQ/видео.html

  • @liraspberry6966
    @liraspberry6966 3 года назад

    Thanks for sharing! Great video! I have a question: for passing date, your tip works perfectly. but how can I pass blank date without getting the same error? the date field in SharePoint list is not a required field. Thanks!!

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

      When passing data from flow to Power Apps you can just pass Blank(). For updating item, to set it to a blank date you would need to use rest api query. I have seen a lot of questions on this on the forums. I will recommend you check on the forums at powerusers.microsoft.com/

    • @liraspberry6966
      @liraspberry6966 3 года назад +1

      @@RezaDorrani Thanks Reza for the insights! I tried Blank(), still gave me the error. So I ended up doing this: If(
      IsBlank(dtOwner1DOB.SelectedDate),
      Text(
      "1900-01-01",
      "[$-en-US]yyyy-mm-dd"
      ),
      Text(
      dtOwner1DOB.SelectedDate,
      "[$-en-US]yyyy-mm-dd"
      )
      )
      then use Power Automate to update DOB to null. It's not pretty but it works.

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

      @@liraspberry6966 As long as it works :)

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

    Hi Reza thank you so much for this.
    May I ask you to point me in the right direction for a POC I am creating.
    I need to create a form and I need to dynamically schedule a recurring task through that form.
    I need to set the interval, frequency, Start Time dynamically in power apps in that form and pass it to power automate to schedule the task at that time. Can we dynamically set recurrence parameters, outside the recurrence scheduler?

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

      I dont think you can set recurrence scheduler dynamically. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com

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

    Hi Reza, thank you for you videos, my question is how to update an list item by passing parameters do I pass the ID as well? then put that on the update an item?

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

      You would need to pass the ID. That ways you can use update item action in flow and provide the ID.

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

      @@RezaDorrani What type do I pass ID as Text, Integer or Object?

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

      @@jamescalvin2626 Integer.
      I have seen a lot of folks have this question on forums and solutions provided. Check on forums at powerusers.microsoft.com/

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

    Thank you. Is there any way the person whoever is triggering the flow from app know the status of the flow like flow executed successfully or failed due to some reasons .
    If the person is having access to flow then they can go and see the run history . In my case we did not share flow with users.

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

      In flow you can add error handling. If flow fails, then send email to person who triggered the flow.

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

    @Reza, can we able to call a existing flow (instant) present in CRM system on button click in power apps? TIA

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

      I am not aware of that. I will recommend checking on forums in case someone has done something similar
      powerusers.microsoft.com

  • @sanishthomas2858
    @sanishthomas2858 Месяц назад

    Very good. Quick question, how can I pass ServiceAcccount Name while calling Power Automate from Power Apps , I meant is when Power App calls Power automate it should use not the caller UserName but a hardcarded service Account name. pls advise with the code to be used

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      Power apps always calls flow in context of user running power apps.
      Check ruclips.net/video/ts-ggDAy7IQ/видео.htmlsi=fesCeUsiT6AyZvBK

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

    hi Reza!! Can you create a power apps/power automate video on how to move a sharepoint list item to another sharepoint list? (essentially archiving a relative item when clicked on in power apps) THANKS!

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

      I will add your video request to my backlog but will need a lot more folks requesting this topic to give it a higher priority.
      Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.

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

    along with create item could you also make a similar video to get items when a button is triggered in powerapps.

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

      I will add this request to my backlog but will need a lot more folks requesting this topic to give it a higher priority.
      Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @user-st2fn1ip6y
    @user-st2fn1ip6y 7 месяцев назад

    Thank you for the video Reza. However Im facing an issue where the "Ask in PowerApps" feature isn't available to me and I've tried to create the flow both from inside powerApps and outside( in automate). Could you help me out as i cannot find any solution for this online!

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

      I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

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

    Hi Reza, I am trying to set up something similar, where the user selects an item from a gallery search and then populates fields in the gallery form. The Submit button is supposed to trigger a flow that is supposed to update the linked SharePoint list and create a new item in another SharePoint list. The fields that the user populates are a mix of look up, Person lookup, Currency, Attachments and text. How do I get the right formula? I think I am supposed to list the individual fields in the Run brackets, but are there specific suffixes I am supposed to add that refer to the type of field? Also, do I have to create a variable for each field in the flow, even though each field is already in the SharePoint list?

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

      'PowerApp->Getitem,UpdateitemFinanceWorkflow'.Run();Navigate(SuccessScreen)

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

      I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

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

    Thanks for the video Rezza. Can you please give some information on how to share the power automate (called from power apps) to users with run only permissions. For a particular scenario, I could successfully call power automate from power apps with my login, but when a different user tries, they are getting access denied error.

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

      When Power Apps calls flow, it does so in the context of the logged in user.
      When the new V2 action for Power Apps trigger in flow, you do have the option to define under which account the flow will run.

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

      Thanks Rezza, I'll have to dig deeper to find the actual issue. Really appreciate the way you address our questions, the perfect sign of a true teacher.. 🙂

  • @electrichope4049
    @electrichope4049 3 месяца назад

    Hi Reza, is there also a possibility to lets say compare the Text Input field value with a Sharepoint List row Item Value? Like (e-mail adress = sharepoint list e-mail adress)

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

      Possible, you can use get item action to get list row information and then compare using if condition

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

    Hi Sir, I have a scenario wherein I need to run a PowerAutomate as and when items are created into the SharePoint list but the flow will call from PowerApps. There are certain columns in Powerapps which need to be filled by certain people, so when the form is submitted by one department it will go to another department to fill the relevant columns, and then it will go for final approval.

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

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

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

    Hi, Great Video !! But after re- running Power app, text box is holding the old value, how to reset it to blank on every new instance running, without reset button.

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

      Once you call the flow, right after that, you can call reset

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

    rezza, do you have a video about the action response to powerapps. ?

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

      found the answet. I forgot to create a variable to collect the result of the flow

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

      I do not :)

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

      Great!

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

      @@RezaDorrani next video Maybe 😁

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

      @@anthonyleduc I make videos when I get a lot of requests for a particular topic. I will add this one to my backlog. I will need many more requests on this topic :)

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

    You don't identify if someone has a form with numerous fields - do I have to create a variable for every single field? It is very easy to show with 3 simple fields but mine has many and I am not seeing how to modify this. And I don't understand the parameters... if I have to create a variable for 30 fields, do I have to add each of those in the parameter area?

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

      You can also pass JSON to flow from power apps and then read JSON values in flow. That ways you do not have to worry about creating variables.
      My video is a simple demonstration of how to pass values :)

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

    nice video! Can you tell me a way of how I can use a button in canvas app to turn off the network connection in my system?
    P.S. please reply with the reference link, thank you

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

      I am not sure if that is possible. Never tried it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

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

    Is is possible to edit parameters in the triggers of the flow? Apologies if my question doesn't make any sense to guys because I am new to this and I trying to solve an error.

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

      I did a latest video on this. Check ruclips.net/video/1_F9msqF-f8/видео.html

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

    Dear Reza, one thing I would like to tell that when I do the same as per your video, but in excel as destination, date and month got interchanged. U have shown a date 9/9 so it couldn’t get whether same it date or month. Can you help on this issue. Pls..

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

      I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

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

    Is it possible to create alerts whenever the data changes in dataverse ?

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

      Power Automate has a trigger for Dataverse item added, updated and deleted.

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

    Hi Reza, i love your vídeo. I have a doubt. How can i do that user can send tô himself an e-mail from an sharedmailbox which He has no permissions. Do You have any idea? Many thanks in advance. Send you a lot of vibes!

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

      Since power apps triggers the flow, it will run flow under account of power apps user. So they will need permission to the shared mailbox.

  • @Nadia-we3ht
    @Nadia-we3ht 2 года назад

    Hi, It was very helpful. i managed to develop a small app, i have a question, Can i call same flow on two different buttons in same form? so i have a form with two buttons X & Y, when user enters X flow enters data as expected but when user clicks Y it enters FALSE in one columm. ow can i resolve this issue. Should i invoke another flow?

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

      You can call the same flow multiple times. You could reuse the flow across apps as well. If functionality is similar then a single flow would be better.

    • @Nadia-we3ht
      @Nadia-we3ht 2 года назад

      ​@@RezaDorrani I have a form that is supposed to capture UPN of logged in employee. The field has code
      Office365Users.MyProfile().UserPrincipalName as I want to capture the UPN of logged in user in form text field as defalut value that is not editable by user in form.
      This field is not editable and my intention is to show UPN that is not changeable/ editable by user, when i run the form, it shows me my name in form field and enters my name in list using flow.
      When some other user calls the flow it does not enter data in SharePoint list but i see their data values in flow. the error i received in flow is: The response is not in a JSON format.

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

      @@Nadia-we3ht I would have to see your app/flow in action to provide any guidance. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com

    • @Nadia-we3ht
      @Nadia-we3ht 2 года назад

      @@RezaDorrani I just uploaded screenshots of form and flow on this forum and have tagged you.

    • @Nadia-we3ht
      @Nadia-we3ht 2 года назад

      @@RezaDorrani i have another scenerio, I need date and time for time sheet , i am trying to have only date and time in different Labels Say Date and timewhere Date --> Text( Now(), DateTimeFormat.LongDate ) and time is Text(Now(), "HH:mm AM/PM")
      Now when i run flow it gives error Error details: 'String 'Tuesday, July 6,2021' does not validate against format 'date'.'."
      and flow is TestFlow.Run(Name.Text,Email.Text,Arrival.Text,Text(Date,"[$-en-US]yyyy-mm-dd"))
      what to do?

  • @ConfidencePoint1
    @ConfidencePoint1 3 года назад

    How did you create that add asset dialogue box Raza?

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

      Just added a rectangle shape with border on the control to make it look like a dialog box :)

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

    Can we get Sharepoint Site address through variable - ask in Powerapps? Please suggest

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

      Yes.
      In that case, site url will be custom.

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

    And the flows runs since all the parameters are correct. But if the flows somehow fails, is there a way to get notified? Like a popup or ..

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

      You can check for errors in flow and post response back to power apps.
      I do not have a video reference on this scenario though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

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

      @@RezaDorrani Thanks for the reply 👍. Just to clarify, if the flow is triggered on the OnSuccess of the submission of the form , that means the app is exiting and there is no way to get flow fail notification rit?

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

      @@rinzzrockzz Flow can respond to power app. There is an action for that in flow.

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

    Can we call power Automate flow from canvas page there is no option of action in canvas page unlike canvas app.

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

      Left navigation has the flow pane to choose from. Not sure why you dont see it.

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

    Hello Reza I wanted to get the print messages which are success messages and failed messages from sql server which with gateway connection ...may I know how to acheieve this

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

      Currently I am using power apps and power automate

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

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

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

    Good day, can i ask where can i see the common data service because i don't see it now hihi

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

      Microsoft renamed Common Data Service to Microsoft Dataverse.

  • @musiclover6092
    @musiclover6092 17 дней назад

    Sir in new Power Apps their is no such options for select an action also in Power Automate when we declare variable then their is no option for ask from Power apps
    can you help me how to do it ?

    • @RezaDorrani
      @RezaDorrani  17 дней назад

      I have done videos on how the new updates work. Check my playlist on power automate and apps integration

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

    excellent/ I have a question. If i leave blank value in a component, i have an error. How to bypass this ?

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

      i respond to myseflf...just add If(
      IsBlank(dpd_code_produit_forma.Selected.Result);
      Text("");
      dpd_code_produit_forma.Selected.Result
      where dpd_code is the name of my component

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

      Looks like you solved it based on your 2nd comment.

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

      Great!

  • @harshithag5769
    @harshithag5769 3 года назад

    Hello Sir, I have created a smiliar app, it's just submit form and it triggers the email to approve. It works when I submit the form but when I asked my colleague to submit the form as a test run it is not triggering the flow. I have given him contribute permissions in list settings. Mine is a instant cloud flow in power automate. Please help how can I make others use the form I created .

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

      The video showcases calling a flow from Power Apps and not an instant cloud flow.
      If you have an instant cloud flow, you can define run only users for that flow.

    • @harshithag5769
      @harshithag5769 3 года назад

      @@RezaDorrani Even though it's instant flow, I am calling exactly the way you have shown here. I have added the user as owner in power automate flow. I don't see run only option. I see only owner option. Still it's not triggering from his pc. We all work in same organisation. We use per user plan. Is that the reason others can't use my form integrated with flow?

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

      @@harshithag5769 Not sure I still understand your issue :)
      I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/

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

    Is is possible to turn on power automate flow from power apps

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

      No. The flow must be ON in order for power apps to trigger it.

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

    Hi Reza... I am actually facing an error while running the flow. "The method 'run' has an invalid value for parameter 'parameter_name'. How to resolve this issue? Can you please guide me regarding this?

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

      I will have to look at your flow in action to know the cause of your issue. I will recommend to post your issue with screenshots on the forums at powerusers.microsoft.com/

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

    How do you pass the names from the form to like this!?

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

      Names of?
      Video shows how to pass parameters from app to flow.

  • @dreamweaver9962
    @dreamweaver9962 3 года назад

    I have faced another issue with the flow. Sometimes the flow will show an error saying 'there is a problem with the trigger'. Another issue is evn if there is no error flow won't trigger for some users. In this case not able to find out root cause of the issue

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

      If there is an error with the trigger - then you would need to fix that first. Check to see if flow checker shows any issues.
      When you call a flow from Power Apps and if there is an issue - the flow will not trigger. You would have to do some error handling in Power Apps to check the error message.

  • @user-fj6zx5wk2k
    @user-fj6zx5wk2k 8 месяцев назад

    how you protect the parameters from a sniffer capturing your request?

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

      The flow can only be called from the power app. Where is the sniffer placed? :)

  • @c77729992
    @c77729992 3 года назад

    I need dateformat "dd/mm/yyyy" what should I do ?

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

      Use the expression formatdatetime - docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatDateTime

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

    An unpublished solution flow cannot be installed. Please turn on the flow to enable activation.
    code: UnpublishedSolutionFlowCannotBeInstalled
    This is hwoing how to resolve

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

      ??

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

      @@RezaDorrani On adding Flow in power automate

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

      @@keepitsimplenaruto6912 I have not experienced this issue when adding flows. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

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

    Automate or Flow? I still don't get it 😭😭

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

      Power Automate is the name of the service. But you still create flows in Power Automate.

    • @isaidstream4547
      @isaidstream4547 3 года назад +1

      @@RezaDorrani ohhh

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

    How to stop a flow in PowerApps with button

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

      You can trigger a flow from power apps.
      To stop a flow, I believe you would need the flow run id and try cancel flow action in flow.

  • @vijaykumar-gj8mv
    @vijaykumar-gj8mv 11 месяцев назад

    how to pass null value to the parameters ??

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

      Blank() function is an option.

    • @vijaykumar-gj8mv
      @vijaykumar-gj8mv 11 месяцев назад

      @@RezaDorrani Certainly! I appreciate your input. I encountered a situation where the patch from power apps resulted in modifications to different rows in SharePoint, rather than the intended ones. I'm seeking suggestions on how to resolve this issue since I haven't been able to identify the exact cause.

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

      @@vijaykumar-gj8mv I have not encountered this situation and hence not sure what the fix is. I recommend posting your issue with screenshots on the forums
      powerusers.microsoft.com

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

    how to call powerapp from power automate ?

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

      You cannot call an App from flow. You could send values back from flow to apps though.