
Power Automate Desktop is a no-code Windows software with a drag-and-drop designer to build desktop flows, run locally, while cloud flows run in the cloud with connectors.
The course roadmap guides learners from beginner to advanced through Power Automate Desktop, covering basics, UI automation, browser automation, PDFs, cloud flows, and next steps toward certification.
Discover how to reach the instructor via the Udemy Q&A for video questions, direct messages for course inquiries, and the link tree to access email updates and opportunities.
Download and install Power Automate Desktop on Windows 10 or 11 to create desktop flows with robotic process automation and web driver support for Edge and Chrome.
Create a simple flow in Power Automate Desktop to write text to a file, save, and run it to confirm the text appears in the created file.
Run a flow to create a folder in a predefined desktop directory, observe quick parsing and status, and confirm the folder is created and ready.
Learn to make flows adaptable by using input variables in Power Automate Desktop, creating var folder name and var file name, and inserting them into steps to drive dynamic paths.
Power Automate desktop demonstrates moving and copying files and folders with a destination folder, handling existing files (do nothing or overwrite), and running flows across computers, servers, and network drives.
Automate reading text from a file and writing it to a new, user-named folder in Power Automate Desktop. Use variables for folder names, and enable append when writing.
Learn to use get files in a folder to fetch subfolders and files, apply filters such as wildcard patterns, sort results by name, and preview results before validating folder existence.
Master the if folder exists and if file exists conditions in Power Automate Desktop to guard actions, create or rename folders, and test the flow.
Showcase power automate desktop flows using the if folder exists condition to rename a folder or create it when missing, and test logic to troubleshoot paths.
Learn how to zip and unzip files in Power Automate Desktop, including selecting files or folders, choosing compression levels, passwords, and appending to existing zip archives.
Learn how to manipulate and clean text in Power Automate Desktop, including trim, replace, join, pad, reverse, and subtext extraction, with case formatting and regex tips.
Advance your skills with Power Automate's text actions part two: parse text to extract variable-length segments, then split and join text using custom delimiters, reading from files and handling lists.
Explore power automate desktop text actions by mastering conversions between text, number, and date time, and learn to add or subtract dates, format results, and handle time zones.
Create random text in Power Automate Desktop to generate passwords by configuring length and character rules (uppercase, lowercase, digits, symbols) and output the password to a flow variable.
Discover Power Automate Desktop's recognize entities in text to extract dates, times, numbers, URLs, and other entities from multilingual text, enabling automated data extraction from tweets and documents.
Launch Power Automate Desktop and Outlook, then retrieve all email messages from a chosen inbox, inspect attachments and body details, using the data file name to target accounts.
Automate email handling by retrieving messages from Outlook and moving or saving attachments. Filter by sender or subject for recurring emails like weekly sales reports and save attachments to desktop.
Build skills to send emails from Outlook with Power Automate Desktop by launching Outlook, composing HTML messages with attachments, and using variables to personalize to, cc, and bcc.
Learn to leverage flow control with display messages and message boxes in Power Automate Desktop, prompting for user input, displaying file contents, and routing actions based on button choices.
Learn to enhance Power Automate Desktop flows with input dialogs, date dialogs, and file and folder prompts, collecting user input to drive file creation and workflow steps.
Configure the select file and folder dialogs, set initial folders such as documents, apply file filters, and keep the dialog on top and allow multi-select for uploading and storing files.
Use the display select from list feature in Power Automate Desktop to present users with A, B, or C choices, then route the flow based on their selection.
Demonstrates creating a list from a text file in Power Automate Desktop by reading the file as a list, building a file path with variables, and removing duplicates.
Extract data from CSV tables in Power Automate Desktop, convert a data table into a list by selecting a column, and handle first-line column names for accurate results.
Explore conditionals in Power Automate Desktop, including if and switch statements, build date-based reminders from CSV data, test logic with message boxes, and iterate on flows.
Master loop conditions in Power Automate Desktop, using while and conditional loops to run actions while a condition holds, manage variables, prevent endless loops, and increment counters for folder creation.
Master flow control in Power Automate Desktop by using stop and wait actions, add clear comments, and apply if conditions to manage file counts and existence checks.
Learn how go to and label enhance flow control in Power Automate Desktop, enabling you to jump between actions, manage large flows, and prevent endless loops.
Run a flow with a sub flow to calculate discounted price from a CSV upload, output to a sales list and a display list, and return to the main flow.
Demonstrates building UI flow automations in Power Automate Desktop by capturing UI elements, waiting for windows, and executing mail merge and save actions across Word and OneDrive.
Learn to automate desktop tasks with Power Automate Desktop by navigating UI elements, launching Word, performing mail merges, and using variables and dialog boxes to pull data and populate forms.
Leverage Power Automate Desktop to automate data entry and extraction in desktop apps, including Access, Word, and Excel, using the UI picker to map UI elements.
Learn to automate data entry and interactions with send keys, tabbing, and mouse movements. Use image capture and image-based clicks when user interface elements are misaligned in Power Automate Desktop.
Note: this course is specifically on Microsoft Power Automate Desktop, the application found on Windows 10/11 that enables users to automate their desktop and web tasks.
Do you want to automate a repetitive task on your desktop? Is there a daily / weekly / monthly task that you do on your desktop or web that you want to automate? Do you want more time back in your day, to focus on higher value business tasks? Then this is the course for you. Are you an automation enthusiast? Welcome to Microsoft Power Automate Desktop!
Learn from more than 12 hours of relevant instructional video content, with the only complete beginner to expert guide on Microsoft Power Automate Desktop
Any desktop or web related task can be automated. Learn how to automate folder and file creation, read and write excels, create conditional logic statements and loops, apply inputs and message boxes, manipulate text, integrate with cloud flows, and so much more.
The Microsoft Power Automate platform is quickly growing in demand and is currently the highest adopted system is medium-to-large companies (along with PowerApps) and one of the most sought after Microsoft skills, both personally and for business. People have leveraged Microsoft Power Automate to free up several hours in their work day, so that they can focus on more important things. In fact, Forrester has reported that Power Automate makes businesses on average 15% more efficient. Microsoft Power Automate empowers everyone, from end users to technology experts.
Microsoft Power Automate also contains powerful Robotic Process Automation (RPA) capabilities (both attended and unattended). You can start implementing RPA in your workflow with Power Automate. In fact, Power Automate was labelled as a Visionary by Gartner in July 2022, and RPA continues to become more popular.
This is the only complete guide to Microsoft Power Automate Desktop, from beginner to expert. This course is not only comprehensive (it covers everything you need to know right from the start / beginner level) but is also instructional in nature, meaning that as we learn new concepts, we are also integrating them in the application. Don't just learn concepts, learn how to actually apply them. That also means that whether you are a beginner or expert, there's something for you in this course.
This course is structured in a way that helps you learn all the concepts. For each concept, we first cover it in theory and then apply it using a real life example. We also progressively learn more and more advanced concepts, so that you never feel overwhelmed and can achieve your goals. There is also a Q&A section and you can always reach out to me.
Again, this is the complete guide to Microsoft Power Automate Desktop - you won't ever need another course.
What is Power Automate?
Microsoft Power Automate is a no-code and easy-to-use platform to automate repetitive tasks and improve efficiency. Individuals and workers use Power Automate to streamline their workflows and automate routine tasks, so they can focus more on high value work. Users of Power Automate has seen a 15% increase in productivity after using Power Automate for only a week.
What is the difference between Power Automate Cloud vs. Power Automate Desktop?
There are two main flavors of Power Automate: Cloud and Desktop
Power Automate Cloud: Cloud is used to automate tasks within software applications (think Emails, OneDrive, Twitter, Trello, SharePoint, Excel Online) that exist in the cloud. Connectors (or app bridges) are used, and a Microsoft 365 account is required. This course does not cover Power Automate Cloud.
Power Automate Desktop: Desktop is more popular, as it uses the programs on your local machine and works with desktop and web interactions. Anything that you do on your computer desktop or web, you can automate with Power Automate Desktop, including legacy and first-party applications. Power Automate Desktop is available to Windows 10 users, and comes pre-installed with Windows 11.
What can you do with Power Automate Desktop?
Microsoft Power Automate Desktop can be used to automate tasks in your desktop and web applications. Here are some of the tasks that you can automate with Power Automate Desktop, that you cannot with Power Automate Cloud:
Create, read, and write folders and files on your machine
Edit, read, and write local Excel files
Perform CMD and scripting actions
Create and read PDF files using OCR
Record actions on any software applications (even legacy or independent / first-party) and automate it
Automate web page clicking and typing, and extract values you need
Robotic Process Automation
What are the main features of Power Automate Desktop?
Desktop and web automation - automate anything on your desktop and on the web browser, including reading / writes files, sending and processing emails, and scraping values from websites
No code and easy to use - no code required; Power Automate Desktop uses a workflow designer that is a drag-and-drop based system
Comprehensive and extensible - automate all programs using UI Automation features, including legacy programs; extend to other software applications using recorders
Link to cloud flows - link Desktop flows to Cloud flows; enabling you to transfer information between both types and trigger unattended and attended Desktop processes
Sophisticated logic - use complex logic gates to make your Desktop flows sophisticated, including conditions, variables, loops, error handling, subflows, and more
Share flows - share flows with anyone, allowing you to create impact and improve productivity for yourself, your team, and across your organization
UI and browser recorders - create automated flows by recording the task yourself, and Power Automate Desktop does the rest
Robotic Process Automation - embrace RPA for both desktop and web by performing automation tests, in both attended and unattended desktops
The future - Microsoft has included Power Automate Desktop pre-installed in Windows 11 for a reason; automation available to everyone is the future
Why learn Power Automate Desktop?
Productivity - improve your productivity by automating routine and repetitive tasks; any task on your desktop or web can be automated, so you can get time back and focus on your high value tasks instead
Create impact - replace many business tasks with the click of a few buttons, and with no code; this means you could save your organizations countless hours in mundane work that can be automated
Improve your toolkit - add automation to your list of skills; automation is highly sought after, and works great with the full Power Platform suite (Power Apps, Power Automate Cloud, Power Virtual Agents, and so forth)
Why choose this course?
Complete guide - this is the 100% start to finish, zero to hero, basic to advanced guide on Power Automate Desktop. There is no other course like it that teaches you everything from start to finish. It contains over 12 hours of instructional content!
Fully instructional - we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the Power Automate Desktop features, but a course that actually builds applications with you
Step by step - we go through every single concept in a sequential order (from beginner to expert). This improves your probabilities of learning Power Automate Desktop rather than going haphazardly through each feature.
Learn to learn - during the latter parts of the course, we go through situations where we encounter new features or errors, and work through how we would use the documentation to resolve them. In this way, you not only learn about Power Automate Desktop inside and out, but learn how to resolve your own issues as they come up
Teacher response - if there's anything else you would like to learn, or if there's something you cannot figure out, I'm here for you!
Reference material - follow along! I provide all reference material directly to you so you can follow along in your learning journey
Course overview
Introduction - learn about Power Automate Desktop, its features, how to succeed in the course, course overview, and at the reference material
Beginner - create basic flows, perform flows with files and folders, manipulate text and date elements, and use email (Outlook) in your flows
Intermediate - Add inputs and message boxes for your users, make your flows more sophisticated using conditions, variables, loops, flow action controls, and Excel; automate any application using UI Automation
Expert - automate web activity using Browser Automation and recorders, performing database actions using HTTP, read PDF files using OCR, and integrate with your cloud flows
Advanced - automate systems, CMD actions, scripting actions (Python, Powershell), and learn about workstation actions
Conclusion - earn your Microsoft Power Automate Desktop certification, and read about next steps
If you want to learn Microsoft Power Automate Desktop, this is the course for you. We're looking forward to having you in the course and hope you earn the certificate.
Music credits: bensound