The best Power Automate community is free: discord.gg/iloveautomation 🔥 We're more than 8000 RPA developers ready to network and help you.

My learning journey on Power Automate is much better with your videos! Thanks!

Here are some effective programming techniques I have honed over my career as a developer: Regardless of the language or automation software I'm using, I generally start with a copy of a pre-developed layout, which will be the standard for all automations. Here are the steps I usually follow: The first subroutine or subflow of the project is Sub_Define_initialization_variables: at this point, I define directories, parameters, keys, and everything related to the automation workspace, using regions. The second subroutine or subflow of the project is Sub_Control_room: this section houses Boolean variables that can change the systems environments and logins. It includes everything related to environments and logins. The third subroutine or subflow of the project is Sub_Error_handling: in case of error, I direct it to this routine, which is responsible for recovering the cause of failure, sending emails, inserting information into SQL, and everything related to the last action that the automation will perform in case of failure. Here's a tip for beginners or for those who want to make their projects more scalable and easy to maintain: It's useful to differentiate your subroutines or subflows using the initial prefixes: Sub_ or Func_. To me, the difference is clear: Sub_ is used to store variable assignments, large sections of code, or even a small "function". However, what differentiates it from Func_ is that the latter mimics a function, as it allows to perform a task using unique variables as internal input and output. This way, when someone goes to perform maintenance on your automation, they will know that the Func_Function_name routine receives or returns parameters that are exclusive to it.

I've been looking for something like this for a while now. Great to finally have a video on it! Thank you very much

Absolutely amazing job! I had a goal of learning better logging methods and learning how to do error handling better and this video nailed it! Thanks so much

One of the best use case covering all best practices of PAD. Thank you a lot Anders.

Love it, especially the fact that the info reaches a lot of people. Thx for the plug :) Quick tip, if you want to include the subflow in your tracelog, you can create an error on purpose (convert 'penguin' to a number), force the flow to continue, get the last error and read the subflow from %lastError% :)

There's so much valuable information in this video. I'll share with my team. Thanks again!

This video really helped me learning PowerAutomate from UIPath. Thanks alot! I hope you also have a tutorial on form modification (edit) with checkboxes soon. 👏🏻

Exactly what I was looking for. Appreciate it. If you can create more advanced videos that would be great

In your loops, I noticed you use the Set Variable to increase the LoopIndex by 1 each time. There is a dedicated function called 'Increase Variable' that is made specifically for that. I never use the search bar to find functions because looking through the list helps me remember what commands are available and sometimes I spot one I've never noticed before that's perfect for what I need.

Excellent course - wish I could continue from the Work Queues portion and on because PA users require an attended RPA' license for that. But thanks anyway for teaching that if we did have it.

Hi Anders, Great KZfaq videos. I'm new to PA Desktop. Do you do offer one on one tutoring (through Teams or other platforms) Cheers Warren

Anders, great video. In future videos could you please set the volume louder, so that I don't get earraped with ads? 😅

Thanks Andres

Thank you Ander, keep up the good work

your videos are amazing just the issue I face is with volume, its too low

Thanks

Thanks Anders!

Dear Anders, I would like to express my deep appreciation to you because of your interruptions. Everyone in my company has come to think that I am a great programmer. Thanks a lot for your wonderful explanation. I would like to ask a question. When you are creating (FOR EACH) action you put a set variable before it, that is clear for me. Then you put another (set variable +1) action before end, why not use the (increase variable) action instead of (set variable +1) action what is the difference.

Many thanks for creating this video. I have a humble request, please speak a little louder in your videos. Thanks again.

In the log I suggest you include the loop index, where appropriate, in the comment field

Thanks for the video . Very informative.. one question - How do we implement auto re-queue in case of system exception?

At 51:09 you are only processing transaction if status is empty. But data check will set it to Success. I think you need to check for empty or Success.

Hello Anders, thank you for your videos and detailed explanations. I was wondering if there is an option to set the modal option to True in order to prevent users to change the focus from the Input Dialog to the web page behind. I cannot see this option neither in the Display Input Dialog nor the Custom Form, and I was wondering that maybe there is an option by copy-pasting the code in NotePad and adding a new parameter like \"modal\": true or \"focus\": true. However, all my manipulations didn't work... Do you have any idea on how to solve this? Thank you

Hi, I learned a lot from your tutorials. Many thanks ! I have already created several working flows with Power Automate Desktop in the meantime. I do have one very big problem thoug: The performance ! My flows no longer contain any errors, I don't get any error messages. Sometimes the flows run smoothly and at a reasonable speed. But an hour later or the day after, the same flow (without any change) suddenly doesn't advance anymore. Some steps take several minutes before they are executed. And a few hours later, it's fine again. But sadly, more often it goes much too slow. Is this an experience you also have? I am now working with PAD under Microsoft 365 Business Premium. What could be the cause of the weak and unstable performance ?

Is there a way to create new queue items from PAD?

Valeu!

How many actions per worflow is recommended in PAD? I mean which amount is considered too much for a unique flow or subflow?

Is it possible that you do a tutorial that shows how Power Automate Desktop is communicating with files on a sharepoint? It seems that I need to know how JSON works. I'm really struggling with the syntax and the key values

Why .csv and not .txt for log files?

The power CAT team has published a great tool called the automation kit, for (among other things) visualizing and analyzing logs. Why would you recommend handling logs as csv in the local machine instead of using power automate's built-in cloud-based logging system.

One issue that I see is that you are putting line numbers in the status messages but these will be outdated if code is added or removed

Thanks. Please Sir, on the WordPress site which plugin do you use to build the form and the table ?

please refer to video at time 16:55, i trying to do the same accessing induvial values from 'currentitem' same syntax but it throws error "Parameter 'Text To fill-in': Unexpected characters. Characters are used in the formula in an unexpected way." isthere any way out ?

Hi Anders, How to remove duplicate entries from excel file after launch excel from a path. I am using VBscript for this. 1:- Set objExcel=GetObject("Excel.Application") 2:- Set object=pnjabi.worksheets(1) 3:- objExcel.Visible=true 4:-objSht.UsedRange.RemoveDuplicates 1,1 The duplicate entries are in column A only and this is the script I have used but not getting output

Seria legal se mostrasse o nome da música qnd estivesse tocando.