Become RPA Master in Microsoft Power Automate Desktop

Learn how RPA uses software robots to automate high-volume, repeatable tasks across applications, delivering a virtual workforce that boosts quality, speed, and cost efficiency.

Explore how Microsoft Power Automate enables cloud-based automation of workflows and UI flows across desktop and web apps, using triggers, actions, and hundreds of connectors to automate repetitive tasks.

Learn how Microsoft Power Automate Desktop uses three account types—Microsoft account, work or school account, and organization premium account—and how Dataverse storage, flow storage, and collaboration differ across them.

Explore pay-as-you-go licensing for Power Automate: run cloud or desktop flows and pay per flow run (cloud/unattended flows $0.60; unattended desktop $3), coexists with prepaid plans, and uses Azure meters.

Learn how Power Automate Desktop enables low-code desktop automation with a drag-and-drop designer, 370 plus actions, and seamless cloud versus desktop integration, now free for Windows 10 users.

Learn the hardware and software requirements to install Power Automate Desktop, including processor, RAM, storage, and .NET framework, plus supported operating systems, browsers, and cloud integration options.

download and install Power Automate Desktop from the Microsoft Power Automate portal, ensuring a subscription and a 64-bit Windows system, then set up the desktop app and browser extensions.

Microsoft Power Automate and Power Automate Desktop contrast cloud flows with desktop flows, highlighting no-code automation, connectors, and recorder tools to automate desktop and web tasks.

Create a desktop flow in Power Automate Desktop, drag actions in the designer workspace, and display a hello world message; run the flow to view the output.

Master list variable actions in Power Automate Desktop by creating a new list, adding items, removing items by index or value, and clearing the list with a practical employee example.

Explore how to manage lists in Power Automate Desktop by removing duplicate items (with an option to ignore text case), reversing the list, and shuffling to create random orders.

Master conditional actions in Power Automate Desktop, including if and switch blocks with file exists, folder exists, and text on screen. Use else if and default cases for true/false logic.

Master advanced conditional actions in Power Automate Desktop, including if folder exists, if file exists, and if process, and learn to create folders, write text to file, and terminate processes.

Use the for each loop to iterate over a list, data table, or data row, displaying each current item as an employee name in Power Automate Desktop.

Learn to insert data into a SQL Server table with a stored procedure in Power Automate Desktop by reading Excel, looping over rows, and executing parameterized inserts.

Learn to launch Excel with Power Automate Desktop, read data from Excel into a data table, write it to a text file, and close Excel.

Create an Excel instance in Power Automate Desktop, open the document, and use add new worksheet action to insert a sheet named employee details as first or last, then save.

Learn to activate a specific Excel worksheet in Power Automate Desktop using set active Excel worksheet, choosing by name or index, and write data with write to Excel worksheet.

Master how to extract the first free column and row from an Excel worksheet in Microsoft Power Automate Desktop, read data from the worksheet, and manage the Excel instance lifecycle.

Master Power Automate Desktop to retrieve the first free row in a given column of an active Excel worksheet, using a loop to iterate columns and store results.