Error Handling and Creating a Detailed Log in Power Automate - Beginners Tutorial

Ғылым және технология

This tutorial shows how to create advanced error handling in Microsoft Power Automate. Based on the outcome of the errors, we make a detailed log in Excel.
📂 Download the course materials: andersjensen.org/microsoft-po...
VIDEOS FOR YOU:
🔹 Microsoft Power Automate Beginners Course: • Microsoft Power Automa...
🔹 Advanced Invoice Processing with AI Builder in Power Automate: • Advanced Invoice Proce...
POWER AUTOMATE GROUPS:
👨‍👩‍👧‍👦 Discord: / discord
- Join my network with 4500+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!
👩🏻‍🎓 LinkedIn: / 12566435
👨🏻‍💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: and
ersjensen.org/email-newsletter
0:00 Configure run after
Power Automate flows will terminate when they face an error. Therefore we do error handling so that we can continue after an error. In the action following the action with an error, you change the Configure run after setting and specify that this action should run after the previous action failed. Then we can see the status and error message of a failed action. Finally, we create an expression for the flow name to use in our log. This has the advantage that if the flow name changes, we use the updated name in our log.
19:32 Try, Catch, Finally
In programming, a Try, Catch, Finally block is used to handle errors. This is not natively built into Power Automate, but it's straightforward to create. A Try Catch Finally block consists of three scopes. In the Try, we place the actions likely to produce an error. The Catch performs the things when we have an error in the Try. The finally runs whether or not we have an error in the Try.
29:19 A More Detailed Log
We get the flow's date and URL in scope. With the URL, we let the user get a direct link to the failed (or successful) Power Automate flow. Finally, we'll email the detailed log and terminate the flow (= set the status to Failed).
37:03 Error Handling and Log for Multiple Transactions
Now we iterate through an Excel sheet, perform calculations and update log fields about the transaction. We still use our Try Catch Finally framework.
#powerautomate #powerplatform #office365

Пікірлер: 35

  • @andersjensenorg
    @andersjensenorg Жыл бұрын

    Thanks for all your support 🙌🔥 My complete Power Automate Course: kzread.info/head/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6

  • @shaibeezz
    @shaibeezz5 ай бұрын

    It is one of 'The Best' tutorials I have ever watched on KZread. Perfect.

  • @andersjensenorg

    @andersjensenorg

    4 ай бұрын

    You're very welcome, @shaibeezz - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: kzread.info/dash/bejne/qot63I-MaZm-d9I.html

  • @user-gm7mb6er2v
    @user-gm7mb6er2v20 күн бұрын

    Thanks! The best tutorial.

  • @andersjensenorg

    @andersjensenorg

    19 күн бұрын

    Appreciated 😊 Kind regards, Anders

  • @gurbachhansingh5715
    @gurbachhansingh571511 ай бұрын

    I love you 🥰 very detail way to show exception handling

  • @andersjensenorg

    @andersjensenorg

    11 ай бұрын

    😊 thank you, highly appreciated 🥰🙌

  • @kellyscott8952
    @kellyscott89529 ай бұрын

    Thank you. I followed every step you did in this video and got much better understanding of Power Automate.

  • @andersjensenorg

    @andersjensenorg

    9 ай бұрын

    I'm so glad to hear, Kelly. Have you seen this video: kzread.info/dash/bejne/g56m2q6Jl8K6lKw.html Kind regards, Anders

  • @sylvainchermanne4981
    @sylvainchermanne4981 Жыл бұрын

    super vidéo très pédagogique. l'auteur précise en cours vidéo que l'anglais n'est pas sa langue maternelle, ce qui le rend compréhensible facilement. il articule et il ne parle pas trop vite, on le comprend donc bien bien. ------------------------------------ great video very educational. the author clarifies in the video that English is not his native language, which makes it easily understandable. he articulates and he doesn't speak too quickly, so we understand him very well. ty for your work

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot 😅😍 I don't understand the rest 😔 Kind regards, Anders

  • @discrate
    @discrate Жыл бұрын

    Very helpful tutorial, well explained! 'MS API is busy' part at the end was funny 😂

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Hey discrate - thanks a bunch 😃 Haha yeah, unfortunately that happens a couple of times a week. Kind regards, Anders

  • @khaledalaqqad1934
    @khaledalaqqad19346 ай бұрын

    Wonderful Couse, My Advice to every beginner wants to learn Power Automate like me to watch these videos here at this channel I would like to thank this wonderful trainer my brother Anders (My brother in humanity) Thanks a lot

  • @andersjensenorg

    @andersjensenorg

    5 ай бұрын

    Thanks a bunch, @khaledalaqqad1934 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: kzread.info/dash/bejne/qot63I-MaZm-d9I.html You're more than welcome. Kind regards, Anders

  • @SalihKocaSK
    @SalihKocaSK Жыл бұрын

    Thanks for your video Anders, Very nice concept with very clear way to teach again. I realised why we should apply all the steps together with you during the video, I've made many mistakes 🙂 Also expressions look more complex in video but I realised it is very easy to use them when I try. All the best.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Hello Salih. Thanks a lot for the nice comment 😊 And yeah, you're right - everything is straightforward. A smart person like you, will have an easy time figuring it out - it's all about practicing. Have a great day. Kind regards, Anders

  • @mdhidayat5706
    @mdhidayat5706 Жыл бұрын

    Try to increase concurrency control to speed up the apply to each step. Concurrency Control is found in apply to each settings. Max allowed is 50 concurrency.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Great tip, Md - but I try to avoid a lot of non-default settings in these videos 😑 I'll hope Microsoft solve the 'Invalid expression...' in the first attempt anytime soon.

  • @StephanOnisick
    @StephanOnisick Жыл бұрын

    Nice Coveage. Thanks.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    I'm happy you liked it Stevan, thank you 🙌🙂

  • @KleinmeisterPang
    @KleinmeisterPang Жыл бұрын

    very nice video just a quick tip, you do not need to use ? multiple times when marching through the JSON, you can write all into one [] and use /

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot, my friend. And yes, I know, and use it. However, I think to add each step one by one does a lot for learning purpose. Kind regards, Anders

  • @KleinmeisterPang

    @KleinmeisterPang

    Жыл бұрын

    @@andersjensenorg okay yes I agree :-)

  • @user-ey5ge4gf9u
    @user-ey5ge4gf9u7 ай бұрын

    Thanks for your guide however i could not manage to pull scope try catch into "apply to each". It showed error "This action cannot be dragged into foreach as an action outside foreach depends on it.

  • @andersjensenorg

    @andersjensenorg

    7 ай бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @gurbachhansingh5715
    @gurbachhansingh571511 ай бұрын

    Superb Thank you very much. I want to hug you. Please create similar try catch for logic app. One request

  • @andersjensenorg

    @andersjensenorg

    6 ай бұрын

    Hey @gurbachhansingh5715. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @kariluonteri5221
    @kariluonteri522119 күн бұрын

    These videos has been done using old designer, which confused me. Then I noticed that there is a button in upper corner of designer table to switch Power Automates' new designer on and off. The new designer BTW shows easy way to read OUTPUT JSON data. (Check the raw data iputs/raw outputs in flow results of activity ).

  • @kariluonteri5221

    @kariluonteri5221

    19 күн бұрын

    Also. Thank you for excellent educational videos!

  • @andersjensenorg

    @andersjensenorg

    18 күн бұрын

    Thanks a lot for the clarification and nice words, Karil 😊🙌 Kind regards, Anders

  • @chandanmaity
    @chandanmaity11 ай бұрын

    How are you opening in browser. I don't see any option to use power automate in browser. How to do it? Please tell me

  • @andersjensenorg

    @andersjensenorg

    10 ай бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @SrdjanS_Automations
    @SrdjanS_Automations Жыл бұрын

    I can't see the raw output of the activities, I don't know why it just shows me numbers or error.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Келесі