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: https://learn.microsoft.com/en-us/power-automate/desktop-flows/introduction 👨‍👩‍👧‍👦 Discord: https://discord.gg/iloveautomation 📖 Clean Code Book (Amazon Affiliate): https://geni.us/lPdmRMR 🎓 How to get Certified: https://andersjensen.org/how-to-pass-the-pl-500-power-automate-rpa-developer-associate-certification-exam 💼 Let's connect on LinkedIn: https://www.linkedin.com/in/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