Get Started with Power Automate Desktop: Tutorial for Beginners (2026)

Getting Started with Microsoft Power Automate Desktop

Installation and Initial Setup

• To begin using Microsoft Power Automate Desktop, ensure it is installed. A link for installation is provided in the video.

• After installation, create a new flow by clicking "New Flow" in the upper left corner and naming it (e.g., "Get Started Power Automate Desktop").

• The tutorial will cover web automation, loops, data extraction from Excel, email automation in Outlook, error handling, and logging.

Creating Subflows

• It’s best practice to divide flows into subflows to avoid long sequences of actions. This makes automation easier and more manageable.

• Start by creating an initialization subflow to open necessary programs. Name this subflow "Initialization" and save it.

Working with Variables

Setting Up Variables

• A variable acts as a container for values; use meaningful names for clarity (e.g., "Heatwise URL").

• Use the variable picker to assign values easily when launching browsers or performing other actions.

Browser Automation Basics

• Choose a browser (Edge or Chrome recommended), ensuring that extensions are installed for proper functionality.

• Set parameters such as window state (normal/maximized/minimized). Avoid image recognition unless necessary.

Running Flows and Testing

Executing Subflows

• When running a flow, it always starts at the main section regardless of which subflow is being edited. Ensure you have actions defined in your main flow.

• Test your initial setup by running the flow to confirm that the browser opens correctly.

Closing Browser Instances

• Create an end subflow to close the browser after completing tasks. Include user notifications about successful execution before closing.

Web Automation: Logging In

Storing Credentials Securely

• Store username and password securely within variables during initialization for easy updates if credentials change.

Building Login Subflow

• Create a login subflow where you populate text fields on a webpage using UI elements created through interaction with HTML code.

Searching and Extracting Data

Performing Searches on Web Pages

• After logging in successfully, automate searches by populating search fields on webpages using similar methods as login procedures.

Data Extraction Techniques

• Utilize Power Automate's extract data feature to pull specific information from web pages efficiently. Define elements clearly for accurate extraction.

Reading from Excel Files

Preparing Excel Data Handling

• Read data from Excel files instead of relying on UI automation; this method is faster and less prone to errors.

Iterating Through Data Rows

• Set up paths correctly for accessing Excel files within your project folder. Use variables effectively to manage file paths throughout your workflow.

This structured approach provides clear guidance through each step of utilizing Microsoft Power Automate Desktop while emphasizing best practices in automation design.

How to Automate Excel Data Processing with Power Automate Desktop

Initializing the Excel Worksheet

• The first line of the range in the Excel worksheet must contain column names for proper data reading.

• Testing is crucial during automation development to ensure that flows run correctly and handle different webpage states.

Iterating Through Tenant IDs

• A loop is established to iterate through each row in the Excel sheet, focusing on tenant IDs for data extraction.

• Best practices include using clear variable naming conventions, such as capitalizing each letter in variable names for better readability.

Searching and Extracting Data

• Instead of static values, dynamic tenant ID values from the current row are used for searches on a web page.

• Specific cell references are utilized to ensure accurate data retrieval from the correct columns in Excel.

Handling Multiple Searches

• The flow is designed to perform multiple searches efficiently without needing repeated logins, enhancing performance.

• Proper visibility settings for the Excel workbook prevent locking issues during automation execution.

Saving Results Back to Excel

• A new subflow named "Save to Excel" is created after data extraction, ensuring results are written back into the worksheet iteratively.

• The document should be saved under a new name (e.g., results.xlsx), preventing overwriting previous files.

Writing Data Back into Columns

• A helper variable is introduced to track which row in Excel will receive new data during iterations.

• Values extracted from web pages (like kitchen usage stats) are stored separately for clarity and ease of use later on.

Structuring Data Rows

• Each value extracted (kitchen, living room, bathroom usage stats) is assigned its own variable before being written back into specific columns in Excel.

• Creating a structured data row involves combining these variables into one cohesive entry before writing it back into the worksheet.

Error Handling Mechanisms

• Implementing error handling ensures that if a tenant ID does not exist or returns no results, the flow continues without interruption.

• An "if" condition checks whether an element exists on a webpage; if not found, an error message logs this status instead of halting execution.

Sending Emails with Usage Stats

• After processing tenant information successfully, automated emails containing usage statistics can be sent out dynamically based on available data.

• Outlook integration allows sending personalized emails directly from Power Automate Desktop by referencing tenant-specific email addresses.

This markdown file summarizes key processes involved in automating tasks using Power Automate Desktop while providing timestamps for easy navigation.