PowerApps call Power Automate flow with parameters

Sdílet
Vložit
  • čas přidán 5. 09. 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...

Komentáře • 252

  • @shawnlloyd7526
    @shawnlloyd7526 Před 3 lety +7

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

      Thank you for the wonderful feedback.

  • @HellfireCarnage
    @HellfireCarnage Před 2 lety +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 Před 2 lety +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  Před 2 lety

      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 Před 3 lety +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  Před 3 lety

      Glad this was useful. Thanks for watching Teresa.

  • @AlexHoltry
    @AlexHoltry Před 3 lety +2

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

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

  • @greatkingrat
    @greatkingrat Před 2 lety +1

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

  • @user-ox7zt9oq6x
    @user-ox7zt9oq6x Před 3 lety +2

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

  • @mahendrenmunisamy9834
    @mahendrenmunisamy9834 Před 3 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

      Thank you for watching and appreciate the feedback.

  • @cynocains
    @cynocains Před 2 lety +1

    You saved my life! Thanks a lot! :D

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

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

  • @jr713121
    @jr713121 Před 2 lety +1

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

  • @dreamweaver9962
    @dreamweaver9962 Před 3 lety +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.

  • @conaxlearn8566
    @conaxlearn8566 Před 2 lety +1

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

  • @arshad801
    @arshad801 Před 3 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

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

  • @vishakhapatil8646
    @vishakhapatil8646 Před 3 lety +1

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

  • @Flowmi
    @Flowmi Před 3 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

      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.

  • @acesaket
    @acesaket Před 2 lety +1

    Thank you ! Perfect tutorial.

  • @venukolar7999
    @venukolar7999 Před 10 měsíci +1

    Very clear and precise explanation, thank you, Sir.

  • @victoriamovchan8470
    @victoriamovchan8470 Před 3 lety +2

    thanks a lot, this really helped me!

  • @frenamakenson9844
    @frenamakenson9844 Před 3 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

      You are most welcome and thanks for watching

  • @miguelripoll5108
    @miguelripoll5108 Před 3 lety +1

    Very helpful!! Thank you so much

  • @monsalveclashroyale2766
    @monsalveclashroyale2766 Před 8 měsíci +1

    Eres mi ídolo 👏👏 muchas gracias 🫡🇨🇱

  • @thiagorocha9765
    @thiagorocha9765 Před 2 lety +1

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

  • @UmeshKumar-ox3zp
    @UmeshKumar-ox3zp Před 2 lety +1

    Excellent teacher!!!

  • @praveenmanne3438
    @praveenmanne3438 Před 3 lety +1

    Great video! Clear explanation

  • @soesantoss
    @soesantoss Před 3 lety

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

  • @gladysaguilera2290
    @gladysaguilera2290 Před 3 měsíci +1

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

  • @kyleado8775
    @kyleado8775 Před 10 měsíci +1

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

  • @vinayayinapurapu
    @vinayayinapurapu Před 3 lety +1

    Short and simple but very useful...

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

      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 - czcams.com/video/emAhLzVG9bM/video.html

  • @michaelvandensteen7994
    @michaelvandensteen7994 Před rokem +1

    Again super informative, thanks a lot Reza.

  • @user-lz6gf6uq4e
    @user-lz6gf6uq4e Před 10 měsíci +1

    i just need to thank you for all your effort

  • @PValili
    @PValili Před 2 lety +1

    Thank you. Very useful indeed.

  • @babajidebantale
    @babajidebantale Před 3 lety +1

    Thanks for the tips.

  • @RavikiranS
    @RavikiranS Před 2 lety +1

    Hi Reza, great content. Big fan!

  • @tereliyeashu
    @tereliyeashu Před rokem +1

    Such clear explanation..

  • @sairampamidi8623
    @sairampamidi8623 Před 2 lety +1

    The great videos Thanks

  • @user-bx7cc2jb9t
    @user-bx7cc2jb9t Před rokem +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  Před rokem

      Most welcome

    • @user-bx7cc2jb9t
      @user-bx7cc2jb9t Před rokem

      @@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  Před rokem +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 Před rokem +1

      @@RezaDorrani Sure. Thanks again for your prompt reply

  • @wizit1993
    @wizit1993 Před rokem +1

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

  • @Linuxian
    @Linuxian Před 11 měsíci +1

    Thanks!

  • @sundrapillay6668
    @sundrapillay6668 Před 3 lety +1

    Thank you for sharing

  • @lpm76
    @lpm76 Před 2 lety +2

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

  • @danielrumbak2530
    @danielrumbak2530 Před 3 lety +1

    Thank G-d for Reza!

  • @_cimbora
    @_cimbora Před 3 lety

    Super

  • @macm7730
    @macm7730 Před 3 lety +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  Před 3 lety

      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 Před 3 lety +3

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

  • @tammodirksen1408
    @tammodirksen1408 Před 2 lety +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  Před 2 lety +2

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

  • @garcialex06
    @garcialex06 Před rokem +1

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

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Glad it was helpful!

    • @garcialex06
      @garcialex06 Před rokem

      @@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  Před rokem +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 Před rokem

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

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

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

  • @homie900120
    @homie900120 Před 3 lety +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  Před 3 lety +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.

  • @mohammednizamuddin1348
    @mohammednizamuddin1348 Před rokem +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  Před rokem

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

  • @Copy-kodadam-mama
    @Copy-kodadam-mama Před 23 dny

    Hi Reza
    , I have one question . I have created instant powerapps (v2) trigger flow with service account it will send mail to few people,when a run the app and click the button with different account it will sending the mail from who clicked the button instead of service account

    • @RezaDorrani
      @RezaDorrani  Před 22 dny

      czcams.com/video/ts-ggDAy7IQ/video.htmlsi=LZ1WzVnvqmtUnBN-

  • @Lagging69
    @Lagging69 Před 3 lety +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  Před 3 lety +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.

  • @frankiesaunders369
    @frankiesaunders369 Před 2 lety +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  Před 2 lety

      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

  • @rohitwattamwar1
    @rohitwattamwar1 Před 2 lety +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  Před 2 lety

      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.

  • @Mx81
    @Mx81 Před 3 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety +1

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

  • @rengon9611
    @rengon9611 Před 3 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety +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:
      czcams.com/video/r3UC3TMXhlI/video.html
      czcams.com/video/qsIn0mytC_8/video.html
      czcams.com/video/yXvDj60-3YQ/video.html

  • @atsuawoonor-sefe3270
    @atsuawoonor-sefe3270 Před 3 lety +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  Před 3 lety

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

  • @sidkostas2
    @sidkostas2 Před rokem

    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  Před rokem

      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

  • @indiaamitamit
    @indiaamitamit Před 2 lety

    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  Před 2 lety

      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.

  • @santhoshnaik
    @santhoshnaik Před 3 lety +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  Před 3 lety

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

  • @jennifergonzalez5356
    @jennifergonzalez5356 Před 2 lety

    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  Před 2 lety

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

  • @rajanid3921
    @rajanid3921 Před 2 lety

    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  Před 2 lety

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

  • @sharadpatil1320
    @sharadpatil1320 Před rokem

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

    • @RezaDorrani
      @RezaDorrani  Před rokem

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

  • @gogiputkaradze
    @gogiputkaradze Před 3 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety +1

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

    • @gogiputkaradze
      @gogiputkaradze Před 3 lety +1

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

  • @dt5656
    @dt5656 Před 2 lety +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  Před 2 lety +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 Před 2 lety

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

  • @jamescalvin2626
    @jamescalvin2626 Před 2 lety +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  Před 2 lety

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

    • @jamescalvin2626
      @jamescalvin2626 Před 2 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

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

  • @user-st2fn1ip6y
    @user-st2fn1ip6y Před 8 měsíci

    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  Před 8 měsíci

      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

  • @asheerhasan5680
    @asheerhasan5680 Před 2 lety

    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  Před 2 lety

      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.

  • @liraspberry6966
    @liraspberry6966 Před 3 lety

    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  Před 3 lety +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 Před 3 lety +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  Před 3 lety

      @@liraspberry6966 As long as it works :)

  • @vigneshhariharan9687
    @vigneshhariharan9687 Před 2 lety

    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  Před 2 lety

      I did a latest video on this. Check czcams.com/video/1_F9msqF-f8/video.html

  • @prashnew1983
    @prashnew1983 Před rokem

    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  Před rokem

      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

  • @sanishthomas2858
    @sanishthomas2858 Před 2 měsíci

    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  Před 2 měsíci

      Power apps always calls flow in context of user running power apps.
      Check czcams.com/video/ts-ggDAy7IQ/video.htmlsi=fesCeUsiT6AyZvBK

  • @shannonp3mo169
    @shannonp3mo169 Před rokem

    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 Před rokem

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

    • @RezaDorrani
      @RezaDorrani  Před rokem

      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

  • @krutarthgohel5577
    @krutarthgohel5577 Před 2 lety

    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  Před 2 lety

      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

  • @electrichope4049
    @electrichope4049 Před 4 měsíci

    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  Před 4 měsíci

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

  • @janetfernandes7383
    @janetfernandes7383 Před 2 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      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.

  • @dhanyarose4191
    @dhanyarose4191 Před 2 lety +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  Před 2 lety

      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 Před 2 lety +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.. 🙂

  • @musiclover6092
    @musiclover6092 Před měsícem

    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  Před měsícem

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

  • @MadRockway
    @MadRockway Před 3 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

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

  • @rinzzrockzz
    @rinzzrockzz Před rokem

    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  Před rokem +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 Před rokem

      @@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  Před rokem +1

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

  • @fenrir433
    @fenrir433 Před 2 lety

    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  Před 2 lety +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.

  • @jyotimittal7150
    @jyotimittal7150 Před rokem

    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  Před rokem

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

  • @premsaini4289
    @premsaini4289 Před 10 měsíci

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

    • @RezaDorrani
      @RezaDorrani  Před 10 měsíci

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

  • @ajayv2632
    @ajayv2632 Před rokem

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

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

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

  • @rhachooli5327
    @rhachooli5327 Před 2 lety

    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 Před 2 lety

      Currently I am using power apps and power automate

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      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

  • @ConfidencePoint1
    @ConfidencePoint1 Před 3 lety

    How did you create that add asset dialogue box Raza?

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

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

  • @anthonyleduc
    @anthonyleduc Před 2 lety

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

    • @anthonyleduc
      @anthonyleduc Před 2 lety +1

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety +1

      I do not :)

    • @RezaDorrani
      @RezaDorrani  Před 2 lety +1

      Great!

    • @anthonyleduc
      @anthonyleduc Před 2 lety

      @@RezaDorrani next video Maybe 😁

    • @RezaDorrani
      @RezaDorrani  Před 2 lety +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 :)

  • @myeonlvr
    @myeonlvr Před 2 lety

    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  Před 2 lety

      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.

  • @juanpierrejesusgonzales933

    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  Před 2 lety

      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.

  • @dreamweaver9962
    @dreamweaver9962 Před 3 lety

    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  Před 3 lety

      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.

  • @Nadia-we3ht
    @Nadia-we3ht Před 3 lety

    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  Před 3 lety

      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 Před 3 lety

      ​@@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  Před 3 lety

      @@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 Před 3 lety

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

    • @Nadia-we3ht
      @Nadia-we3ht Před 3 lety

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

  • @nocodecreative
    @nocodecreative Před 2 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

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

  • @gargichakraborty2122
    @gargichakraborty2122 Před rokem

    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  Před rokem

      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/

  • @user-fj6zx5wk2k
    @user-fj6zx5wk2k Před 9 měsíci

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

    • @RezaDorrani
      @RezaDorrani  Před 9 měsíci

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

  • @joycesumabat4092
    @joycesumabat4092 Před 2 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      Microsoft renamed Common Data Service to Microsoft Dataverse.

  • @harshithag5769
    @harshithag5769 Před 3 lety

    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  Před 3 lety

      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 Před 3 lety

      @@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  Před 3 lety

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

  • @c77729992
    @c77729992 Před 3 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety

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

  • @anthonyleduc
    @anthonyleduc Před 2 lety

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

    • @anthonyleduc
      @anthonyleduc Před 2 lety +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  Před 2 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

      Great!

  • @karthikmngowda
    @karthikmngowda Před 2 lety

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

    • @RezaDorrani
      @RezaDorrani  Před 2 lety

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

  • @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  Před rokem

      ??

    • @keepitsimplenaruto6912
      @keepitsimplenaruto6912 Před rokem

      @@RezaDorrani On adding Flow in power automate

    • @RezaDorrani
      @RezaDorrani  Před rokem +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 Před 3 lety +2

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

    • @RezaDorrani
      @RezaDorrani  Před 3 lety +3

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

    • @isaidstream4547
      @isaidstream4547 Před 3 lety +1

      @@RezaDorrani ohhh

  • @thomasjohnson9793
    @thomasjohnson9793 Před rokem +1

    How to stop a flow in PowerApps with button

    • @RezaDorrani
      @RezaDorrani  Před rokem

      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 Před rokem

    how to pass null value to the parameters ??

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Blank() function is an option.

    • @vijaykumar-gj8mv
      @vijaykumar-gj8mv Před rokem

      @@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  Před rokem

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