
Learn to automate tasks without coding with Power Automate, a Microsoft tool for desktop, web, and cloud workflows, video lectures. Master desktop flows, variables, Power FX, and a capstone project.
Learn to automate repetitive tasks with Power Automate, covering cloud flows, desktop flows, and business process flows to boost productivity.
Discover what Power Automate Desktop is and how it enables free desktop and web automation on Windows 10 or above, with drag-and-drop actions, built-in recorder, scripting, debugging, and error handling.
Download and install Power Automate Desktop and its browser extensions, then sign in and launch the app. Enable Edge and Chrome extensions for seamless automation.
Introduces the new Power Automate Desktop user interface, guiding you through the left navigation panel, environments, flows, and Copilot-assisted automation for building desktop flows.
Explore environments in Power Automate, a logical container to store flows, apps, connections, and Dataverse data, enabling security, governance, lifecycle management, and clear separation of development from production.
Create an environment in Power Automate, explore sandbox, trial, production, and developer options, and configure settings in the Admin Center.
Create your first automation flow in Power Automate Desktop, configure a display message action to show a Hello world message, save, run, and verify a message box appears.
Explore how Power Automate Desktop enables robotic process automation, install its browser extensions, and build your first IT automation flow while organizing development, testing, and production workspaces.
Explore variables and their types in Power Automate Desktop. Learn how flow variables store data within the current flow for reuse, and distinguish input/output variables from flow variables.
Create and edit flow variables in power automate desktop, using automatic and manual methods, set variable actions, and rename and update values in the variables pane.
Discover how Power Automate Desktop assigns variable data types—text, numeric, boolean, and advanced types like data table, data row, custom object, and lists, using set variable actions.
Use simple data type variables to automate a smartphone purchase: generate three random numbers, compute the average discount, apply 10% tax, round the final cost, and display it.
Master variables and data types in Power Automate, learning to create and edit variables and apply simple and advanced data types in automation projects and browser automation with desktop flows.
Learn to automate browsers with Power Automate Desktop by launching supported browsers, installing extensions, and using browser automation actions to fill, extract, and interact with web data and services.
Discover how selectors define patterns to identify UI elements in Power Automate Desktop, using elements, combinators (greater-than signs or spaces), attributes, operators, and values, with dynamic wildcard customization.
Learn to use wildcard characters to build dynamic selectors in Microsoft Power Automate Desktop, enabling flexible web automation and resilient ui element targeting with asterisk, question mark, and square brackets.
Explore browser extension APIs in Power Automate Desktop to automate web tasks, manipulate browser elements, and integrate web pages, with cross-browser support and scripting possibilities.
Learn to automate web form filling with Power Automate Desktop by opening the admission form, populating text fields, selecting radio and checkboxes, and submitting—while debugging selectors.
Learn to extract titles from the Microsoft blog's featured section using a Power Automate Desktop flow that opens a browser, scrapes data, then displays results in a message box.
Master browser automation with actions, selectors, and wildcard dynamic selectors; learn browser extension APIs and populate or extract data on web pages, preparing for UI automation and recorder.
Explore UI automation for windows and desktop apps, including data extraction, form filling, and window manipulation. Understand how foreground behavior guides action execution and the next lecture on populating data.
Extend a Power Automate Desktop flow to open Notepad, populate extracted data into the Notepad, and save the file on the desktop using UI automation.
Learn to extract data from desktop applications by building a flow in Power Automate Desktop. Copy extracted text between Notepad files, append it, and save and close the files.
Record your on-screen activities with the recorder in power automate desktop; access it via the ribbon or tools tab, add comments, reset, and enable image-based recording with OCR.
Use the recorder in Power Automate Desktop to automate web and desktop tasks, extracting the titles of featured articles from Microsoft Blog and saving them to a notepad file.
Master UI automation by applying actions to populate and extract data in desktop apps using web-derived data, and use the recorder with desktop applications; next, explore conditionals in desktop flows.
Explore conditionals in Power Automate Desktop to drive decision making in flows, using if, else if, else, and switch actions with case and default case to handle true/false outcomes.
Demonstrates building a Power Automate desktop flow using the if group of conditionals to input marks, calculate the average percentage, and assign grades A to D.
Create a flow in Power Automate Desktop that asks for an alphabet input and uses a switch group of conditionals to display whether it is a vowel or a consonant.
Master conditionals and actions in automation flows, using if, else if, and else, plus switch case and default case actions in desktop flows; prepare for loops next.
Explore loops in Microsoft Power Automate Desktop, including the loop action, loop condition action, and for each action. Learn to repeat blocks, adapt flows to data, and process lists.
Master the loop action in automation flows to generate a multiplication table from user input in Power Automate Desktop, looping from one to ten and displaying results.
Learn to implement a loop condition in Power Automate Desktop to repeatedly display a multiple-choice question until the correct option is chosen, then show a success message.
Learn to use the for each action in automation flows to build a prices list, loop through items, compute tax and profit after tax, and display results.
Learn loop concepts and desktop flows, using loop actions, loop condition actions, and for each to iterate lists. Explore Excel actions to automate tasks in Microsoft Excel.
Learn how to automate Excel tasks with Power Automate Desktop, using actions to launch or attach workbooks, set an active worksheet, read and write data, and save and close files.
Master Excel actions in Power Automate Desktop to open a workbook, read a data range, loop through rows, convert text to numbers, and write results to a worksheet before saving.
Explore data table actions in Power Automate Desktop to read, write, add, remove, sort, and filter data from tables, enabling efficient automation.
Summarizes Excel actions and their types in Power Automate desktop, demonstrates using actions in desktop flows with data table actions, and previews file and folder automation in the next section.
Learn file and folder automation with Power Automate Desktop, including creating, renaming, moving, reading, writing, and converting files, and folder actions like copy, move, delete, and create folder.
Learn to build a Power Automate Desktop flow that uses file actions to extract Notepad files, convert them to WordPad files, delete originals, and display a completion message.
Automate file organization with folder actions in Power Automate Desktop by moving vendor files into extension-named folders under vendor files on the desktop and displaying a confirmation.
Master file and folder automation by using file actions and folder actions in Power Automate Desktop, and prepare for email automation using desktop flows in the next section.
Automate email tasks with Power Automate using SMTP/IMAP, Exchange, and Outlook actions to improve efficiency, ensure uniform communication, and reduce errors.
Master email automation by using Outlook actions to build flows, and prepare for database actions in Power Automate Desktop.
Microsoft Power Automate Desktop for Beginners: Build a Career in RPA
Want to build a career in robotic process automation (RPA) with Microsoft technologies but have never automated anything before? You are in the right place. This course starts at the very beginning, installing Microsoft Power Automate Desktop on your computer, and takes you all the way to a portfolio of working automation projects and the preparation to walk into RPA interviews with confidence.
Along the way, you will automate the repetitive work that eats up a workday: Excel reports, web tasks, email, files, folders and databases. You will build both desktop flows and cloud flows, learn how the two work together, and bring AI into your automations with Copilot. No coding or programming background is needed.
How the course teaches
Every topic follows the same rhythm, designed for beginners, so you always know what comes next:
Theory videos: understand each concept before you build with it.
Demonstration videos: watch the concept applied in a real flow.
Quizzes: check your understanding as you go.
Practice assignments: build automation projects on your own so the skills stick.
Capstone project: bring everything together in one comprehensive automation challenge.
What you will learn, step by step
Desktop flow foundations. Download, install and set up Microsoft Power Automate Desktop, get comfortable with its interface and environments, and build your first desktop flow. Then master variables, the building blocks of every automation you will create.
Core automation logic. Use conditions so your flows respond intelligently, loops to handle repetitive steps, and Power Fx, a robust feature that simplifies desktop flows with Excel-like formulas. Learn to test your flows so they run error free.
Automating everyday work. Automate websites with browser automation, mimic human-computer interactions with UI automation and the recorder, and take control of Excel, files and folders, email, and database actions. You will also integrate CyberArk for secure credential handling in desktop flows.
Cloud flows, work queues and AI. Transition to Microsoft Power Automate cloud flows, understand when cloud automation beats desktop automation, coordinate work at scale with work queues, and use Copilot to add AI to your flows.
Interview preparation and capstone project. Get familiar with the questions asked in Microsoft Power Automate and automation interviews, practice articulating your answers, and finish with a capstone project that applies everything you have learned to a real-world scenario.
Who built this course
This course is built by RPATech, an intelligent automation company that implements automation solutions for businesses and trains professionals on the same tools it deploys in real client work. When you learn Microsoft Power Automate here, you are learning it the way it is used on actual automation projects.
Where this can take you
By the end of the course, you will have a portfolio of automation projects to showcase your skills as an automation developer, and the knowledge to start building your career in RPA with Microsoft technologies. If Microsoft's PL-500 (Power Automate RPA Developer) certification is on your longer-term roadmap, the hands-on skills you build here give you a practical foundation for that path. To be clear, this is a skills course, not a PL-500 exam prep course.
Enroll now and build your first desktop flow today.