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
Thanks for all your support 🙌🔥 My complete Power Automate Course: kzread.info/head/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
It is one of 'The Best' tutorials I have ever watched on KZread. Perfect.
@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
Thanks! The best tutorial.
@andersjensenorg
19 күн бұрын
Appreciated 😊 Kind regards, Anders
I love you 🥰 very detail way to show exception handling
@andersjensenorg
11 ай бұрын
😊 thank you, highly appreciated 🥰🙌
Thank you. I followed every step you did in this video and got much better understanding of Power Automate.
@andersjensenorg
9 ай бұрын
I'm so glad to hear, Kelly. Have you seen this video: kzread.info/dash/bejne/g56m2q6Jl8K6lKw.html Kind regards, Anders
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
Жыл бұрын
Thanks a lot 😅😍 I don't understand the rest 😔 Kind regards, Anders
Very helpful tutorial, well explained! 'MS API is busy' part at the end was funny 😂
@andersjensenorg
Жыл бұрын
Hey discrate - thanks a bunch 😃 Haha yeah, unfortunately that happens a couple of times a week. Kind regards, Anders
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
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
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
Жыл бұрын
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
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
Жыл бұрын
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.
Nice Coveage. Thanks.
@andersjensenorg
Жыл бұрын
I'm happy you liked it Stevan, thank you 🙌🙂
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
Жыл бұрын
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
Жыл бұрын
@@andersjensenorg okay yes I agree :-)
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
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
Superb Thank you very much. I want to hug you. Please create similar try catch for logic app. One request
@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
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
19 күн бұрын
Also. Thank you for excellent educational videos!
@andersjensenorg
18 күн бұрын
Thanks a lot for the clarification and nice words, Karil 😊🙌 Kind regards, Anders
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
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
I can't see the raw output of the activities, I don't know why it just shows me numbers or error.
@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