What You’ll Build

In this guide, you’ll set up Power Automate Desktop (PAD) from scratch and create a practical desktop flow that extracts data from a web page and saves it to an Excel spreadsheet. By the end, you’ll understand the flow editor, actions library, variables, and how to run and debug your first flow.

This is the foundational skill for anyone starting their RPA journey on the Microsoft Power Platform.

Prerequisites

Before you begin, make sure you have the following:

Windows 10/11 (64-bit), PAD runs only on Windows
Microsoft 365 or Power Automate license, a free account works for local desktop flows
Power Automate Desktop installed, we’ll cover installation below
Microsoft Edge or Chrome, for the browser extension
Basic familiarity with Excel, you’ll save data to a spreadsheet

Business Context

Organisations across every sector deal with repetitive, manual processes that involve desktop applications, legacy systems, and web portals. Power Automate Desktop bridges the gap between cloud automation and the desktop, allowing you to automate tasks that don’t have APIs or connectors.

Common use cases include:

Data entry from emails or PDFs into line-of-business applications
Report generation by pulling data from multiple desktop sources
Web scraping to collect pricing, inventory, or compliance data
Legacy system integration where no API exists

Step-by-Step Guide

1. Install Power Automate Desktop

Power Automate Desktop comes pre-installed on Windows 11. For Windows 10, download it from the Microsoft website or install it via the Microsoft Store.

Open the Microsoft Store and search for “Power Automate”
Click Install and wait for the download to complete
Launch Power Automate Desktop from the Start menu
Sign in with your Microsoft 365 account

2. Install the Browser Extension

To automate web interactions, you need the browser extension:

When prompted during first launch, install the Power Automate browser extension
Alternatively, find it in the Edge Add-ons or Chrome Web Store
Enable the extension and ensure it’s active

3. Create Your First Flow

Click New flow in the Power Automate Desktop console
Name it “Web Data Extractor”
The flow designer opens with an empty canvas

4. Add a Browser Action

In the Actions pane on the left, expand Browser automation
Drag Launch new Microsoft Edge onto the canvas
Set the Initial URL to the web page you want to scrape
Click Save

5. Extract Data from the Web Page

Add an Extract data from web page action
Use the Live web helper to select the data elements you need
Click on table rows or specific elements, PAD will detect the pattern
Configure the extraction to capture all matching elements

6. Save to Excel

Add a Launch Excel action, choose “with a blank document”
Add Write to Excel worksheet action
Map the extracted web data variable to the Excel write action
Add a Save Excel action with your desired file path

7. Run and Test

Click the Run button (or press F5) in the flow designer
Watch as PAD opens the browser, extracts data, and writes to Excel
Check the output Excel file to verify the data

Testing and Validation

After running your flow, validate the results:

Check row counts, does the Excel file contain all expected rows?
Verify data accuracy, compare a few rows against the source
Test edge cases, what happens when the page has no data, or the structure changes?
Run multiple times, ensure the flow is idempotent and doesn’t duplicate data

Governance Considerations

Even beginner flows need governance awareness:

Environment: Run desktop flows in a dedicated environment, not your default environment
DLP Policies: Desktop flows can interact with any application, ensure your organisation’s DLP policies cover RPA
Credentials: Never hardcode passwords in flows; use credential variables or Windows Credential Manager
Logging: Enable flow run history for audit trails
Sharing: Desktop flows are personal by default; share via cloud flows if team access is needed
Machine management: Register machines in the Power Automate portal for centralised monitoring

Common Gotchas and Troubleshooting

Browser extension not detected: Close all browser instances, reinstall the extension, and relaunch PAD.

Selectors break after page update: Web page structures change. Use more resilient selectors (e.g., CSS selectors based on IDs rather than positional indexes).

Flow works manually but fails unattended: Ensure the machine is unlocked (or use an unattended runner license) and that screen resolution matches the authored flow.

Excel file locked: Close any open instances of the target Excel file before running the flow.

Taking It Further

Once you’re comfortable with the basics, explore these next steps:

Error handling: Add On block error actions to handle failures gracefully
Subflows: Break complex automations into reusable subflows
Cloud integration: Trigger desktop flows from Power Automate cloud flows
Variables and loops: Process lists of items dynamically
UI automation: Interact with desktop applications that lack web interfaces

Getting Started with Power Automate Desktop