Learn how to get started with Microsoft Power Automate Desktop in this 2-hour complete course. If you're a Power Automate Desktop beginner, this tutorial is for you.
BEST POWER AUTOMATE DESKTOP RESOURCES:
📄 Microsoft official documentation: learn.microsoft.com/en-us/pow...
👨‍👩‍👧‍👦 Discord: / discord
📖 Clean Code Book (Amazon Affiliate): geni.us/lPdmRMR
🎓 How to get Certified: andersjensen.org/how-to-pass-...
💼 Let's connect on LinkedIn: / andersjensenorg
00:00:00 About the Course
This video course takes you through everything you need to build your own Power Automate Desktop flows.
00:00:41 Variables
Variables are containers for values and can be called by their names. We can create our own, and every PAD action produces one or more output variables.
00:31:10 Recorder
The Recorder in Power Automat Desktop is excellent when you want to learn new things. Instead of searching for the necessary actions, record yourself doing them, and Power Automate Desktop automatically translates them into actions.
00:39:00 If and Switch
Use an If action if you want your flow to take different paths based on a condition. A Switch action is an advanced If action where you can define a case for each outcome.
00:47:09 Loops
Iterate over collections with a For each loop. Use a Loop for a fixed amount of runs and a Loop condition if you want your flow to run as long as something is true.
0:58:11 Excel
The most used business application is Microsoft Excel, which is the application you automate the most as an RPA developer. Run through Excel sheets and update data with Power Automate Desktop.
1:18:11 Applications
In our toy example, we use the Windows Calculator because it's simple to understand the concepts and because it's the same approach we use when we automate more advanced applications.
1:28:02 Browser
How to open a browser and do a login: A fundamental process and a fundamental solution in Power Automate Desktop.
1:39:39 Files
Handle files based on their names and types. And create a log.
1:57:47 Dynamic Emails
Send Outlook emails based on an Excel sheet with dynamic content to dynamic recipients.
2:07:02 Web Scraping
When I teach RPA and Power Automate Desktop, the question I get the most is how to do web scraping. People get surprised when they see how easy it is.
2:17:16 Power Automate Desktop Resources
The best way to learn more about Microsoft Power Automate Desktop is to practice: Build, build and build. But the hidden gems are the official documentation, the I love Automation Discord, the Clean Code book, and taking the PL-500 Power Automate Desktop Associate Certification.
#powerautomate #powerplatform #microsoft365