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 articlesText
- 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
- Remove items from a list
Shows how to remove all or some of the items in list data.
- Create a list
In Power Automate Desktop, a variable that can hold multiple values is called a "list". This article shows how to create a list.
- Multidimensional arrays
Explains how to create multidimensional arrays (arrays of arrays) by using list data.
- Remove duplicate data from a list
Explains how to remove duplicate data from the values stored in a list.
- Merge lists
This article explains how to merge multiple lists and get the merged list.
- Sort the data stored in a list
Explains how to sort the data stored in a list.
- Set multiple initial values in a list
When you need to define a list and put several initial values in it, building the flow by combining "Create new list" and "Add item to list" makes the flow longer as the number of items grows.
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
- Set multiple conditions in a conditional branch
Explains how to set multiple conditions in a single If statement by using the Boolean type, which returns true or false.
- Implement an infinite loop (repeated processing)
The free version doesn't support scheduled runs, so many people keep a flow running continuously without ending it, for example to monitor for a specific event. This article shows how to implement an infinite loop.
Mouse and keyboard
- Double-click a specific point
Explains how to reproduce double-clicking a specific point with the mouse.
- Click the wheel button (middle-click)
Explains how to reproduce pressing down the wheel between the left and right mouse buttons, also known as the wheel button, middle button, or middle-click.
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.
No matching articles.
{visible} of {total}