Skip to content

Power Automate Desktop

Power Automate Desktop is an RPA tool from Microsoft.

It lets you combine tasks on your computer that can be automated into a flow and run them.

By building flows for routine tasks you repeat throughout the workday, such as copying files, transferring data to Excel, or collecting information from websites, you can cut down the time those tasks take.

It comes preinstalled on Windows 11, and you can install and use it on Windows 10 at no additional cost.

All articles

49 articles

Text

  • Remove leading and trailing spaces from a string

    When you extract data from a website or on-premises software, you may get unnecessary data along with it. This article explains how to remove leading and trailing spaces from the text data you get.

  • Pad with zeros or spaces

    When you try to process the data you get, even a little, things don't always go the way you want. This article explains how to pad text data with zeros or spaces.

  • Change text to uppercase or lowercase

    Shows how to convert strings that contain letters to uppercase or lowercase.

  • Generate a random string for passwords

    Shows how to generate random strings, which is useful for things like creating passwords.

  • Fix garbled characters

    Power Automate can automate both web and on-premises tasks, but when you handle external data, you also need to pay attention to character encoding. This article explains what to do when an output file has garbled characters.

Number

  • Display thousands separators in numbers

    Power Automate Desktop can handle numeric data as variables, but as numbers get more digits, they become harder to read at a glance.

  • Get the decimal part of a number

    Shows how to get the decimal part of a number retrieved from a web page or a specific on-premises program.

  • Generate a random number

    Shows how to generate a different random number on each run, with a specified minimum and maximum value.

  • Truncate the decimal part of a number

    Shows how to get a value with the decimal part truncated from a number retrieved from a web page or a specific on-premises program.

  • Round a number

    Shows how to round a number retrieved from a web page or a specific on-premises program, and what to watch out for when the digit being rounded is exactly 5.

Date

  • Get today's date and the current time

    Shows how to get today's date and the current time.

  • Format a date in a specific format

    Power Automate Desktop has an action for getting the current date, so getting it is easy, but working with the date you get takes a little ingenuity.

  • Subtract from a date

    Explains how to subtract days, months, or years from a date you have retrieved. Power Automate Desktop has an action called "Subtract dates", but what it actually does is convert the difference between two datetime variables into a unit of your choice, so you can't use it to go back a specified period from a given date.

  • Get the day of the week

    Shows how to get the day of the week by using the DateTime type.

List

Clipboard

  • Working with the clipboard

    Power Automate Desktop can send keyboard input as hardware input, so it can reproduce user operations such as copy and paste. By using actions, you can also work with the clipboard directly.

  • Clear data stored on the clipboard

    Flows sometimes handle sensitive information, so it's best to leave as little data behind as possible and restore the state from before the run. This article explains how to clear the clipboard value.

  • Get data from the clipboard

    This article explains how to get text data from the clipboard.

  • Change the clipboard data

    Explains how to overwrite the clipboard value directly.

Flow

Mouse and keyboard

Variants and data types

  • Define variables

    Explains how to define variables, which you can use to hold and output values in a flow.

  • The "Set variable" action and data types

    In Power Automate Desktop, you add actions by dragging and dropping them in the GUI, but internally, flows are built in a programming language called Robin.

  • Define a variable with multiple properties

    There's no ready-made action for this, but with a little ingenuity, you can define a variable with multiple properties in a single action.

  • Create a list from JSON data

    Internally, flows are built in a programming language called Robin, so Power Automate Desktop can handle JSON data flexibly. This article explains how to create list data from JSON data.

  • Create a custom object (variable) from JSON data

    Power Automate Desktop has several data types for variables, and it can handle JSON data flexibly. This article explains how to create a custom object with multiple properties from JSON data.

Topics

  • Block user input while a flow is running

    Have you ever accidentally touched the mouse or keyboard while a flow was running and caused an action to go wrong? This article explains how to block user input while a flow is running.

  • Branch based on specific error conditions

    Each action has a predefined set of errors that can occur. When an error occurs, you can also branch the processing according to the type of error.

  • Scheduling

    The free version of Power Automate Desktop doesn't have a scheduled run feature, so you can't start a flow automatically at a specific date and time. Instead, you can create a flow that loops indefinitely, gets the current time, and branches only when a specific time is reached.

  • Extract and save images from a PDF

    Explains how to extract the images contained in a saved PDF file and save them as image files.

  • Print a specific file as a PDF

    Power Automate Desktop has a built-in action that prints a file by its path, but you can't choose which printer to use.

  • Read a file as text

    Explains how to read a specific file as text data, and what to do when the data you read has garbled characters.

  • Save a screenshot

    Power Automate Desktop provides several ways to deal with errors, such as debugging features and error-handling blocks, but when an error actually occurs, it can be hard to tell what situation caused it.

  • What to do when execution is slow

    Power Automate Desktop gets through business workflows far faster than a person can, but processes with many loops can still feel slow. This article introduces several ways to speed up execution, even a little.

  • Wait for less than one second

    If you set the "Wait" action to "20", the flow waits 20 seconds. This article shows how to wait for less than one second.

Encrypt

  • Decrypt files and text

    Power Automate Desktop also provides several actions related to security and encryption. This article explains how to decrypt encrypted text data.

  • Encrypt files and text

    Power Automate Desktop is designed to work not only with on-premises software but also with cloud services, and it provides several actions related to security and encryption. This article explains how to encrypt a text file.

  • Calculate hash values

    Explains how to hash text and file data and calculate the hash value.

XML

  • Get an element's value

    Explains how to get the value of a specific element from an existing XML file.

  • Add an element

    Explains how to add an element to an existing XML file or XML data.

  • Write to a file

    Explains how to write XML data that you have retrieved or created to a file.

Last updated: