Ui Path

Power Automate Desktop Actions Cheat Sheet
by RPAWorld (VJR) via cheatography.com/153513/cs/33003/
Variables Variables (cont) UI automation (cont)
Truncate number Convert JSON to custom object Wait for image

Get the integral or fractional digits of a Convert a JSON string to a custom object This action waits until a specific image
numeric value, or round up the value to a Convert custom object to JSON appears on the screen or on the foreground
specified number of decimal places window
Convert a custom object to a JSON string
Generate random number Hover mouse over UI element in window
Add item to list
Generate a random number or a list of Hover the mouse over any UI element on
Αppend a new item to a list
random numbers that fall between a window
Create new list
minimum and maximum value Click UI element in window
Create a new empty list
Clear list Clicks on any UI element of a window
Increase variable
Remove all items from a list Select menu option in window
Increase the value of a variable by a
Remove item from list Selects an option in a menu of a window
specific amount
Remove one or multiple items from a list Drag and drop UI element in window
Decrease variable
Sort list Drags and drops a UI element of a window
Decrease the value of a variable by a
Sort the items of a list. Use items of the Expand/collapse tree node in window
specific amount
same type
Set variable Expands or collapses a node of a tree view
Shuffle list residing in a window
Set the value of a new or existing variable,
Create a random permutation of a list If window
create a new variable or overwrite a
Merge lists previously created variable This action marks the beginning of a condit‐
Merge two lists into one ional block of actions depending on whether
Reverse list UI automation a window is open or not or whether a
window is the focused (foreground) window
Reverse the order of the items of a list If window contains
Wait for window
Remove duplicate items from list Marks the beginning of a conditional block
of actions depending on whether a specific Suspends the execution or the process until
Remove the multiple occurrences of items
piece of text or UI element exists in a a specific window opens, closes, get or
in a list, so that in the resulting list each
window loses the focus
item will be unique
Wait for window content
Find common list items
UI automation - Data Extraction
Suspends the execution of the automation
Compare two lists and create a new list with
until a specific piece of text or UI element Get details of window
the items that are common to both
appears or disappears from a Window Gets a property of a window such as its title
Subtract lists
If image or its source text
Compare two lists and create a new list with
This action marks the beginning of a condit‐ Get details of a UI element in window
the items that are in the first list but not in
ional block of actions depending on whether Gets the value of a UI element's attribute in
the second
a selected image is found on the screen or a window
Retrieve data table column into list
not Get selected checkboxes in window
Convert the contents of a data table column
Use desktop
into a list
Performs desktop and taskbar related
operations
Select tab in window
Selects a tab from a group of tabs
By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

cheatography.com/vjr/ Last updated 14th December, 2023. Learn to solve cryptic crosswords!
Page 1 of 17. http://crosswordcheats.com
UI automation - Data Extraction (cont) UI automation - Windows (cont) Browser automation (cont)
Retrieves the names of the selected Activates and brings to the foreground a Launch a new instance or attach to a
checkboxes in a checkbox group or the specific window running instance of Edge for automating
state of a specific checkbox Set window state web sites and web applications
Get selected radio button in window Restores, maximizes or minimizes a Create new tab
Retrieves the names of the selected radio specific window Create a new tab and navigate to the given
button in a radio button group or the state of Set window visibility URL (supported in Edge, Chrome and
a specific radio button Firefox)
Shows a hidden window or hides a visible
Extract data from window window Go to web page
Extracts data from specific parts of a Move window Navigate the web browser to a new page
window in the form of single values, lists, or Click link on web page
Sets the position of a specific window
tables
Resize window Click on a link or any other element of a
Take screenshot of UI element web page
Sets the size of a specific window
Takes a screenshot of a UI element in Click download link on web page
Close window
window
Click on a link in a web page that results in
Closes a specific window
downloading a file
UI automation - Form filling
Browser automation Run JavaScript function on web page
Focus text field in window
Run a JavaScript function on the web page
If web page contains
Sets the focus on a text box of a window
and get the returned result
and scrolls it into view Mark the beginning of a conditional block of
Hover mouse over element on web page
actions, depending on whether a specific
Populate text field in window
piece of text or element exists in a web Hover the mouse over an element of a web
Fills a text box in a window with the
page page
specified text
Wait for web page content Close web browser
Press button in window
Suspend the flow until a specific piece of Close a web browser window
Presses a window button
text or web page element appears or
Select radio button in window disappears from a web page Browser automation - Web form filling
Selects a radio button on a window Launch new Internet Explorer Focus text field on web page
Set checkbox state in window Launch a new instance or attach to a Set the focus on an input element of a web
Checks or unchecks a checkbox in a running instance of Internet Explorer for page and scroll it into view
window form automating web sites and web applications Populate text Field on web page
Set drop-down list value in window Launch new Firefox Fill a text field in a web page with the
Sets or clears the selected option(s) for a Launch a new instance or attach to a specified text
drop-down list in a window form running instance of Firefox for automating Set check box state on web page
web sites and web applications
Check or uncheck a check box in a web
UI automation - Windows Launch new Chrome form
Get window Launch a new instance or attach to a Select radio button on web page
Gets a running window, for automating running instance of Chrome for automating
Select a radio button on the web page
desktop applications web sites and web applications
Set drop-down list value on web page
Focus window Launch new Edge

Browser automation - Web form filling (cont) Mouse and keyboard (cont) Azure
Set or clear the selected option for a drop- Retrieves the current position of the mouse Create session
down list in a web form cursor on the screen in pixel coordinates Creates an Azure session
Press button on web page Move mouse Get subscriptions
Press a web page button Moves the mouse to a specific position Gets subscriptions that the current account
Move mouse to image can access
Browser automation - Web data extraction
Moves the mouse over an image found on End session
Extract data from web page screen or on the foreground window Ends an Azure session
Extract data from specific parts of a web Move mouse to text on screen (OCR)
page in the form of single values, lists, rows Azure - Resource groups
Moves the mouse over a text found on the
or tables
screen or on the foreground window using Get resource groups
Get details of web page OCR
Gets the resource groups based on the
Get a property of a web page, such as its Send mouse click specified criteria
title or its source text
Sends a mouse click event Create resource group
Get details of element on web page
Send keys Creates a new resource group
Get the value of an element's attribute on a
Sends keys to the application that is Delete resource group
web page
currently active
Deletes the specified resource group and all
Take screenshot of web page
Press/release key the contained resources
Take a screenshot of the web page (or an
Presses (and holds) or releases one or
element of the web page) currently Azure - Virtual machines
more modifier keys (Alt, Control, or Shift)
displayed in the browser and save the
Set key state Get virtual machines
image into a file or to the clipboard
Sets the state (on or off) for the keys Caps Gets the basic information for the virtual
HTTP Lock, Num Lock or Scroll Lock machines
Wait for mouse Describe virtual machine
Download from web
Suspends the execution of the flow until the Gets all the information for the virtual
Downloads text or a file from the web and
mouse pointer changes, usually to or from machine(s) based on the specified criteria
stores it
the 'wait cursor' or hourglass Start virtual machine
Invoke SOAP web service
Get keyboard identifier Starts the virtual machine
Invokes a method from a SOAP web
Retrieves the active keyboard identifier from Stop virtual machine
service
the machine's registry
Invoke web service Stops the virtual machine and deallocates
Wait for shortcut key the related hardware (CPU and memory)
Invokes a web service by sending data and
Pause the flow run until a specific shortcut and network resources
retrieves the response from the web service
key is pressed. Shortcut keys must contain Shut down virtual machine
at least one key or a key and one of (ctrl, alt,
Mouse and keyboard Shuts down the operating system of a
shift). Multiple shortcut keys can be defined
Block Input virtual machine
Blocks user mouse and keyboard input, so Restart virtual machine

that the flow can perform mouse and Restarts a virtual machine
keyboard actions without interference from
the user
Get mouse position

Cryptography Google cognitive - Natural language (cont) SharePoint ♦ (cont)
Encrypt text with AES Invokes the Google Cloud Natural Uploads a file to a SharePoint site. Make
Encrypt a string with AES, using a key and a Language service named 'Analyze Syntax' sure to pick an existing library.
specified encoding format List folder
Google cognitive - Vision
Decrypt text with AES Returns files contained in a SharePoint
Label detection folder.
Decrypt a string with AES based on a
specified key and an encoding format Invokes the Google Cloud Vision service Get all lists and libraries
named 'Label Detection'
Encrypt from file with AES Get all lists and libraries.
Landmark detection
Encrypt the contents of a file with AES, Get file metadata
using a key and a specified encoding format Invokes the Google Cloud Vision service
Gets information about the file such as size,
named 'Landmark Detection'
Decrypt to file with AES etag, created date, etc. Uses a file identifier
Text Detection to pick the file. Use Get file properties
Decrypt a string to a file with AES based on
a specified key and an encoding format Invokes the Google Cloud Vision service action to get to the values stored in the
named 'Text Detection' columns in the library.
Hash text
Logo detection Get file metadata using path
Hash a string, using a specified algorithm
and an encoding format Invokes the Google Cloud Vision service Gets information about the file such as size,
named 'Logo Detection' etag, created date, etc. Uses a file path to
Hash from file
pick the file. Use "Get file properties" action
Image properties detection
Hash the contents of a file, using a specified
to get to the values stored in the columns in
algorithm and an encoding format Invokes the Google Cloud Vision service
the library.
named 'Image Properties Detection'
Hash text with key
Get folder metadata
Safe search detection
Hash a string with a key, using a specified
Gets information about the folder. Uses a
algorithm and an encoding format Invokes the Google Cloud Vision service
file identifier to pick the folder.
named 'Safe Search Detection'
Hash from file with key
Get folder metadata using path
Hash the contents of a file with a key, using
SharePoint ♦ Gets information about the folder. Uses a
a specified algorithm and an encoding
folder path to pick the folder.
format Update file
List root folder
Updates the contents of the file specified by
CyberArk the file identifier. Returns files in the root SharePoint folder.
Delete file Extract folder

Get password from CyberArk
Deletes the file specified by the file identi‐ Extracts an archive file into a SharePoint
Retrieves a password for a specific applic‐
fier. folder (example: zip).
ation from CyberArk
Get file content using path Get lists
Google cognitive - Natural language Gets SharePoint lists from a site.
Gets file contents using the file path.
Analyze sentiment Get file content Create sharing link for a file or folder
Invokes the Google Cloud Natural Get file contents using the file identifier. The Create sharing link for a file or folder.
Language service named 'Analyze contents can be copied somewhere else, or Copy file
Sentiment' be used as an attachment.
Analyze entities Create file
Invokes the Google Cloud Natural
Language service named 'Analyze Entities'
Analyze syntax

SharePoint ♦ (cont) SharePoint ♦ (cont) SharePoint ♦ (cont)
Copies a file. Works in a similar way to the Get list views Gets the properties saved in the columns in
"Copy to" command in SharePoint libraries. Gets views from a SharePoint list. the library for all folders and files stored in
Returns information about the new file after the library. You can also filter down to the
Add attachment
copy. items that match a condition. An "Apply to
Adds a new attachment to the specified list
Move file each" section is usually used to work with
item
the output from this action. When using this
Moves a file. Works in a similar way to the
Set content approval status with the On-Premises Data Gateway, the
"Move to" command in SharePoint libraries.
Sets the content approval status for an item name of the library to connect to may need
Returns information about the new file after
in a list or library that has content approval to be entered manually.
move.
turned on. You must provide an ETag for Create item
Copy folder
pages and files. You can get the ETag
Creates a new item in a SharePoint list.
Copies a folder. Works in a similar way to using the Get File Metadata action. This
the "Copy to" command in SharePoint Create new folder
action is only available for SharePoint
libraries. Returns information about the new Online and SharePoint 2019. Creates a new folder or folder path.
folder after copy. Delete attachment
Stop sharing an item or a file
Move folder Deletes the specified attachment.
Delete all links giving access to an item or a
Moves a folder. Works in a similar way to file and remove all people with direct Delete item
the "Move to" command in SharePoint access except for owners. Deletes an item from a SharePoint list.
libraries. Returns information about the new
Update file properties Generate document using Microsoft Syntex
folder after move.
Updates the properties stored in columns in (preview)
Check out file
a library for the item specified by the item Use this action to create documents based
Check out a file in a document library to id. Use "Update file" action to update file on modern templates from Microsoft
prevent others from editing the document, contents. When using this with the On-Pre‐ Syntex. This preview requires a Syntex
and your changes from being visible until mises Data Gateway, the name of the license. Pricing is subject to change. For
the documented is checked in. library to connect to may need to be entered more info see: https://docs.microsoft.com/‐
Discard check out manually. en-us/microsoft-365/contentunderstandin‐
If you check out a file and don't make Update file properties using AI Builder g/content-assembly.
changes to it, or you make changes that model results Get attachment content
you don't want to keep you can simply Updates the values stored in library Returns file contents using the file identifier.
discard the checkout, rather than saving the columns for a file analyzed by the model The contents can be copied somewhere
file. If your organization tracks versions, a specified by the ModelId. else, or be used as an attachment.
new version is created each time you check
Get file properties Get attachments
a file back into the library. By discarding the
Gets the properties saved in the columns in Returns the list of attachments for the
checkout, you can avoid making new
the library for the item specified by the item specified list item. You can add a "Get
versions when you haven't made any
id. You can add a "Get file content" step attachment content" step and use the "File
changes to the file.
and use the "File identifier" property identifier" property returned by this action to
Check in file
returned by this action to get to the contents get to the contents of the file.
Check in a checked out file in a document of the file. When using this with the On-Pre‐
Get changes for an item or a file (properties
library, which makes the version of the mises Data Gateway, the name of the
only)
document available to others. library to connect to may need to be entered
manually.
Get files (properties only)

SharePoint ♦ (cont) Word Online (Business) ♦ Conditionals (cont)
Returns information about columns that Convert Word Document to PDF Marks the beginning of a block of actions
have changed within a given time window. Gets a PDF version of the selected file that ran if the conditions specified in the
Note: The list must have Versioning turned preceding 'If' statements aren't met, but the
Populate a Microsoft Word template
on. condition specified in this statement is met
Reads a Microsoft Word template to then fill
Update item If
the template fields with selected dynamic
Updates an item in a SharePoint list. values to generate a Word Document. Marks the beginning of a block of actions
Get item that is run if the condition specified in this

Variables - Data table statement is met
Gets a single item by its id from a
SharePoint list. Switch
Create new data table
Get items Dispatches execution to different parts of
Creates a new data table variable
the switch body based on the value of the
Gets items from a SharePoint list. Insert row into data table
expression
Inserts a row at the end or before a specific
Logging ♦
index value Loops
Log Message Find or replace in data table
Exit loop
Adds a custom text message to the flow run Finds and/or replaces data table values
Terminates the loop and the flow resumes
action details
Update data table item at the next action or statement following the
Update a data table row item on a defined loop
OneNote (Business) (Preview) ♦
column For each
Create a page in Quick Notes (Preview)
Delete row from data table Iterates over items in a list, data table or
Create a new page in the Quick Notes
Delete a data table row item data row, allowing a block of actions to be
section.
executed repeatedly
Create page in a section (Preview)
Conditionals Loop
Create new page in a specified section.
Case Iterates a block of actions for a specified
Create section in a notebook (Preview) number of times
An expression that, if met, a block of actions
Create section in a notebook. associated with that particular case runs Loop condition
Delete a page (Preview) Default case Iterates a block of actions as long as a
Delete a page. A block of actions that is run, if no case specified condition proves to be true
Get page content (Preview) expression has been met in the switch body Next loop
Get HTML page content. Else Forces the next iteration of the block to take
Get pages for a specific section (Preview) Marks the beginning of a block of actions place, skipping any actions in between
Get pages for a specific section. that ran if the condition specified in the
preceding 'If' statements aren't met Folder
Get recent notebooks (Preview)
Else if If folder exists
Get recent notebooks.
Mark the beginning of a conditional block of
Get sections in notebook (Preview)
actions depending on whether a folder
Get sections in a specific notebook. exists or not
Update page content (Preview) Get files in folder
Update HTML page content.

Folder (cont) Workstation System
Retrieve the list of files in a folder Print document If process

Get subfolders in folder Prints a document on the default printer Marks the beginning of a conditional block
Retrieve the list of subfolders in a folder Get default printer of actions depending on whether a process
is running or not
Create folder Gets the name of the default printer
Wait for process
Create a new folder Set default printer
Suspends the execution until a process
Delete folder Sets a printer as the default printer
starts or stops
Delete an existing folder and its contents Log off user
Run application
(files and subfolders) Logs off the current user
Executes an application or opens a
Empty folder Shutdown computer
document by executing the associated
Delete all the contents of a folder (files and Instructs the computer to shut down application
subfolders) without deleting the folder itself
Show desktop Terminate process
Copy folder
Shows the desktop Immediately stops a running process
Copy a folder into a destination folder
Lock workstation Ping
Move folder
Locks the workstation's display to protect it Sends a message to determine whether a
Move an existing folder into a destination from unauthorized use remote computer is accessible over the
folder
Play sound network
Rename folder
Plays a system sound or a wav file Set Windows environment variable
Change the name of a folder
Empty recycle bin Sets an environment variable to a given
Get special folder value
Deletes all files from the windows recycle
Retrieve the path of a Windows' special bin Get Windows environment variable
folder (such as Desktop, My Pictures,
Take screenshot Retrieves the value of an environment
Internet Cache etc)
variable
Takes a screenshot of the foreground
window or the specified screen and saves Delete Windows environment variable
Compression
the image in a file or to the clipboard Deletes an environment variable from a
ZIP files
Control screen saver given scope
Compress one or more files or folders into a
Enables, disables, starts or stops the
ZIP archive PDF
screensaver
Unzip files
Get screen resolution Extract text from PDF
Uncompress one or more files or folders
Gets the width, height, bit count and Extract text from a PDF file
contained in a ZIP archive
frequency of a selected monitor Extract tables from PDF
Set screen resolution Extract tables from a PDF file
Sets the width, height, bit count and Extract images from PDF
frequency of a selected monitor during an Extract images from a PDF file
attended desktop flow run.
Extract PDF file pages to new PDF file
Extract pages from a PDF file to a new PDF
file
Merge PDF files

PDF (cont) Text (cont) Text (cont)
Merges multiple PDF files into a new one Change text case Escapes a minimal set of characters (, *, +,
Changes the casing of a text to uppercase, ?, |, {, [, (,), ^, $,., #, and white space) by
OCR lowercase, title case or sentence case replacing them with their escape codes
If text on screen (OCR) Convert text to number Recognize entities in text
Marks the beginning of a conditional block Converts a text representation of a number Recognizes entities in text, such as
of actions depending on whether a given to a variable that contains a numeric value numbers, units, data/time and others
text appears on the screen or not, using expressed in natural language across
Convert number to text
OCR multiple languages
Converts a number to text using a specified
Wait for text on screen (OCR)
format
XML
Wait until a specific text appears/disappears
Convert text to datetime
on the screen, on the foreground window, or Read XML from file
Converts a text representation of a date
relative to an image on the screen or Read the contents of an XML file into a
and/or time value to a datetime value
foreground window using OCR variable
Convert datetime to text
Extract text with OCR Write XML to file
Converts a datetime value to text using a
Extract text from a given source using the Write the contents of an XML node variable
specified custom format
given OCR engine into a file
Create random text
Execute XPath expression
Text Generates a text of specified length
Extract values from an XML document
consisting of random characters. This can
Append line to text based on the provided XPath query
be useful for generating passwords
Appends a new line of text to a text value Get XML element attribute
Join text
Get subtext Get the value of an attribute of an XML
Converts a list into a text value by
Retrieve a subtext from a text value element
separating its items with a specified
Crop text Set XML element attribute
delimiter
Retrieves a text value that occurs before, Set the value of an attribute of an XML
Split text
after or between the specified text flag(s) in element
Creates a list containing the substrings of a
a given text Remove XML element attribute
text that are separated by a specified
Pad text delimiter or a regular expression Remove an attribute from an XML element
Creates a fixed length text by adding Parse text Get XML element value
characters to the left or to the right of an
Parses a text to find the first or all occurr‐ Get the value of an XML element
existing text
ences of a specified subtext or a regular Set XML element value
Trim text expression pattern
Set the value of an XML element
Removes all occurrences of white space Replace text
Insert XML element
characters (such as space, tab, or new line)
Replaces all occurrences of a specified
from the beginning and/or end of an existing Insert a new XML element into an XML
subtext with another text. It can also be
text document
used with regular expressions
Reverse text Remove XML element
Escape text for regular expression
Reverses the order of letters in a text string Remove one or more XML elements from
an XML document

Database Windows services (cont) Active Directory
Open SQL connection Pause service Connect to server

Open a new connection to a database Pause a running Windows service Connects to an Active Directory server
Execute SQL statement Resume service Close connection
Connect to a database and execute a SQL Resume a paused Windows service Closes the connection with the Active
statement Directory server
Close SQL connection Azure - Virtual machines - Snapshots
Active Directory - Group
Close an open connection to a database Get snapshots
Gets the snapshots based on the specified Create group
CMD session criteria Creates a group in the Active Directory
Open CMD session Create snapshot Get group info
Open a new CMD session Creates a snapshot from the specified disk Gets information about a group from the
Read from CMD session Delete snapshot Active Directory server
Read the output of a CMD session Deletes the snapshot with the specified Get group members
Write to CMD session name and resource group Gets the members of a group in the Active
Directory
Execute a command on an open CMD
Azure - Virtual machines - Disks Modify group
session
Get disks Modifies a group in the Active Directory
Wait for text on CMD session
Gets the disks based on the specified
Wait for a specific text on a previously
criteria Active Directory - Object
opened CMD session
Attach disk Create object
Close CMD session
Attaches an existing disk to the virtual Creates an object in the Active Directory
Close a previously opened CMD session
machine with the specified name and Delete object
resource group
Windows services Deletes an object in the Active Directory
Detach disk
If service Move object
Detaches the disk from the virtual machine
Marks the beginning of a conditional block Moves an object in the Active Directory
with the specified name and resource group
of actions depending on whether a service Rename object
is running, paused, stopped or installed on Create managed disk
Renames an object in the Active Directory
the computer Creates a managed disk with the specified
Wait for service settings
Suspend the execution of the automation Delete disk

until a service is running, paused or stopped Deletes the managed disk with the specified
on the computer name and resource group
Start service
Start a stopped Windows service
Stop service
Stop a running Windows service

Microsoft cognitive - Bing spell check AI Builder ♦ Office 365 Outlook (Preview) ♦ (cont)
Spell check Create text with GPT Get calendars (V2)

Invokes the Microsoft Cognitive service Get a response generated by GPT. This operation lists available calendars.
named 'Bing Spell Check' Get contact (V2)
Office 365 Outlook (Preview) ♦
This operation gets a specific contact from
Microsoft cognitive - Computer vision
Create contact (V2) a contacts folder.
Analyze image This operation creates a new contact in a Get contacts (V2)
Invokes the Microsoft Cognitive service contacts folder.
This operation gets contacts from a
named 'Analyze Image' Create event (V4) contacts folder.
Describe image This operation creates a new event in a Get email (V2)
Invokes the Microsoft Cognitive service calendar.
This operation gets an email by id.
named 'Describe Image' Delete contact (V2)
Get emails (V3)
OCR This operation deletes a contact from a
This operation gets emails from a folder via
Invokes the Microsoft Cognitive service contacts folder.
graph apis. Please note that filtering related
named 'OCR' Delete email (V2) to these fields: To, Cc, To Or Cc, From,
Tag image This operation deletes an email by id. Importance, Fetch Only With Attachments,
Invokes the Microsoft Cognitive service Subject Filter, is performed using first 250
Delete event (V2)
named 'Tag Image' items in a given mail folder. To avoid that
This operation deletes an event in a
limitation you can use 'Search Query' field.
calendar.
Microsoft cognitive - Text Analytics Get event (V3)
Export email (V2)
Detect language This operation gets a specific event from a
Export the content of the email in the EML
Invokes the Microsoft Cognitive service calendar using Graph API. (V3)
file format.
named 'Text Analytics - Detect Language' Get events (V4)
Find meeting times (V2)
Key phrases This operation gets events from a calendar
Find meeting time suggestions based on
Invokes the Microsoft Cognitive service using Graph API. (V4)
organizer, attendee availability, and time or
named 'Text Analytics - Key Phrases' Get room lists (V2)
location constraints
Sentiment Get all the room lists defined in the user's
Flag email (V2)
Invokes the Microsoft Cognitive service tenant
This operation updates an email flag.
named 'Text Analytics - Sentiment' Get rooms (V2)
Forward an email (V2)
Get all the meeting rooms defined in the
Clipboard Forward an email.
user's tenant
Get Attachment (V2)
Get clipboard text Get rooms in room list (V2)
This operation gets an email attachment by
Gets clipboard text. Get the meeting rooms in a specific room
id.
Set clipboard Text list
Get calendar view of events (V3)
Sets clipboard text. Mark as read or unread (V3)
This operation gets all events (including
Clear clipboard contents This operation marks an email as read/u‐
instances of recurrences) in a calendar
nread.
Clears clipboard contents. using Graph API. Recurrence property is
null in this case.

Office 365 Outlook (Preview) ♦ (cont) Microsoft Teams ♦ (cont) Microsoft Teams ♦ (cont)
Move email (V2) This operation is used to create a new This operation retrieves a list of tags.
This operation moves an email to the channel for a specific Team. List channels
specified folder within the same mailbox. Create a chat This operation retrieves a list of all the
Reply to email (V3) This operation creates a one on one or channels for a specific Team.
This operation replies to an email. group chat List chats
Respond to an event invite (V2) Create a tag for a team This operation retrieves a list of recent
Respond to an event invite. This operation creates a tag. chats.
Send an email (V2) Create a team List members
This operation sends an email message. This operation a creates a new team. This operation list members based on a
Create a Teams meeting threadtype (chat, channel, etc).
Send an email from a shared mailbox (V2)
Create a meeting with a link at the bottom List teams
This operation sends an email from a
shared mailbox. Your account should have of the invite to join the meeting online on This operation retrieves a list of all the
permission to access the mailbox for this Teams Teams (Office 365 Groups) you are a
operation to succeed. Delete a member from a tag member of.
Set up automatic replies (V2) This operation deletes a member from a List the members for a tag
Set the automatic replies setting for your tag. This operation lists the members for a tag.
mailbox. Delete a tag Post a feed notification
Update contact (V2) This operation deletes a tag. This operation posts a feed notification.
This operation updates a contact in a Get a team Post card in a chat or channel
contacts folder. This operation returns details for a team This operation posts a card to a chat or a
Update event (V4) using the team's unique ID. channel.
This operation updates an event in a Get an @mention token for a tag Post message in a chat or channel
calendar using Graph API. This operation creates a token that can be This operation posts a message to a chat or
inserted into a message or adaptive card a channel.
Microsoft Forms ♦ sent as a user in a channel to @mention a Reply with a message in a channel
Get response details tag.
This operation replies with a message in a
This action retrieves a form response Get an @mention token for a user channel.
This operation creates a token that can be Reply with adaptive card in a channel
Microsoft Teams ♦ inserted into a message or adaptive card to
This operation replies with an adaptive card
Add a member to a tag @mention a user.
to a channel.
This operation adds a user to a tags. Get message details
Update an adaptive card in a chat or
Add a member to a team This operation gets details of a message in channel
a chat or a channel.
This operation adds a member to a team. This operation updates an existing adaptive
Get messages card.
Create a channel
This operation is used to get messages
from a channel in a specific Team.
List all tags for a team

RSS ♦ Run flow (cont) File (cont)
List all RSS feed items Runs a desktop flow which can receive Create a uniquely named, empty temporary
This operation retrieves all items from an input variables and may produce output file on disk, and get the file object (which is
RSS feed. variables. The parent flow run will be a representation, and can access the file
paused until the called desktop flow and all its information)
Flow control completes. Convert file to Base64
Comment Convert a file to Base64 encoded text

File
User comment Convert Base64 to file
If file exists
End Convert a Base64 encoded text to file
Marks the beginning of a conditional block
Set rules and manage the course of the flow Convert file to binary data
of actions depending on whether a file
Exit subflow exists or not Convert a file to binary data.
Exits current subflow and returns to the Wait for file Convert binary data to file
point it was called from Convert binary data to file.
Suspend the execution of the automation
Get last error until a file is created or deleted
Email
Retrieves the last error that occurred in the Copy file(s)
flow Retrieve email messages
Copy one or more files into a destination
Go to folder Retrieves email messages from an IMAP
Transfers the flow of execution to another server
Move file(s)
point, indicated by a label Process email messages
Move one or more files into a destination
Label folder Moves, deletes or marks as unread an
Acts as the destination of a 'go to' statement email (or a list of emails) retrieved by a
Delete file(s)
Retrieve emails action
On block error Delete one or more files
Send email
Marks the beginning of a block to handle Rename file(s)
actions errors Creates and sends a new email message
Change the name of one or more files
Run subflow
Read text from file Exchange
Run a subflow specifying any required
Read the contents of a text file
Connect to Exchange server
arguments
Write text to file
Open a new connection to an Exchange
Stop flow
Write or appends text to a file server
Terminates the flow
Read from CSV file Retrieve Exchange email messages
Wait
Read a CSV file into a data table Retrieve email messages from the specified
Suspends the execution of the flow for a
Write to CSV file Exchange server
specified amount of seconds
Write a data table, data row or list to a CSV Send Exchange email message
Run flow file Create and send a new email message

Get file path part Process Exchange email messages
Run desktop flow
Retrieve one or more parts (directory,
filename, extension etc) from a text that
represents a file path
Get temporary file

Exchange (cont) Excel - Advanced (cont) Excel - Advanced (cont)
Move, delete or mark as unread an email Retrieves all worksheet names of an Excel Deletes a selected column from an Excel
message (or a list of email messages) document instance
Delete Excel worksheet Find and replace cells in Excel worksheet
Outlook
Deletes a specific worksheet from an Excel Finds text and replaces it with another in
Launch Outlook instance the active worksheet of an Excel instance
Launch Outlook and create a new Outlook Rename Excel worksheet Get first free row on column from Excel
instance worksheet
Renames a specific worksheet of an Excel
Retrieve email messages from Outlook instance Retrieve the first free row, given the column
Retrieve email messages from an Outlook Activate Cell in Excel Worksheet of the active worksheet
account
Activate a cell in the active worksheet of an
Excel
Send email through Outlook Excel instance, by providing column, row
Create and send a new email message and offset Launch Excel
through Outlook Select cells in Excel worksheet Launches a new Excel instance or opens
Process email messages in Outlook an Excel document
Selects a range of cells in the active
Move or deletes an email (or a list of email worksheet of an Excel instance Attach to running Excel
messages) retrieved by a 'Retrieve emails Get selected cell range from Excel Attaches to an Excel document that's
from Outlook' action. worksheet already open
Save Outlook email messages Retrieve the selected range of cells in a Read from Excel worksheet
Save Outlook email messages given an structure consisting of first column, first Reads the value of a cell or a range of cells
account row, last column and last row from the active worksheet of an Excel
Respond to Outlook mail message Copy cells from Excel worksheet instance
Respond to an Outlook message, by Copies a range of cells from the active Get active cell on Excel worksheet
replying, replying to all or forwarding it worksheet of an Excel instance Get the active cell in the active worksheet
Close Outlook Paste cells to Excel worksheet of the Excel document
Close a previously launched Outlook Pastes a range of cells to the active Save Excel
instance worksheet of an Excel instance Saves a previously launched Excel
Delete from Excel worksheet instance
Excel - Advanced Write to Excel worksheet
Deletes a cell or a range of cells from the
Resize columns/rows in Excel worksheet active worksheet of an Excel instance Writes a value into a cell or a range of cells
Resizes a selection of columns or rows in Insert row to Excel worksheet of an Excel instance
the active worksheet of an Excel instance Inserts a row above a selected row of an Close Excel
Run Excel Macro Excel instance Closes an Excel instance
Runs a specified macro on the document of Delete row from Excel worksheet Set active Excel worksheet
an Excel instance Deletes a selected row from an Excel Activates a specific worksheet of an Excel
Get active Excel worksheet instance instance
Retrieves an Excel document's active Insert column to Excel worksheet Add new worksheet
worksheet Inserts a column to the left of a selected Adds a new worksheet to the document of
Get all Excel worksheets column of an Excel instance an Excel instance
Delete column from Excel worksheet Get first free column/row from Excel
worksheet

Excel (cont) Datetime (cont) FTP (cont)
Retrieves the first free column and/or row of Get current date and time This action closes an open FTP connection
the active worksheet. This is useful for Retrieves the current date or the current Change working directory
adding new data into a worksheet that date and time This action sets the current working
already has data in it
directory for an FTP connection
Get column name on Excel worksheet Scripting
Download file(s) from FTP
Gets the name of the column Run DOS command
Downloads one or more files from an FTP
Executes a DOS command or console server
Message boxes
application in invisible mode and retrieves
Download folder(s) from FTP
Display message its output upon completion
Downloads one or more folders from an
Displays a message box Run VBScript
FTP server
Display input dialog Executes some custom VBScript code and
Upload File(s) to FTP
Displays a dialog box that prompts the user retrieves its output into a variable
Uploads one or more files to an FTP server
to enter text Run JavaScript
Upload folder(s) to FTP
Display select date dialog Executes some custom JavaScript code
Uploads one or more folders to an FTP
Displays a dialog box that prompts the user and retrieves its output into a variable
server
to enter a date or date range Run PowerShell script
Delete FTP file
Display select from list dialog Executes some custom PowerShell script
Deletes one or more files from an FTP
Displays a dialog box with options that lets and retrieves its output into a variable
server
the user select from a list Run Python script
Rename FTP File
Display select file dialog Executes Python 2 script code and retrieves
Renames a file that resides on an FTP
Displays the select file dialog and prompts its output
server
the user to select one or more files Run .NET script
Create FTP directory
Display select folder dialog Executes a user provided .NET script and
Creates a directory on an FTP server
Displays the select folder dialog and stores its output in variables.
Delete FTP directory
prompts the user to select a folder
FTP Deletes a directory from an FTP server
Display custom form
Open FTP connection Invoke FTP command
Display a customized form that can include
multiple types of elements, like text, number This action establishes a specific Invokes the given literal FTP command on
or file inputs etc. connection to a remote FTP server, and the server
stores that connection as a variable for later Synchronize directories
Datetime use.
Synchronize the files and subdirectories of
Add to datetime List FTP directory a given Folder with a given remote FTP
This action returns the subdirectories and directory
Adds (or subtracts) a specific number of
seconds, minutes, hours or days to a files contained in the current directory of an
datetime value FTP connection
Subtract dates Open secure FTP connection
Finds the time difference between two given This action establishes a specific secure
dates in days, hours, minutes, or seconds connection to a remote FTP server, and
stores that connection as a variable for later
use
Close connection

AWS - EC2 AWS - EC2 - Volumes (cont) IBM cognitive - Document conversion
Create EC2 session Describe the specified EBS volumes Convert document
Create an EC2 client to automate EC2 web Delete volume Invokes the IBM service named 'Convert
services Delete the specified EBS volume Document'
End EC2 session
Active Directory - User IBM cognitive - Visual recognition
Dispose an open EC2 client
Create user Classify Image
AWS - EC2 - Instances Invokes the IBM service named 'Classify
Creates a user in the Active Directory
Start EC2 instance Image'
Get user info
Start EC2 instance(s) Gets a user's information in the Active
IBM cognitive - Language translator
Stop EC2 instance Directory
Translate
Stop EC2 instance(s) Modify user
Invokes the IBM service named 'Translate'
Reboot EC2 instance Modify a user in the Active Directory
Identify language
Reboot EC2 instance(s) Unlock user
Invokes the IBM service named 'Identify
Get available EC2 instances Unlocks an Active Directory user
Language'
Get information for the relevant EC2 Update user info
instances Updates a user's information in the Active IBM cognitive - Tone analyzer
Describe instances Directory
Analyze tone
Returns all the information for the specified
Invokes the IBM service named 'Analyze
EC2 instance(s) Terminal emulation
Tone'
Open terminal session
AWS - EC2 - Snapshots
Open a new terminal session Work queues (Preview) ♦
Create snapshot Close terminal session Process work queue items (preview)
Create a snapshot of an EBS volume and Close an open terminal session Indicates to the orchestrator that the
stores it in Amazon S3
Move cursor on terminal session machine is ready to process one or more
Describe snapshots work queue items, if available
Move the terminal's cursor on the specified
Describes the specified EBS snapshots position Update work queue item (preview)
available
Get text from terminal session Updates the status and processing result of
Delete snapshot a specific work queue item
Get text from a terminal session
Delete the specified snapshot Add work queue item (preview)
Set text on terminal session
Add a work queue item into a work queue
Set text on a terminal session
AWS - EC2 - Volumes
Requeue item and add delay (preview)
Send key to terminal session
Create volume
Requeue a work queue item and delay it
Send a control key to a terminal session
Create an EBS volume until a specified date and time
Wait for text on terminal session
Attach volume
Wait for a specific text to appear on a
Attach an EBS volume to an EC2 instance
terminal session
Detach volume
Detach an EBS volume from an EC2
instance
Describe volumes

OneDrive for Business ♦ OneDrive for Business ♦ (cont) Excel Online (Business) ♦ (cont)
Copy file This operation gets the metadata of a file Get a row
This operation copies a file within OneDrive. using the path. Get a row using a key column.
Copy file using path Get file thumbnail Get tables
This operation copies a file within OneDrive This operation gets the thumbnail of a file. Get a list of tables in the Excel workbook.
by path. The thumbnail will only be valid for 6 hours.
Get worksheets
Create file List files in folder
Get a list of worksheets in the Excel
This operation creates a file. This operation gets the list of files and workbook.
subfolders in a folder.
Create share link List rows present in a table
List files in root folder
This operation creates a share link for a file. List rows present in a table.
This operation gets the list of files and
Create share link by path Run script
subfolders in the root folder.
This operation creates a share link for a file Runs an Office Script against an Excel
Move or rename a file
using the path. workbook. Use this action when the script is
This operation moves or renames a file. saved in the default location.
Delete file
Move or rename a file using path Run script from SharePoint library
This operation deletes a file.
This operation moves or renames a file Runs an Office Script against an Excel
Extract archive to folder
using the path. workbook. Use this action when the script is
This operation extracts an archive file into a
Update file saved outside of the default location.
folder (example: .zip). Maximum archive
size is 50 MB and 100 files inside. This operation updates a file. Update a row
Find files in folder Upload file from URL Update a row using a key column. The input
This operation uploads a file from a URL to value will overwrite the specified cells and
This operation finds files within a folder
OneDrive. columns left blank will not be updated. In
using search or name pattern match.
order to append (instead of overwrite) a
Find files in folder by path
Excel Online (Business) ♦ value, use the "Get a row" action to retrieve
This operation finds files within a folder by the content first.
Add a key column to a table
path using search or name pattern match.
Add a key column to an Excel table. The OneDrive ♦
Get file content
new column will be appended to the right.
This operation gets the content of a file. Convert file
Add a row into a table
Get file content using path This operation converts a file to another
Add a new row into the Excel table.
This operation gets the content of a file format. The list of supported conversions
Create table can be found at https://aka.ms/onedrivec‐
using the path.
Create a new table in the Excel workbook. onversions
Get file metadata
Create worksheet Convert file using path
This operation gets the metadata for a file.
Create a new worksheet in the Excel This operation converts a file to another
Get file metadata using path
workbook. format using the path. The list of supported
conversions can be found at https://aka.m‐
Delete a row
s/onedriveconversions
Delete a row using a key column.
Copy file
This operation copies a file within
OneDrive.

OneDrive ♦ (cont) OneDrive ♦ (cont)
Copy file using path This operation gets the thumbnail of a file.
This operation copies a file within OneDrive The thumbnail will only be valid for 6 hours.
by path. List files in folder
Create file This operation gets the list of files and
This operation creates a file. subfolders in a folder.
Create share link List files in root folder
This operation creates a share link for a file. This operation gets the list of files and
subfolders in the root folder.
Create share link by path
Move or rename a file
This operation creates a share link for a file
using the path. This operation moves or renames a file.
Delete file Move or rename a file using path
This operation deletes a file. This operation moves or renames a file

using the path.
Extract archive to folder
Update file
This operation extracts an archive file into a
folder (example: .zip). Maximum archive This operation updates a file.
size is 50 MB and 100 files inside. Upload file from URL
Find files in folder This operation uploads a file from a URL to
This operation finds files within a folder OneDrive.
using search or name pattern match.
Find files in folder by path
This operation finds files within a folder by
path using search or name pattern match.
Get file content
This operation gets the content of a file.
Get file content using path
This operation gets the content of a file
using the path.
Get file metadata
This operation gets the metadata for a file.
Get file metadata using path
This operation gets the metadata of a file
using the path.
Get file thumbnail


Ui Path

Uploaded by

Copyright:

Available Formats

Ui Path

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Ui Path

Uploaded by

Copyright:

Available Formats

Power Automate Desktop Actions Cheat Sheet

by RPAWorld (VJR) via cheatography.com/153513/cs/33003/

Variables Variables (cont) UI automation (cont)

Truncate number Convert JSON to custom object Wait for image

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Blocks user mouse and keyboard input, so Restart virtual machine

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Crypto​graphy Google cognitive - Natural language (cont) SharePoint ♦ (cont)

Delete file Extract folder

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

SharePoint ♦ (cont) SharePoint ♦ (cont) SharePoint ♦ (cont)

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

SharePoint ♦ (cont) Word Online (Business) ♦ Condit​ionals (cont)

Get item that is run if the condition specified in this

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Folder (cont) Workst​ation System

Retrieve the list of files in a folder Print document If process

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

PDF (cont) Text (cont) Text (cont)

If text on screen (OCR) Convert text to number Recognize entities in text

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Database Windows services (cont) Active Directory

Open SQL connection Pause service Connect to server

Suspend the execution of the automation Delete disk

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Spell check Create text with GPT Get calendars (V2)

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Send an email (V2) Create a team List members

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

RSS ♦ Run flow (cont) File (cont)

Comment Convert a file to Base64 encoded text

Run flow file Create and send a new email message

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Exchange (cont) Excel - Advanced (cont) Excel - Advanced (cont)

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

Excel (cont) Datetime (cont) FTP (cont)

Subtract dates Open secure FTP connection

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

OneDrive ♦ (cont) OneDrive ♦ (cont)

Create share link List files in root folder

Delete file Move or rename a file using path

This operation deletes a file. This operation moves or renames a file

By RPAWorld (VJR) Published 9th July, 2022. Sponsored by CrosswordCheats.com

You might also like

Cryptography Google cognitive - Natural language (cont) SharePoint ♦ (cont)

SharePoint ♦ (cont) Word Online (Business) ♦ Conditionals (cont)

Folder (cont) Workstation System