Business Technology

Power Automate Desktop: Automating Repetitive Tasks Without APIs

Power Automate Desktop automates repetitive Windows desktop tasks without requiring API access — web browser interactions (form filling, data scraping), desktop application data entry, file and folder operations, Excel manipulation, and copy-paste workflows between applications. Free for Windows 10/11 users for attended use (user present). Start by: installing Power Automate Desktop from the Microsoft Store, opening the flow designer, and using the recorder to capture your manual actions or dragging actions from the action library to build the automation. Connect to cloud flows for triggered, scheduled automation.

Published: 2021-09-16 | Last Updated: 2021-09-16 | 8 min read

Key Takeaways

  • Power Automate Desktop is free for attended automation on Windows 10 and 11 — Microsoft lowered the barrier to enterprise RPA to zero for the majority of business users.
  • Desktop flows complement cloud flows — cloud flows handle API-based integrations between SaaS systems; desktop flows handle UI-based interactions with applications that have no API.
  • The recorder feature allows capturing manual actions (mouse clicks, keystrokes, form entries) and converting them into reusable automation steps — no coding required for straightforward workflows.
  • Unattended automation (running desktop flows in the background on a schedule without a user present) requires the Power Automate per-user plan plus an unattended RPA add-on — the free tier is attended only.
  • The highest-ROI RPA use cases are high-volume, error-prone data entry tasks between systems that don't have API integration — particularly legacy ERP, accounting software, and government portals.

In March 2021, Microsoft made Power Automate Desktop free for all Windows 10 users — a significant expansion of RPA (Robotic Process Automation) access that had previously been an enterprise-tier capability. RPA automates repetitive tasks that a human performs on a computer: clicking through web forms, copying data from one system into another, processing files, and interacting with desktop applications — regardless of whether those applications have modern APIs. The business case for RPA is clear when the repetitive task is: high-volume (done dozens or hundreds of times daily), prone to human error (data entry mistakes), time-consuming relative to the actual cognitive effort required, and performed in systems that don't have integration-ready APIs (legacy ERP, government portals, industry-specific desktop software). Power Automate Desktop brings this capability to business teams at no additional cost for Windows users — with a recorder that captures manual actions and a visual flow designer that makes automation accessible to non-developers.

Definition: Attended vs Unattended RPA

Attended RPA is automation that runs on a user's computer while they're present — the user triggers the automation (clicks a button or shortcut) and may interact with it during execution, or the automation runs while the user watches and can intervene. Attended automation can run on standard Windows without special infrastructure. Unattended RPA runs automatically in the background without a human user — triggered by schedules, events, or other systems, running on a server or cloud-hosted virtual machine with no user logged in. Unattended automation is typically used for high-volume batch processing (processing 1,000 invoice records overnight) where no human interaction is required. In Power Automate, attended desktop flows are free with Windows 10/11; unattended desktop flows require licensing for the automation infrastructure (machines) and execution capacity.

Power Automate Desktop Use Cases and the Flow Recorder

The most valuable Power Automate Desktop use cases are data transfer between disconnected systems and high-volume form submission workflows that currently consume significant manual effort.

The data transfer category covers the most common business RPA scenario: information exists in System A and needs to be entered in System B, with no integration between them. A classic example is an accounting team that receives purchase orders in a web portal (System A) and needs to enter the order details into their ERP or accounting software (System B) — daily, for dozens of orders. A Power Automate Desktop flow reads the order from the web portal, copies the relevant fields, opens the ERP application, navigates to the new order form, and enters the data — repeating for each order in the queue. What takes a human 20 minutes per order can be processed by the desktop flow in 2 minutes with zero data entry errors.

The flow recorder is the starting point for most non-developer users: in Power Automate Desktop, click 'Record' and perform the task manually — the recorder captures each action (click this element, type this value, press Tab, click Submit) and converts them into editable flow actions. After recording, the flow is a sequence of captured actions that can be modified, parameterised (replace the specific data values with variables), and made conditional (if this condition, do this; else do that). For workflows that vary between iterations (each order has different values, each row in a spreadsheet has different data), the recorded actions are combined with loop actions and Excel/CSV read actions to process each item in a list.

File and document processing is another high-value category: renaming and moving files based on content or date rules, converting file formats (PDF to CSV, Word to PDF), splitting or merging PDF documents, extracting text from PDFs for data processing, and routing documents to the correct network folder based on extracted content. Power Automate Desktop includes built-in actions for PDF handling, file system operations, and document processing that make these workflows buildable without code.

  • Data transfer between disconnected systems — the primary RPA use case; no API required
  • Web form submission — fill government portals, legacy web applications, online reporting systems
  • Excel and spreadsheet automation — read from, write to, reformat, and process spreadsheet data
  • PDF data extraction and document routing — extract text, split/merge, rename, and file documents
  • Flow recorder — records manual actions and converts to automation; no coding needed for simple workflows

Combining Desktop Flows with Cloud Flows

Power Automate Desktop's full potential is realised when desktop flows are integrated with cloud flows — cloud triggers and data handling combined with desktop UI automation for end-to-end process automation.

A cloud flow can trigger a desktop flow — this connection enables event-driven RPA. When a specific email arrives in Outlook (cloud trigger), the cloud flow extracts the email attachment, stores it in SharePoint, and then calls the desktop flow to process the attachment in the legacy system. When a row is added to a SharePoint list (cloud trigger), the cloud flow calls a desktop flow to enter that row's data into the company's ERP system. This cloud-to-desktop trigger pattern enables unattended automation for attended desktop flow actions — though technically, the desktop flow still runs on a specific machine.

Power Automate Desktop connects to cloud flows through the 'Run a flow built with Power Automate Desktop' action in cloud flows. The desktop machine must have Power Automate Desktop installed, be registered as an automation machine in the Power Automate portal, and be powered on when the cloud flow triggers the desktop flow. For true unattended operation (no user required, any time of day), a dedicated automation machine — a server or always-on PC — is typically configured for RPA execution.

Experience Signal

The Power Automate Desktop implementations that deliver the fastest ROI are the ones where the manual task is clearly defined, high-volume, and currently performed by people who dread doing it — because the time savings and error reduction are immediate and measurable. A government grant reporting process that requires entering data from an internal system into a government web portal (which has no API and no data import feature) is a perfect desktop flow candidate: the portal is a web interface, the data is structured, and the process is identical for every record. We've seen single desktop flows save teams 10–20 hours per week on manual entry — the ROI calculation is straightforward.

Frequently Asked Questions

Power Automate cloud flows (previously called Microsoft Flow) automate processes between cloud services via APIs and connectors — they run in Microsoft's cloud without a human user present and trigger on events (email received, form submitted, record created). Power Automate Desktop flows (desktop flows) automate user interface interactions on a local computer — clicking buttons, typing in fields, copying data from one application to another — by recording or scripting those interactions. Desktop flows are RPA (Robotic Process Automation); cloud flows are integration automation. They're complementary: a typical process might use a cloud flow to trigger a desktop flow when a specific condition is met (e.g., when an email with a specific attachment arrives, run the desktop flow to process the attachment in a legacy system). Desktop flows run on an attended (user present) or unattended (background, requires Power Automate per-user with attended RPA plan) basis.

Sources

Have a Repetitive Process That Should Be Automated?

Webnixon builds Power Automate Desktop flows and end-to-end Power Platform automation — connecting cloud flows, desktop flows, and your existing systems to eliminate manual data entry.

Book a Power Platform Consultation

About the author

David Okafor

David Okafor

Developer

David is a full-stack developer at Webnixon with expertise in React, WordPress, and custom web application development. He contributes to complex front-end builds, API integrations, and performance-focused engineering for Webnixon clients. He writes about web development best practices, WordPress, and the technical side of building fast, maintainable websites.

Related Articles

Microsoft Flow: Automate Business Workflows Without Writing Code

Business Technology

Microsoft Flow: Automate Business Workflows Without Writing Code

Microsoft Flow is a cloud-based workflow automation tool that connects your business applications — Office 365, SharePoint, Dynamics 365, Salesforce, Slack, and hundreds more — and automates the repetitive handoffs between them. No code required. Here's what it can do and how to get started.

October 11, 2018Jai Paek8 min read
Power Apps for Remote Teams: Building Business Apps Without Developers

Business Technology

Power Apps for Remote Teams: Building Business Apps Without Developers

Remote work exposed the fragility of paper-based and manual processes. Microsoft Power Apps — part of the Power Platform — enables business teams to build custom mobile and desktop applications connected to their existing data without traditional coding. Here's how it works and where it delivers the most value.

September 17, 2020David Okafor8 min read
What Is Microsoft Power BI? A Business Guide to Data Visualisation

Business Technology

What Is Microsoft Power BI? A Business Guide to Data Visualisation

Microsoft Power BI is a business intelligence platform that connects to your existing data sources — Excel, Dynamics 365, Salesforce, SQL databases, Google Analytics — and turns that data into interactive dashboards and reports that your team can explore without SQL or coding knowledge.

July 18, 2019Jim Yang8 min read