Power Automate Desktop for Beginners: Automate a Repetitive Task

Power Automate for desktop lets you automate repetitive work in Windows apps and web pages by recording what you do or by dragging actions into a flow, and it is free to start with a work or school account. You install the app, create a desktop flow, record or build the steps, test it and run it from the console. This guide takes you through installation, a first recorded flow, an Excel example, the limits that catch beginners, and what changes when you trigger the flow from a cloud flow.

Who this is for and what you will have

This is for people who repeat the same clicks in desktop apps, legacy systems or websites that have no connector or API, such as copying values between two programs. At the end you will have the app installed, a working desktop flow that you recorded and cleaned up, and a clear view of the licence and machine requirements for scheduled or unattended runs. If your target app has a connector, a cloud flow is usually simpler; see Power Automate licensing explained.

Prerequisites

Microsoft's requirements list includes:

• Windows 10 (Home, Pro, Enterprise), Windows 11 (Home, Pro, Enterprise), or Windows Server 2016, 2019, 2022 or 2025. Devices with ARM processors are not supported.
• Minimum hardware of a 1.00 GHz processor with two or more cores, 1 GB storage and 2 GB RAM. Recommended is 1.60 GHz, 2 GB storage and 4 GB RAM. Unattended mode needs four or more cores.
• TLS 1.2 and an active internet connection.
• A browser: Microsoft Edge (version 80 or later), Google Chrome or Mozilla Firefox, for web automation.
• An account to sign in. For a work or school account, the environment needs a Microsoft Dataverse database.
• Administrator rights if you use the MSI installer. A standard Windows account is enough for the Microsoft Store version.

Windows Home can author flows and run them locally in attended mode, and you can monitor them in the portal. It cannot run them from the cloud.

Step 1: Install the app

Microsoft offers two installation routes.

You cannot install both the MSI and Store versions on the same machine. Pick one.

To use the MSI:

1. Download Setup.Microsoft.PowerAutomate.exe from Microsoft's installer link and run it.
2. Select the features: Power Automate for desktop is the app to build and run flows. The Machine-runtime app connects the machine to the cloud for RPA, and the Java option installs files for UI automation in Java applets.
3. Accept the terms and select Install.

To use the Store, open the Power Automate for desktop page in the Microsoft Store and select Download.

From version 2.69 the app requires the .NET 10 runtime, and the MSI installer installs it if missing. Machines without access to the required download URLs need the runtime installed manually. If installation fails with error code 1603, Microsoft advises checking admin permissions, closing running instances and checking Windows Event Viewer.

Step 2: Sign in and create a flow

1. Open Power Automate from the Start menu and sign in with your work or school account.
2. Select New flow, and give it a name such as Copy order totals.
3. The flow designer opens with an actions pane, the main workspace and a variables pane.

A Microsoft account works too but has fewer features. Microsoft's comparison table says connectivity with cloud flows, Dataverse storage, sharing and centralised management are available only with an organisation premium account.

Step 3: Record a task

1. In the designer toolbar, select Recorder.
2. In the recorder window, select Record and perform the task in the target app or web page.
3. When you left-click or right-click, wait for the Wait for action message to disappear so the recorder captures the step.
4. Select Pause if you need to stop temporarily, and Add a comment to annotate.
5. Select Done to convert the recording into desktop flow actions.

The recorder tracks mouse and keyboard activity against UI elements and generates UI and browser automation actions. The UI elements it uses appear in the UI elements pane.

Choose a capture mode

For desktop applications the recorder can capture UI Automation (UIA) or Microsoft Active Accessibility (MSAA) selectors. Microsoft recommends UIA for most Windows apps, especially those built with WPF, WinForms or UWP, and MSAA for legacy apps such as VB6 or classic Win32 that do not expose UIA elements.

Image-based recording for stubborn apps

When an app does not expose accessibility information, select the dots icon in the recorder, enable Image recording, then record. The flow uses image recognition and OCR to find elements. If clicks land in the wrong place at run time, decrease the tolerance in the Move mouse to image action's advanced settings.

Step 4: Clean up the recording

Microsoft states that you should use the recorder to create the backbone of the flow, because most recorded tasks need modification. Loops and conditionals cannot be recorded, and recordings often include redundant actions.

1. Delete steps that repeat, such as extra clicks on the same field.
2. Replace fixed values with variables, so the flow can handle different inputs.
3. Add waits for pages or windows that load slowly.
4. Add Comment actions to explain sections.
5. Rename UI elements in the UI elements pane so selectors are readable.

Step 5: Use Excel actions

Many first flows read from or write to a spreadsheet. The Excel actions work on an Excel instance, which you create with Launch Excel or Attach to running Excel, and later actions refer to that instance variable.

1. Add Launch Excel and open an existing document. The action produces an Excel instance variable.
2. Add Read from Excel worksheet to get a single cell or a data table. Microsoft's example reads cells A1 through E5.
3. Use a For each loop over the data table to process each row. You add loops by hand because they cannot be recorded.
4. Add Write to Excel worksheet to write static data or a variable to one or more cells.
5. Finish with Close Excel, choosing whether to save the document.

Test with a copy of the workbook first.

Step 6: Run and debug

1. Select Run in the designer to run the flow locally.
2. Watch the highlighted action as the flow steps through, and use the variables pane to inspect values.
3. If an action fails, open its properties, check the UI element selector and use the flow's error handling options.

Power Automate logs up to 10,000 actions in a single desktop flow run. Additional actions still run but are not logged.

Running a desktop flow from a cloud flow

Local runs only need the app. Scheduled or event-driven runs go through a cloud flow with the action Run a flow built with Power Automate for desktop.

Prerequisites from Microsoft:

1. A registered machine or machine group. Signing in to the latest Power Automate for desktop registers the machine automatically in the selected environment, and the Machine-runtime app must be installed.
2. A work or school account, and a configured desktop flow connection.
3. The right licence for the run mode: an appropriate user licence for attended runs, or unattended capacity for unattended runs. The user who created the connection needs the licence.
4. Windows Pro, Enterprise or Server. Direct connectivity is not available on Windows Home.

In the cloud flow, choose Attended or Unattended as the run mode and select the desktop flow. Input variables appear as fields; input size is limited to 2 MB. Microsoft's limits include up to 70 desktop flow runs per minute per connection.

Attended versus unattended

An attended run uses the signed-in session of the user. An unattended run uses an unattended bot that signs in to the machine, runs the flow and signs out. Unattended mode needs a Process licence allocated to the machine, and each bot carries one run at a time. A Premium user must still register the machine. When you create a desktop flow connection you allow Power Automate to create a Windows session on your machine, so trust the co-owners of your flows.

Troubleshooting

• Installation stops with no error. Run the installer as administrator, remove any earlier Power Automate installation and check the system requirements.
• Cannot create flows: prompted to create a database. Work and school accounts need a Dataverse database in the default environment. Ask an admin to create it, then restart the app from the system tray.
• Recorder misses steps in the Start menu or system tray. Microsoft lists this as a known issue with no workaround.
• Flow created with a newer version won't open. You will see a message that the flow was generated by a newer version. Update Power Automate for desktop.
• Unattended run fails and logs are unclear. Enable video logs on the cloud flow's desktop action (version 2.66 or later); it records the last 60 seconds before a failure.
• Cloud runs do not start. Check that the machine is registered, the connection is valid, the licence matches the run mode and the machine is not in maintenance mode.

For cloud-side failures, use the routine in Power Automate flow failed: read run history and fix common errors.

Closing checklist

• The machine meets the requirements and the app is installed once, by MSI or Store.
• You signed in with the right account type for the features you need.
• You recorded the task, then cleaned and parameterised it.
• Loops and conditions were added by hand.
• You tested with sample data.
• For cloud runs: machine registered, connection created, licence confirmed for attended or unattended mode.

References

• Install Power Automate for desktop: https://learn.microsoft.com/en-us/power-automate/desktop-flows/install
• Prerequisites and limitations: https://learn.microsoft.com/en-us/power-automate/desktop-flows/requirements
• Record desktop flows: https://learn.microsoft.com/en-us/power-automate/desktop-flows/recording-flow
• Excel actions reference: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel
• Trigger desktop flows from cloud flows: https://learn.microsoft.com/en-us/power-automate/desktop-flows/trigger-desktop-flows
• Manage machines: https://learn.microsoft.com/en-us/power-automate/desktop-flows/manage-machines
• Types of Power Automate licenses: https://learn.microsoft.com/en-us/power-platform/admin/power-automate-licensing/types