PowerApps call Power Automate flow with parameters

Поділитися
Вставка
  • Опубліковано 11 гру 2024
  • #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...

КОМЕНТАРІ • 256

  • @shawnlloyd7526
    @shawnlloyd7526 4 роки тому +7

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому

      Thank you for the wonderful feedback.

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

  • @dreamweaver9962
    @dreamweaver9962 4 роки тому +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.

  • @AlexHoltry
    @AlexHoltry 4 роки тому +2

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому

      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.

  • @teresaagustin5191
    @teresaagustin5191 4 роки тому +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  4 роки тому

      Glad this was useful. Thanks for watching Teresa.

  • @arshad801
    @arshad801 4 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому

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

  • @AnupamaK-u7w
    @AnupamaK-u7w Рік тому +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  Рік тому

      Most welcome

    • @AnupamaK-u7w
      @AnupamaK-u7w Рік тому

      @@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  Рік тому +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/

    • @AnupamaK-u7w
      @AnupamaK-u7w Рік тому +1

      @@RezaDorrani Sure. Thanks again for your prompt reply

  • @conaxlearn8566
    @conaxlearn8566 2 роки тому +1

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

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

  • @venukolar7999
    @venukolar7999 Рік тому +1

    Very clear and precise explanation, thank you, Sir.

  • @jr713121
    @jr713121 3 роки тому +1

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

  • @gladysaguilera2290
    @gladysaguilera2290 8 місяців тому +1

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

  • @รถพรวนดินมิตซู

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

  • @kyleado8775
    @kyleado8775 Рік тому +1

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

  • @HellfireCarnage
    @HellfireCarnage 3 роки тому +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!

  • @Mohamedsaleh-i7w
    @Mohamedsaleh-i7w Рік тому +1

    i just need to thank you for all your effort

  • @michaelvandensteen7994
    @michaelvandensteen7994 2 роки тому +1

    Again super informative, thanks a lot Reza.

  • @mahendrenmunisamy9834
    @mahendrenmunisamy9834 4 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому

      Thank you for watching and appreciate the feedback.

  • @lpm76
    @lpm76 2 роки тому +2

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

  • @wizit1993
    @wizit1993 2 роки тому +1

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

  • @vinayayinapurapu
    @vinayayinapurapu 4 роки тому +1

    Short and simple but very useful...

    • @RezaDorrani
      @RezaDorrani  4 роки тому

      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 - ua-cam.com/video/emAhLzVG9bM/v-deo.html

  • @thiagorocha9765
    @thiagorocha9765 2 роки тому +1

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

  • @UmeshKumar-ox3zp
    @UmeshKumar-ox3zp 3 роки тому +1

    Excellent teacher!!!

  • @Linuxian
    @Linuxian Рік тому +1

    Thanks!

  • @monsalveclashroyale2766
    @monsalveclashroyale2766 Рік тому +1

    Eres mi ídolo 👏👏 muchas gracias 🫡🇨🇱

  • @tereliyeashu
    @tereliyeashu 2 роки тому +1

    Such clear explanation..

  • @praveenmanne3438
    @praveenmanne3438 3 роки тому +1

    Great video! Clear explanation

  • @acesaket
    @acesaket 2 роки тому +1

    Thank you ! Perfect tutorial.

  • @RavikiranS
    @RavikiranS 2 роки тому +1

    Hi Reza, great content. Big fan!

  • @cynocains
    @cynocains 3 роки тому +1

    You saved my life! Thanks a lot! :D

    • @RezaDorrani
      @RezaDorrani  3 роки тому

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

  • @vishakhapatil8646
    @vishakhapatil8646 3 роки тому +1

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

  • @garcialex06
    @garcialex06 Рік тому +1

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

    • @RezaDorrani
      @RezaDorrani  Рік тому +1

      Glad it was helpful!

    • @garcialex06
      @garcialex06 Рік тому

      @@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  Рік тому +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 Рік тому

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

    • @RezaDorrani
      @RezaDorrani  Рік тому +1

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

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

  • @Flowmi
    @Flowmi 4 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому

      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.

  • @sairampamidi8623
    @sairampamidi8623 3 роки тому +1

    The great videos Thanks

  • @miguelripoll5108
    @miguelripoll5108 3 роки тому +1

    Very helpful!! Thank you so much

  • @victoriamovchan8470
    @victoriamovchan8470 3 роки тому +2

    thanks a lot, this really helped me!

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

  • @babajidebantale
    @babajidebantale 4 роки тому +1

    Thanks for the tips.

  • @PValili
    @PValili 3 роки тому +1

    Thank you. Very useful indeed.

  • @sundrapillay6668
    @sundrapillay6668 4 роки тому +1

    Thank you for sharing

    • @RezaDorrani
      @RezaDorrani  4 роки тому

      Thanks you for watching Sundra

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

  • @rengon9611
    @rengon9611 4 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому +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:
      ua-cam.com/video/r3UC3TMXhlI/v-deo.html
      ua-cam.com/video/qsIn0mytC_8/v-deo.html
      ua-cam.com/video/yXvDj60-3YQ/v-deo.html

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

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

  • @Mx81
    @Mx81 4 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому +1

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

  • @santhoshnaik
    @santhoshnaik 3 роки тому +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  3 роки тому

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

  • @jamescalvin2626
    @jamescalvin2626 3 роки тому +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  3 роки тому

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

    • @jamescalvin2626
      @jamescalvin2626 3 роки тому

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

    • @RezaDorrani
      @RezaDorrani  3 роки тому

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

  • @danielrumbak2530
    @danielrumbak2530 3 роки тому +1

    Thank G-d for Reza!

  • @Copy-kodadam-mama
    @Copy-kodadam-mama 5 місяців тому

    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  5 місяців тому

      ua-cam.com/video/ts-ggDAy7IQ/v-deo.htmlsi=LZ1WzVnvqmtUnBN-

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

  • @binaryaction5
    @binaryaction5 2 місяці тому

    @reza - how could I add the lookups that power automate use like location (to select Onedrive) or file (to select the filename) into a Canvas app?

    • @RezaDorrani
      @RezaDorrani  2 місяці тому

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

  • @gogiputkaradze
    @gogiputkaradze 4 роки тому

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому +1

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

    • @gogiputkaradze
      @gogiputkaradze 4 роки тому +1

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

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

  • @sharadpatil1320
    @sharadpatil1320 2 роки тому

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому

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

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

  • @rajanid3921
    @rajanid3921 3 роки тому

    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  3 роки тому

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

  • @sanishthomas2858
    @sanishthomas2858 8 місяців тому

    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  8 місяців тому

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

  • @sidkostas2
    @sidkostas2 2 роки тому

    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  2 роки тому

      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

  • @_cimbora
    @_cimbora 3 роки тому

    Super

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

  • @dhanyarose4191
    @dhanyarose4191 3 роки тому +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  3 роки тому

      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 3 роки тому +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.. 🙂

  • @frankiesaunders369
    @frankiesaunders369 2 роки тому +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  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

  • @electrichope4049
    @electrichope4049 10 місяців тому

    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  10 місяців тому

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

  • @PraskYoutube
    @PraskYoutube Рік тому

    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

  • @firstandforemost-z9b
    @firstandforemost-z9b Рік тому

    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  Рік тому

      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

  • @Lagging69
    @Lagging69 4 роки тому +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  4 роки тому +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.

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

  • @anthonyleduc
    @anthonyleduc 3 роки тому

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

    • @anthonyleduc
      @anthonyleduc 3 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      I do not :)

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      Great!

    • @anthonyleduc
      @anthonyleduc 3 роки тому

      @@RezaDorrani next video Maybe 😁

    • @RezaDorrani
      @RezaDorrani  3 роки тому +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 :)

  • @shannonp3mo169
    @shannonp3mo169 2 роки тому

    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 2 роки тому

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      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

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

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

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

  • @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 ua-cam.com/video/1_F9msqF-f8/v-deo.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 :)

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

  • @rinzzrockzz
    @rinzzrockzz 2 роки тому

    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  2 роки тому +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 2 роки тому

      @@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  2 роки тому +1

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

  • @MadRockway
    @MadRockway 3 роки тому

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

    • @RezaDorrani
      @RezaDorrani  3 роки тому

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

  • @premsaini4289
    @premsaini4289 Рік тому

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

    • @RezaDorrani
      @RezaDorrani  Рік тому

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

  • @Nadia-we3ht
    @Nadia-we3ht 3 роки тому

    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  3 роки тому

      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 3 роки тому

      ​@@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  3 роки тому

      @@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 3 роки тому

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

    • @Nadia-we3ht
      @Nadia-we3ht 3 роки тому

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

  • @myeonlvr
    @myeonlvr 2 роки тому

    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  2 роки тому

      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.

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

  • @musiclover6092
    @musiclover6092 6 місяців тому

    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  6 місяців тому

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

  • @ajayv2632
    @ajayv2632 2 роки тому

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

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

  • @keepitsimplenaruto6912
    @keepitsimplenaruto6912 2 роки тому

    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  2 роки тому

      ??

    • @keepitsimplenaruto6912
      @keepitsimplenaruto6912 2 роки тому

      @@RezaDorrani On adding Flow in power automate

    • @RezaDorrani
      @RezaDorrani  2 роки тому +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/

  • @juanpierrejesusgonzales933
    @juanpierrejesusgonzales933 3 роки тому +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  3 роки тому

      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.

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

  • @joycesumabat4092
    @joycesumabat4092 3 роки тому

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

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Microsoft renamed Common Data Service to Microsoft Dataverse.

  • @anthonyleduc
    @anthonyleduc 3 роки тому

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

    • @anthonyleduc
      @anthonyleduc 3 роки тому +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  3 роки тому

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

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Great!

  • @gargichakraborty2122
    @gargichakraborty2122 2 роки тому

    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  2 роки тому

      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 3 роки тому

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

    • @RezaDorrani
      @RezaDorrani  3 роки тому

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

  • @deepthikj-ui5iu
    @deepthikj-ui5iu 4 місяці тому

    How to pass attachment content along with additional parameters to flow trigger from power apps

    • @RezaDorrani
      @RezaDorrani  4 місяці тому

      I have done videos on passing data from apps to flows. Il recommend checking those videos.

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

  • @AndresCoronado-l5d
    @AndresCoronado-l5d Рік тому

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

    • @RezaDorrani
      @RezaDorrani  Рік тому

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

  • @dreamweaver9962
    @dreamweaver9962 4 роки тому

    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  4 роки тому

      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.

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

  • @isaidstream4547
    @isaidstream4547 4 роки тому +2

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

    • @RezaDorrani
      @RezaDorrani  4 роки тому +3

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

    • @isaidstream4547
      @isaidstream4547 4 роки тому +1

      @@RezaDorrani ohhh