Show Menu
Cheatography

Power Automate Desktop Actions Cheat Sheet by

A one-stop source for all the list of available actions in Power Automate Desktop. ~Version 2.50

Variables

Truncate number
Get the integral or fractional digits of a numeric value, or round up the value to a specified number of decimal places
Generate random number
Generate a random number or a list of random numbers that fall between a minimum and maximum value
Clear list
Remove all items from a list
Remove item from list
Remove one or multiple items from a list
Sort list
Sort the items of a list. Use items of the same type
Shuffle list
Create a random permut­ation of a list
Merge lists
Merge two lists into one
Reverse list
Reverse the order of the items of a list
Remove duplicate items from list
Remove the multiple occurr­ences of items in a list, so that in the resulting list each item will be unique
Find common list items
Compare two lists and create a new list with the items that are common to both
Subtract lists
Compare two lists and create a new list with the items that are in the first list but not in the second
Retrieve data table column into list
Convert the contents of a data table column into a list
Convert JSON to custom object
Convert a JSON string to a custom object
Convert custom object to JSON
Convert a custom object to a JSON string
Add item to list
Αppend a new item to a list
Create new list
Create a new empty list
Increase variable
Increase the value of a variable by a specific amount
Decrease variable
Decrease the value of a variable by a specific amount
Set variable
Set the value of a new or existing variable, create a new variable or overwrite a previously created variable

UI automation

If window contains
Marks the beginning of a condit­ional block of actions depending on whether a specific piece of text or UI element exists in a window
Wait for window content
Suspends the execution of the automation until a specific piece of text or UI element appears or disappears from a Window
If image
This action marks the beginning of a condit­ional block of actions depending on whether a selected image is found on the screen or not
Use desktop
Performs desktop and taskbar related operations
Select tab in window
Selects a tab from a group of tabs
Wait for image
This action waits until a specific image appears on the screen or on the foreground window
Hover mouse over UI element in window
Hover the mouse over any UI element on window
Click UI element in window
Clicks on any UI element of a window
Select menu option in window
Selects an option in a menu of a window
Drag and drop UI element in window
Drags and drops a UI element of a window
Expand­/co­llapse tree node in window
Expands or collapses a node of a tree view residing in a window
If window
This action marks the beginning of a condit­ional block of actions depending on whether a window is open or not or whether a window is the focused (foreg­round) window
Wait for window
Suspends the execution or the process until a specific window opens, closes, get or loses the focus

UI automation - Data Extraction

Get details of window
Gets a property of a window such as its title or its source text
Get details of a UI element in window
Gets the value of a UI element's attribute in a window
Get selected checkboxes in window
Retrieves the names of the selected checkboxes in a checkbox group or the state of a specific checkbox
Get selected radio button in window
Retrieves the names of the selected radio button in a radio button group or the state of a specific radio button
Extract data from window
Extracts data from specific parts of a window in the form of single values, lists, or tables
Take screenshot of UI element
Takes a screenshot of a UI element in window
Extract data from table
Extracts data from a table in the form of a datatable

UI automation - Form filling

Focus text field in window
Sets the focus on a text box of a window and scrolls it into view
Populate text field in window
Fills a text box in a window with the specified text
Press button in window
Presses a window button
Select radio button in window
Selects a radio button on a window
Set checkbox state in window
Checks or unchecks a checkbox in a window form
Set drop-down list value in window
Sets or clears the selected option(s) for a drop-down list in a window form

UI automation - Windows

Get window
Gets a running window, for automating desktop applic­ations
Focus window
Activates and brings to the foreground a specific window
Set window state
Restores, maximizes or minimizes a specific window
Set window visibility
Shows a hidden window or hides a visible window
Move window
Sets the position of a specific window
Resize window
Sets the size of a specific window
Close window
Closes a specific window

Browser automation

If web page contains
Mark the beginning of a condit­ional block of actions, depending on whether a specific piece of text or element exists in a web page
Wait for web page content
Suspend the flow until a specific piece of text or web page element appears or disappears from a web page
Launch new Internet Explorer
Launch a new instance or attach to a running instance of Internet Explorer for automating web sites and web applic­ations
Launch new Firefox
Launch a new instance or attach to a running instance of Firefox for automating web sites and web applic­ations
Launch new Chrome
Launch a new instance or attach to a running instance of Chrome for automating web sites and web applic­ations
Launch new Edge
Launch a new instance or attach to a running instance of Edge for automating web sites and web applic­ations
Create new tab
Create a new tab and navigate to the given URL (supported in Edge, Chrome and Firefox)
Go to web page
Navigate the web browser to a new page
Click link on web page
Click on a link or any other element of a web page
Click download link on web page
Click on a link in a web page that results in downlo­ading a file
Run JavaScript function on web page
Run a JavaScript function on the web page and get the returned result
Hover mouse over element on web page
Hover the mouse over an element of a web page
Close web browser
Close a web browser window

Browser automation - Web form filling

Focus text field on web page
Set the focus on an input element of a web page and scroll it into view
Populate text Field on web page
Fill a text field in a web page with the specified text
Set check box state on web page
Check or uncheck a check box in a web form
Select radio button on web page
Select a radio button on the web page
Set drop-down list value on web page
Set or clear the selected option for a drop-down list in a web form
Press button on web page
Press a web page button

Browser automation - Web data extraction

Extract data from web page
Extract data from specific parts of a web page in the form of single values, lists, rows or tables
Get details of web page
Get a property of a web page, such as its title or its source text
Get details of element on web page
Get the value of an element's attribute on a web page
Take screenshot of web page
Take a screenshot of the web page (or an element of the web page) currently displayed in the browser and save the image into a file or to the clipboard

HTTP

Download from web
Downloads text or a file from the web and stores it
Invoke SOAP web service
Invokes a method from a SOAP web service
Invoke web service
Invokes a web service by sending data and retrieves the response from the web service

Mouse and keyboard

Block Input
Blocks user mouse and keyboard input, so that the flow can perform mouse and keyboard actions without interf­erence from the user
Get mouse position
Retrieves the current position of the mouse cursor on the screen in pixel coordi­nates
Move mouse
Moves the mouse to a specific position
Move mouse to image
Moves the mouse over an image found on screen or on the foreground window
Move mouse to text on screen (OCR)
Moves the mouse over a text found on the screen or on the foreground window using OCR
Send mouse click
Sends a mouse click event
Send keys
Sends keys to the applic­ation that is currently active
Press/­release key
Presses (and holds) or releases one or more modifier keys (Alt, Control, or Shift)
Set key state
Sets the state (on or off) for the keys Caps Lock, Num Lock or Scroll Lock
Wait for mouse
Suspends the execution of the flow until the mouse pointer changes, usually to or from the 'wait cursor' or hourglass
Get keyboard identifier
Retrieves the active keyboard identifier from the machine's registry
Wait for shortcut key
Pause the flow run until a specific shortcut key is pressed. Shortcut keys must contain at least one key or a key and one of (ctrl, alt, shift). Multiple shortcut keys can be defined

Azure

Create session
Creates an Azure session
Get subscr­iptions
Gets subscr­iptions that the current account can access
End session
Ends an Azure session

Azure - Resource groups

Get resource groups
Gets the resource groups based on the specified criteria
Create resource group
Creates a new resource group
Delete resource group
Deletes the specified resource group and all the contained resources

Azure - Virtual machines

Get virtual machines
Gets the basic inform­ation for the virtual machines
Describe virtual machine
Gets all the inform­ation for the virtual machine(s) based on the specified criteria
Start virtual machine
Starts the virtual machine
Stop virtual machine
Stops the virtual machine and deallo­cates the related hardware (CPU and memory) and network resources
Shut down virtual machine
Shuts down the operating system of a virtual machine
Restart virtual machine
Restarts a virtual machine

Crypto­graphy

Encrypt text with AES
Encrypt a string with AES, using a key and a specified encoding format
Decrypt text with AES
Decrypt a string with AES based on a specified key and an encoding format
Encrypt from file with AES
Encrypt the contents of a file with AES, using a key and a specified encoding format
Decrypt to file with AES
Decrypt a string to a file with AES based on a specified key and an encoding format
Hash text
Hash a string, using a specified algorithm and an encoding format
Hash from file
Hash the contents of a file, using a specified algorithm and an encoding format
Hash text with key
Hash a string with a key, using a specified algorithm and an encoding format
Hash from file with key
Hash the contents of a file with a key, using a specified algorithm and an encoding format

CyberArk

Get password from CyberArk
Retrieves a password for a specific applic­ation from CyberArk

Google cognitive - Natural language

Analyze sentiment
Invokes the Google Cloud Natural Language service named 'Analyze Sentiment'
Analyze entities
Invokes the Google Cloud Natural Language service named 'Analyze Entities'
Analyze syntax
Invokes the Google Cloud Natural Language service named 'Analyze Syntax'

Google cognitive - Vision

Label detection
Invokes the Google Cloud Vision service named 'Label Detection'
Landmark detection
Invokes the Google Cloud Vision service named 'Landmark Detection'
Text Detection
Invokes the Google Cloud Vision service named 'Text Detection'
Logo detection
Invokes the Google Cloud Vision service named 'Logo Detection'
Image properties detection
Invokes the Google Cloud Vision service named 'Image Properties Detection'
Safe search detection
Invokes the Google Cloud Vision service named 'Safe Search Detection'

SharePoint ♦

Update file
Updates the contents of the file specified by the file identi­fier.
Delete file
Deletes the file specified by the file identi­fier.
Get file content using path
Gets file contents using the file path.
Get file content
Get file contents using the file identi­fier. The contents can be copied somewhere else, or be used as an attach­ment.
Create file
Uploads a file to a SharePoint site. Make sure to pick an existing library.
List folder
Returns files contained in a SharePoint folder.
Get all lists and libraries
Get all lists and libraries.
Get file metadata
Gets inform­ation about the file such as size, etag, created date, etc. Uses a file identifier to pick the file. Use Get file properties action to get to the values stored in the columns in the library.
Get file metadata using path
Gets inform­ation about the file such as size, etag, created date, etc. Uses a file path to pick the file. Use "Get file proper­tie­s" action to get to the values stored in the columns in the library.
Get folder metadata
Gets inform­ation about the folder. Uses a file identifier to pick the folder.
Get folder metadata using path
Gets inform­ation about the folder. Uses a folder path to pick the folder.
List root folder
Returns files in the root SharePoint folder.
Extract folder
Extracts an archive file into a SharePoint folder (example: zip).
Get lists
Gets SharePoint lists from a site.
Create sharing link for a file or folder
Create sharing link for a file or folder.
Copy file
Copies a file. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns inform­ation about the new file after copy.
Move file
Moves a file. Works in a similar way to the "Move to" command in SharePoint libraries. Returns inform­ation about the new file after move.
Copy folder
Copies a folder. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns inform­ation about the new folder after copy.
Move folder
Moves a folder. Works in a similar way to the "Move to" command in SharePoint libraries. Returns inform­ation about the new folder after move.
Check out file
Check out a file in a document library to prevent others from editing the document, and your changes from being visible until the documented is checked in.
Discard check out
If you check out a file and don't make changes to it, or you make changes that you don't want to keep you can simply discard the checkout, rather than saving the file. If your organi­zation tracks versions, a new version is created each time you check a file back into the library. By discarding the checkout, you can avoid making new versions when you haven't made any changes to the file.
Check in file
Check in a checked out file in a document library, which makes the version of the document available to others.
Get list views
Gets views from a SharePoint list.
Add attachment
Adds a new attachment to the specified list item
Set content approval status
Sets the content approval status for an item in a list or library that has content approval turned on. You must provide an ETag for pages and files. You can get the ETag using the Get File Metadata action. This action is only available for SharePoint Online and SharePoint 2019.
Stop sharing an item or a file
Delete all links giving access to an item or a file and remove all people with direct access except for owners.
Update file properties
Updates the properties stored in columns in a library for the item specified by the item id. Use "­Update file" action to update file contents. When using this with the On-Pre­mises Data Gateway, the name of the library to connect to may need to be entered manually.
Update file properties using AI Builder model results
Updates the values stored in library columns for a file analyzed by the model specified by the ModelId.
Get file properties
Gets the properties saved in the columns in the library for the item specified by the item id. You can add a "Get file conten­t" step and use the "File identi­fie­r" property returned by this action to get to the contents of the file. When using this with the On-Pre­mises Data Gateway, the name of the library to connect to may need to be entered manually.
Get files (prope­rties only)
Gets the properties saved in the columns in the library for all folders and files stored in the library. You can also filter down to the items that match a condition. An "­Apply to each" section is usually used to work with the output from this action. When using this with the On-Pre­mises Data Gateway, the name of the library to connect to may need to be entered manually.
Create item
Creates a new item in a SharePoint list.
Create new folder
Creates a new folder or folder path.
Delete attachment
Deletes the specified attach­ment.
Delete item
Deletes an item from a SharePoint list.
Generate document using Microsoft Syntex
Use this action to create documents based on modern templates from Microsoft Syntex. This requires a Syntex license. Pricing is subject to change. For more info see: https:­//d­ocs.mi­cro­sof­t.c­om/­en-­us/­mic­ros­oft­-36­5/c­ont­ent­und­ers­tan­din­g/c­ont­ent­-as­sembly.
Get attachment content
Returns file contents using the file identi­fier. The contents can be copied somewhere else, or be used as an attach­ment.
Get attach­ments
Returns the list of attach­ments for the specified list item. You can add a "Get attachment conten­t" step and use the "File identi­fie­r" property returned by this action to get to the contents of the file.
Get changes for an item or a file (prope­rties only)
Returns inform­ation about columns that have changed within a given time window. Note: The list must have Versioning turned on.
Update item
Updates an item in a SharePoint list.
Get item
Gets a single item by its id from a SharePoint list.
Get items
Gets items from a SharePoint list.
Create new document set
Creates a new document list item
Grant access to an item or a folder
Grant access to an item or a folder in SharePoint to specific people
Send an HTTP request to SharePoint
Construct a SharePoint REST API to invoke. Note - This action may execute any SharePoint REST API you have access to. Please proceed with caution.

Logging ♦

Log Message
Adds a custom text message to the flow run action details

OneNote (Business) ♦

Create a page in Quick Notes
Create a new page in the Quick Notes section.
Create page in a section
Create new page in a specified section.
Create section in a notebook
Create section in a notebook.
Delete a page
Delete a page.
Get page content
Get HTML page content.
Get pages for a specific section
Get pages for a specific section.
Get recent notebooks
Get recent notebooks.
Get sections in notebook
Get sections in a specific notebook.
Update page content
Update HTML page content.

Word Online (Business) ♦

Convert Word Document to PDF
Gets a PDF version of the selected file
Populate a Microsoft Word template
Reads a Microsoft Word template to then fill the template fields with selected dynamic values to generate a Word Document.

Word

Launch Word
Opens a new Word instance or opens a Word document
Attach to running Word
Attaches to a Word document that's already open
Save Word
Saves a previously launched Word instance
Close Word
Closes a Word instance
Read from Word document
Reads the text content from a document of a Word instance
Write to Word document
Write or append text to a Word file
Insert image in Word document
Insert an image to a Word file
Find and replace words in Word document
Finds text and replaces it with another in the active worksheet of an Excel instance

SAP automation

Launch SAP
Open the SAP GUI applic­ation and connect to an SAP system
Create new SAP session
Creates a new SAP session based on the same SAP instance
Select SAP menu item
Select an SAP menu item in the window tool bar
Start SAP transa­ction
Opens a specific transa­ction code in existing session
End SAP transa­ction
Closes the SAP transa­ction in a specific SAP instance and returns to the SAP easy access menu
Close SAP connection
Close the SAP connection of the selected SAP instance
Click SAP UI element
Interacts through click action on any UI element of an SAP window
Get details of SAP UI element
Gets the value of an SAP UI element's attribute in an SAP window
Populate SAP text field in element
Fills a text box in an SAP window with the specified text
 

Variables - Data table

Create new data table
Creates a new data table variable
Insert row into data table
Inserts a row at the end or before a specific index value
Find or replace in data table
Finds and/or replaces data table values
Update data table item
Update a data table row item on a defined column
Delete row from data table
Delete a data table row item
Insert column into data table
Inserts a column at the end or before a specific index value
Delete column from data table
Delete a data table column at the specified column index or column name
Delete empty rows from data table
Deletes the rows of the data table that have all of their cells empty
Delete duplicate rows from data table
Deletes all the rows that are duplicate from the data table, if the values have the same data type in each column
Clear data table
Deletes all the rows of the data table, keeping table headers unaffected
Sort data table
Sorts the data table rows in ascending or descending order by the specified column, if all its values have the same data type
Filter data table
Filters the data table rows based on the applied rules
Merge data tables
Merges two data tables together, specifying the merging behavior in case their number of columns is different
Join data tables
Joins two data tables based on the specified join rule
Read from CSV text variable
Generates a data table from a CSV text
Convert data table to text
Converts a data table to a CSV text

Condit­ionals

Case
An expression that, if met, a block of actions associated with that particular case runs
Default case
A block of actions that is run, if no case expression has been met in the switch body
Else
Marks the beginning of a block of actions that ran if the condition specified in the preceding 'If' statements aren't met
Else if
Marks the beginning of a block of actions that ran if the conditions specified in the preceding 'If' statements aren't met, but the condition specified in this statement is met
If
Marks the beginning of a block of actions that is run if the condition specified in this statement is met
Switch
Dispatches execution to different parts of the switch body based on the value of the expression

Loops

Exit loop
Terminates the loop and the flow resumes at the next action or statement following the loop
For each
Iterates over items in a list, data table or data row, allowing a block of actions to be executed repeatedly
Loop
Iterates a block of actions for a specified number of times
Loop condition
Iterates a block of actions as long as a specified condition proves to be true
Next loop
Forces the next iteration of the block to take place, skipping any actions in between

Folder

If folder exists
Mark the beginning of a condit­ional block of actions depending on whether a folder exists or not
Get files in folder
Retrieve the list of files in a folder
Get subfolders in folder
Retrieve the list of subfolders in a folder
Create folder
Create a new folder
Delete folder
Delete an existing folder and its contents (files and subfol­ders)
Empty folder
Delete all the contents of a folder (files and subfol­ders) without deleting the folder itself
Copy folder
Copy a folder into a destin­ation folder
Move folder
Move an existing folder into a destin­ation folder
Rename folder
Change the name of a folder
Get special folder
Retrieve the path of a Windows' special folder (such as Desktop, My Pictures, Internet Cache etc)

Compre­ssion

ZIP files
Compress one or more files or folders into a ZIP archive
Unzip files
Uncompress one or more files or folders contained in a ZIP archive

Workst­ation

Print document
Prints a document on the default printer
Get default printer
Gets the name of the default printer
Set default printer
Sets a printer as the default printer
Log off user
Logs off the current user
Shutdown computer
Instructs the computer to shut down
Show desktop
Shows the desktop
Lock workst­ation
Locks the workst­ation's display to protect it from unauth­orized use
Play sound
Plays a system sound or a wav file
Empty recycle bin
Deletes all files from the windows recycle bin
Take screenshot
Takes a screenshot of the foreground window or the specified screen and saves the image in a file or to the clipboard
Control screen saver
Enables, disables, starts or stops the screen­saver
Get screen resolution
Gets the width, height, bit count and frequency of a selected monitor
Set screen resolution
Sets the width, height, bit count and frequency of a selected monitor during an attended desktop flow run.

System

If process
Marks the beginning of a condit­ional block of actions depending on whether a process is running or not
Wait for process
Suspends the execution until a process starts or stops
Run applic­ation
Executes an applic­ation or opens a document by executing the associated applic­ation
Terminate process
Immedi­ately stops a running process
Ping
Sends a message to determine whether a remote computer is accessible over the network
Set Windows enviro­nment variable
Sets an enviro­nment variable to a given value
Get Windows enviro­nment variable
Retrieves the value of an enviro­nment variable
Delete Windows enviro­nment variable
Deletes an enviro­nment variable from a given scope

PDF

Extract text from PDF
Extract text from a PDF file
Extract tables from PDF
Extract tables from a PDF file
Extract images from PDF
Extract images from a PDF file
Extract PDF file pages to new PDF file
Extract pages from a PDF file to a new PDF file
Merge PDF files
Merges multiple PDF files into a new one

OCR

If text on screen (OCR)
Marks the beginning of a condit­ional block of actions depending on whether a given text appears on the screen or not, using OCR
Wait for text on screen (OCR)
Wait until a specific text appear­s/d­isa­ppears on the screen, on the foreground window, or relative to an image on the screen or foreground window using OCR
Extract text with OCR
Extract text from a given source using the given OCR engine

Text

Append line to text
Appends a new line of text to a text value
Get subtext
Retrieve a subtext from a text value
Crop text
Retrieves a text value that occurs before, after or between the specified text flag(s) in a given text
Pad text
Creates a fixed length text by adding characters to the left or to the right of an existing text
Trim text
Removes all occurr­ences of white space characters (such as space, tab, or new line) from the beginning and/or end of an existing text
Reverse text
Reverses the order of letters in a text string
Change text case
Changes the casing of a text to uppercase, lowercase, title case or sentence case
Convert text to number
Converts a text repres­ent­ation of a number to a variable that contains a numeric value
Convert number to text
Converts a number to text using a specified format
Convert text to datetime
Converts a text repres­ent­ation of a date and/or time value to a datetime value
Convert datetime to text
Converts a datetime value to text using a specified custom format
Create random text
Generates a text of specified length consisting of random charac­ters. This can be useful for generating passwords
Join text
Converts a list into a text value by separating its items with a specified delimiter
Split text
Creates a list containing the substrings of a text that are separated by a specified delimiter or a regular expression
Parse text
Parses a text to find the first or all occurr­ences of a specified subtext or a regular expression pattern
Replace text
Replaces all occurr­ences of a specified subtext with another text. It can also be used with regular expres­sions
Escape text for regular expression
Escapes a minimal set of characters (, *, +, ?, |, {, [, (,), ^, $,., #, and white space) by replacing them with their escape codes
Recognize entities in text
Recognizes entities in text, such as numbers, units, data/time and others expressed in natural language across multiple languages
Create HTML content
Generates rich HTML content and stores it in a variable

XML

Read XML from file
Read the contents of an XML file into a variable
Write XML to file
Write the contents of an XML node variable into a file
Execute XPath expression
Extract values from an XML document based on the provided XPath query
Get XML element attribute
Get the value of an attribute of an XML element
Set XML element attribute
Set the value of an attribute of an XML element
Remove XML element attribute
Remove an attribute from an XML element
Get XML element value
Get the value of an XML element
Set XML element value
Set the value of an XML element
Insert XML element
Insert a new XML element into an XML document
Remove XML element
Remove one or more XML elements from an XML document

Database

Open SQL connection
Open a new connection to a database
Execute SQL statement
Connect to a database and execute a SQL statement
Close SQL connection
Close an open connection to a database

CMD session

Open CMD session
Open a new CMD session
Read from CMD session
Read the output of a CMD session
Write to CMD session
Execute a command on an open CMD session
Wait for text on CMD session
Wait for a specific text on a previously opened CMD session
Close CMD session
Close a previously opened CMD session

Windows services

If service
Marks the beginning of a condit­ional block of actions depending on whether a service is running, paused, stopped or installed on the computer
Wait for service
Suspend the execution of the automation until a service is running, paused or stopped on the computer
Start service
Start a stopped Windows service
Stop service
Stop a running Windows service
Pause service
Pause a running Windows service
Resume service
Resume a paused Windows service

Azure - Virtual machines - Snapshots

Get snapshots
Gets the snapshots based on the specified criteria
Create snapshot
Creates a snapshot from the specified disk
Delete snapshot
Deletes the snapshot with the specified name and resource group

Azure - Virtual machines - Disks

Get disks
Gets the disks based on the specified criteria
Attach disk
Attaches an existing disk to the virtual machine with the specified name and resource group
Detach disk
Detaches the disk from the virtual machine with the specified name and resource group
Create managed disk
Creates a managed disk with the specified settings
Delete disk
Deletes the managed disk with the specified name and resource group

Active Directory

Connect to server
Connects to an Active Directory server
Close connection
Closes the connection with the Active Directory server

Active Directory - Group

Create group
Creates a group in the Active Directory
Get group info
Gets inform­ation about a group from the Active Directory server
Get group members
Gets the members of a group in the Active Directory
Modify group
Modifies a group in the Active Directory

Active Directory - Object

Create object
Creates an object in the Active Directory
Delete object
Deletes an object in the Active Directory
Move object
Moves an object in the Active Directory
Rename object
Renames an object in the Active Directory

Microsoft cognitive - Bing spell check

Spell check
Invokes the Microsoft Cognitive service named 'Bing Spell Check'

Microsoft cognitive - Computer vision

Analyze image
Invokes the Microsoft Cognitive service named 'Analyze Image'
Describe image
Invokes the Microsoft Cognitive service named 'Describe Image'
OCR
Invokes the Microsoft Cognitive service named 'OCR'
Tag image
Invokes the Microsoft Cognitive service named 'Tag Image'

Microsoft cognitive - Text Analytics

Detect language
Invokes the Microsoft Cognitive service named 'Text Analytics - Detect Language'
Key phrases
Invokes the Microsoft Cognitive service named 'Text Analytics - Key Phrases'
Sentiment
Invokes the Microsoft Cognitive service named 'Text Analytics - Sentiment'

Clipboard

Get clipboard text
Gets clipboard text.
Set clipboard Text
Sets clipboard text.
Clear clipboard contents
Clears clipboard contents.

AI Builder ♦

Create text with GPT
Get a response generated by GPT.

Office 365 Outlook ♦

Create contact (V2)
This operation creates a new contact in a contacts folder.
Create event (V4)
This operation creates a new event in a calendar.
Delete contact (V2)
This operation deletes a contact from a contacts folder.
Delete email (V2)
This operation deletes an email by id.
Delete event (V2)
This operation deletes an event in a calendar.
Export email (V2)
Export the content of the email in the EML file format.
Find meeting times (V2)
Find meeting time sugges­tions based on organizer, attendee availa­bility, and time or location constr­aints
Flag email (V2)
This operation updates an email flag.
Forward an email (V2)
Forward an email.
Get Attachment (V2)
This operation gets an email attachment by id.
Get calendar view of events (V3)
This operation gets all events (including instances of recurr­ences) in a calendar using Graph API. Recurrence property is null in this case.
Get calendars (V2)
This operation lists available calendars.
Get contact (V2)
This operation gets a specific contact from a contacts folder.
Get contacts (V2)
This operation gets contacts from a contacts folder.
Get email (V2)
This operation gets an email by id.
Get emails (V3)
This operation gets emails from a folder via graph apis. Please note that filtering related to these fields: To, Cc, To Or Cc, From, Import­ance, Fetch Only With Attach­ments, Subject Filter, is performed using first 250 items in a given mail folder. To avoid that limitation you can use 'Search Query' field.
Get event (V3)
This operation gets a specific event from a calendar using Graph API. (V3)
Get events (V4)
This operation gets events from a calendar using Graph API. (V4)
Get room lists (V2)
Get all the room lists defined in the user's tenant
Get rooms (V2)
Get all the meeting rooms defined in the user's tenant
Get rooms in room list (V2)
Get the meeting rooms in a specific room list
Mark as read or unread (V3)
This operation marks an email as read/u­nread.
Move email (V2)
This operation moves an email to the specified folder within the same mailbox.
Reply to email (V3)
This operation replies to an email.
Respond to an event invite (V2)
Respond to an event invite.
Send an email (V2)
This operation sends an email message.
Send an email from a shared mailbox (V2)
This operation sends an email from a shared mailbox. Your account should have permission to access the mailbox for this operation to succeed.
Set up automatic replies (V2)
Set the automatic replies setting for your mailbox.
Update contact (V2)
This operation updates a contact in a contacts folder.
Update event (V4)
This operation updates an event in a calendar using Graph API.
Send an HTTP request
Construct a Microsoft Graph REST API request to invoke. These segments are supported: 1st segement: /me, /users/ 2nd segment: messages, mailFo­lders, events, calendar, calendars, outlook, infere­nce­Cla­ssi­fic­ation. Learn more: https:­//d­ocs.mi­cro­sof­t.c­om/­en-­us/­gra­ph/­use­-th­e-api

Microsoft Forms ♦

Get response details
This action retrieves a form response

RSS ♦

List all RSS feed items
This operation retrieves all items from an RSS feed.

Microsoft Teams ♦

Add a member to a tag
This operation adds a user to a tags.
Add a member to a team
This operation adds a member to a team.
Create a channel
This operation is used to create a new channel for a specific Team.
Create a chat
This operation creates a one on one or group chat
Create a tag for a team
This operation creates a tag.
Create a team
This operation a creates a new team.
Create a Teams meeting
Create a meeting with a link at the bottom of the invite to join the meeting online on Teams
Delete a member from a tag
This operation deletes a member from a tag.
Delete a tag
This operation deletes a tag.
Get a team
This operation returns details for a team using the team's unique ID.
Get an @mention token for a tag
This operation creates a token that can be inserted into a message or adaptive card sent as a user in a channel to @mention a tag.
Get an @mention token for a user
This operation creates a token that can be inserted into a message or adaptive card to @mention a user.
Get message details
This operation gets details of a message in a chat or a channel.
Get messages
This operation is used to get messages from a channel in a specific Team.
List all tags for a team
This operation retrieves a list of tags.
List channels
This operation retrieves a list of all the channels for a specific Team.
List chats
This operation retrieves a list of recent chats.
List members
This operation list members based on a threadtype (chat, channel, etc).
List teams
This operation retrieves a list of all the Teams (Office 365 Groups) you are a member of.
List the members for a tag
This operation lists the members for a tag.
Post a feed notifi­cation
This operation posts a feed notifi­cation.
Post card in a chat or channel
This operation posts a card to a chat or a channel.
Post message in a chat or channel
This operation posts a message to a chat or a channel.
Reply with a message in a channel
This operation replies with a message in a channel.
Reply with adaptive card in a channel
This operation replies with an adaptive card to a channel.
Update an adaptive card in a chat or channel
This operation updates an existing adaptive card.
Send a Microsoft Graph HTTP request
Construct a Microsoft Graph REST API request to invoke against the Microsoft Team endpoints. These segments are supported: 1st segment: /teams, /me, /users 2nd segment: channels, chats, instal­led­Apps, messages, pinned­Mes­sages. Learn more: https:­//d­ocs.mi­cro­sof­t.c­om/­en-­us/­gra­ph/­use­-th­e-api

SAP automation - Advanced

Attach
Attach the running SAP GUI applic­ation to an SAP instance
 

Flow control

Comment
User comment
End
Set rules and manage the course of the flow
Exit subflow
Exits current subflow and returns to the point it was called from
Get last error
Retrieves the last error that occurred in the flow
Go to
Transfers the flow of execution to another point, indicated by a label
Label
Acts as the destin­ation of a 'go to' statement
On block error
Marks the beginning of a block to handle actions errors
Run subflow
Run a subflow specifying any required arguments
Stop flow
Terminates the flow
Wait
Suspends the execution of the flow for a specified amount of seconds
Region
Marks the beginning of a group of actions
End region
Marks the end of a group of actions

Run flow

Run desktop flow
Runs a desktop flow which can receive input variables and may produce output variables. The parent flow run will be paused until the called desktop flow completes.

File

If file exists
Marks the beginning of a condit­ional block of actions depending on whether a file exists or not
Wait for file
Suspend the execution of the automation until a file is created or deleted
Copy file(s)
Copy one or more files into a destin­ation folder
Move file(s)
Move one or more files into a destin­ation folder
Delete file(s)
Delete one or more files
Rename file(s)
Change the name of one or more files
Read text from file
Read the contents of a text file
Write text to file
Write or appends text to a file
Read from CSV file
Read a CSV file into a data table
Write to CSV file
Write a data table, data row or list to a CSV file
Get file path part
Retrieve one or more parts (direc­tory, filename, extension etc) from a text that represents a file path
Get temporary file
Create a uniquely named, empty temporary file on disk, and get the file object (which is a repres­ent­ation, and can access the file and all its inform­ation)
Convert file to Base64
Convert a file to Base64 encoded text
Convert Base64 to file
Convert a Base64 encoded text to file
Convert file to binary data
Convert a file to binary data.
Convert binary data to file
Convert binary data to file.

Email

Retrieve email messages
Retrieves email messages from an IMAP server
Process email messages
Moves, deletes or marks as unread an email (or a list of emails) retrieved by a Retrieve emails action
Send email
Creates and sends a new email message

Exchange Server

Connect to Exchange server
Open a new connection to an Exchange server
Retrieve Exchange email messages
Retrieve email messages from the specified Exchange server
Send Exchange email message
Create and send a new email message
Process Exchange email messages
Move, delete or mark as unread an email message (or a list of email messages)

Outlook

Launch Outlook
Launch Outlook and create a new Outlook instance
Retrieve email messages from Outlook
Retrieve email messages from an Outlook account
Send email through Outlook
Create and send a new email message through Outlook
Process email messages in Outlook
Move or deletes an email (or a list of email messages) retrieved by a 'Retrieve emails from Outlook' action.
Save Outlook email messages
Save Outlook email messages given an account
Respond to Outlook mail message
Respond to an Outlook message, by replying, replying to all or forwarding it
Close Outlook
Close a previously launched Outlook instance

Excel - Advanced

Resize column­s/rows in Excel worksheet
Resizes a selection of columns or rows in the active worksheet of an Excel instance
Run Excel Macro
Runs a specified macro on the document of an Excel instance
Get active Excel worksheet
Retrieves an Excel document's active worksheet
Get all Excel worksheets
Retrieves all worksheet names of an Excel document
Delete Excel worksheet
Deletes a specific worksheet from an Excel instance
Rename Excel worksheet
Renames a specific worksheet of an Excel instance
Activate Cell in Excel Worksheet
Activate a cell in the active worksheet of an Excel instance, by providing column, row and offset
Select cells in Excel worksheet
Selects a range of cells in the active worksheet of an Excel instance
Get selected cell range from Excel worksheet
Retrieve the selected range of cells in a structure consisting of first column, first row, last column and last row
Copy cells from Excel worksheet
Copies a range of cells from the active worksheet of an Excel instance
Paste cells to Excel worksheet
Pastes a range of cells to the active worksheet of an Excel instance
Delete from Excel worksheet
Deletes a cell or a range of cells from the active worksheet of an Excel instance
Insert row to Excel worksheet
Inserts a row above a selected row of an Excel instance
Delete row from Excel worksheet
Deletes a selected row from an Excel instance
Insert column to Excel worksheet
Inserts a column to the left of a selected column of an Excel instance
Delete column from Excel worksheet
Deletes a selected column from an Excel instance
Find and replace cells in Excel worksheet
Finds text and replaces it with another in the active worksheet of an Excel instance
Get first free row on column from Excel worksheet
Retrieve the first free row, given the column of the active worksheet
Copy Excel worksheet
Copies a worksheet from an Excel document and paste it to the Excel document of the same or different Excel instance
Read formula from Excel
Reads the formula inside a cell in Excel
Get table range from Excel worksheet
Retrieves the range of a table in the active worksheet of an Excel instance
Auto fill cells in Excel worksheet
Auto fills a range with data, based on the data of another range, in the active worksheet of an Excel instance
Append cells in Excel worksheet
Appends a range of cells to the active worksheet of an Excel instance
Lookup range in Excel worksheet
Finds and returns the result of Excel's LOOKUP function
Set color of cells in Excel worksheet
Fills the background of the selected cells with the specified color, in the active worksheet of an Excel instance

Excel

Launch Excel
Launches a new Excel instance or opens an Excel document
Attach to running Excel
Attaches to an Excel document that's already open
Read from Excel worksheet
Reads the value of a cell or a range of cells from the active worksheet of an Excel instance
Get active cell on Excel worksheet
Get the active cell in the active worksheet of the Excel document
Save Excel
Saves a previously launched Excel instance
Write to Excel worksheet
Writes a value into a cell or a range of cells of an Excel instance
Close Excel
Closes an Excel instance
Set active Excel worksheet
Activates a specific worksheet of an Excel instance
Add new worksheet
Adds a new worksheet to the document of an Excel instance
Get first free column/row from Excel worksheet
Retrieves the first free column and/or row of the active worksheet. This is useful for adding new data into a worksheet that already has data in it
Get column name on Excel worksheet
Gets the name of the column
Clear cells in Excel worksheet
Clears a range of cells or a named cell in the active worksheet of an Excel instance
Sort cells in Excel worksheet
Sort cells based on one or more columns in an Excel worksheet
Filter cells in Excel worksheet
Applies filters on a specified column in an Excel worksheet
Clear filters in Excel worksheet
Clear filters on a specified column in an Excel worksheet
Get empty cell
Get empty cell

Message boxes

Display message
Displays a message box
Display input dialog
Displays a dialog box that prompts the user to enter text
Display select date dialog
Displays a dialog box that prompts the user to enter a date or date range
Display select from list dialog
Displays a dialog box with options that lets the user select from a list
Display select file dialog
Displays the select file dialog and prompts the user to select one or more files
Display select folder dialog
Displays the select folder dialog and prompts the user to select a folder
Display custom form
Display a customized form that can include multiple types of elements, like text, number or file inputs etc.

Date time

Add to datetime
Adds (or subtracts) a specific number of seconds, minutes, hours or days to a datetime value
Subtract dates
Finds the time difference between two given dates in days, hours, minutes, or seconds
Get current date and time
Retrieves the current date or the current date and time

Scripting

Run DOS command
Executes a DOS command or console applic­ation in invisible mode and retrieves its output upon completion
Run VBScript
Executes some custom VBScript code and retrieves its output into a variable
Run JavaScript
Executes some custom JavaScript code and retrieves its output into a variable
Run PowerShell script
Executes some custom PowerShell script and retrieves its output into a variable
Run Python script
Executes Python 2 script code and retrieves its output
Run .NET script
Executes a user provided .NET script and stores its output in variables.

FTP

Open FTP connection
This action establ­ishes a specific connection to a remote FTP server, and stores that connection as a variable for later use.
List FTP directory
This action returns the subdir­ect­ories and files contained in the current directory of an FTP connection
Open secure FTP connection
This action establ­ishes a specific secure connection to a remote FTP server, and stores that connection as a variable for later use
Close connection
This action closes an open FTP connection
Change working directory
This action sets the current working directory for an FTP connection
Download file(s) from FTP
Downloads one or more files from an FTP server
Download folder(s) from FTP
Downloads one or more folders from an FTP server
Upload File(s) to FTP
Uploads one or more files to an FTP server
Upload folder(s) to FTP
Uploads one or more folders to an FTP server
Delete FTP file
Deletes one or more files from an FTP server
Rename FTP File
Renames a file that resides on an FTP server
Create FTP directory
Creates a directory on an FTP server
Delete FTP directory
Deletes a directory from an FTP server
Invoke FTP command
Invokes the given literal FTP command on the server
Synchr­onize direct­ories
Synchr­onize the files and subdir­ect­ories of a given Folder with a given remote FTP directory

AWS - EC2

Create EC2 session
Create an EC2 client to automate EC2 web services
End EC2 session
Dispose an open EC2 client

AWS - EC2 - Instances

Start EC2 instance
Start EC2 instan­ce(s)
Stop EC2 instance
Stop EC2 instan­ce(s)
Reboot EC2 instance
Reboot EC2 instan­ce(s)
Get available EC2 instances
Get inform­ation for the relevant EC2 instances
Describe instances
Returns all the inform­ation for the specified EC2 instan­ce(s)

AWS - EC2 - Snapshots

Create snapshot
Create a snapshot of an EBS volume and stores it in Amazon S3
Describe snapshots
Describes the specified EBS snapshots available
Delete snapshot
Delete the specified snapshot

AWS - EC2 - Volumes

Create volume
Create an EBS volume
Attach volume
Attach an EBS volume to an EC2 instance
Detach volume
Detach an EBS volume from an EC2 instance
Describe volumes
Describe the specified EBS volumes
Delete volume
Delete the specified EBS volume

Active Directory - User

Create user
Creates a user in the Active Directory
Get user info
Gets a user's inform­ation in the Active Directory
Modify user
Modify a user in the Active Directory
Unlock user
Unlocks an Active Directory user
Update user info
Updates a user's inform­ation in the Active Directory

Terminal emulation

Open terminal session
Open a new terminal session
Close terminal session
Close an open terminal session
Move cursor on terminal session
Move the terminal's cursor on the specified position
Get text from terminal session
Get text from a terminal session
Set text on terminal session
Set text on a terminal session
Send key to terminal session
Send a control key to a terminal session
Wait for text on terminal session
Wait for a specific text to appear on a terminal session
Search for text on terminal session
Search for all occurr­ences of a specific text on a terminal session

IBM cognitive - Document conversion

Convert document
Invokes the IBM service named 'Convert Document'

IBM cognitive - Visual recogn­ition

Classify Image
Invokes the IBM service named 'Classify Image'

IBM cognitive - Language translator

Translate
Invokes the IBM service named 'Trans­late'
Identify language
Invokes the IBM service named 'Identify Language'

IBM cognitive - Tone analyzer

Analyze tone
Invokes the IBM service named 'Analyze Tone'

Work queues ♦

Process work queue items
Indicates to the orches­trator that the machine is ready to process one or more work queue items, if available
Update work queue item
Updates the status and processing result of a specific work queue item
Add work queue item
Add a work queue item into a work queue
Requeue item with delay
Requeue a work queue item and delay it until a specified date and time
Add multiple work queue items
Adds one or more work queue items to a work queue based on the data provided in the work queue item data table
Update work queue item processing notes
Updates the processing notes of a specific work queue item
Get work queue items by filter
Retrieves one or more work queue items based on FetchXML filtering expres­sions

OneDrive for Business ♦

Copy file
This operation copies a file within OneDrive.
Copy file using path
This operation copies a file within OneDrive by path.
Create file
This operation creates a file.
Create share link
This operation creates a share link for a file.
Create share link by path
This operation creates a share link for a file using the path.
Delete file
This operation deletes a file.
Extract archive to folder
This operation extracts an archive file into a folder (example: .zip). Maximum archive size is 50 MB and 100 files inside.
Find files in folder
This operation finds files within a folder 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
This operation gets the thumbnail of a file. The thumbnail will only be valid for 6 hours.
List files in folder
This operation gets the list of files and subfolders in a folder.
List files in root folder
This operation gets the list of files and subfolders in the root folder.
Move or rename a file
This operation moves or renames a file.
Move or rename a file using path
This operation moves or renames a file using the path.
Update file
This operation updates a file.
Upload file from URL
This operation uploads a file from a URL to OneDrive.
Convert file
This operation converts a file to another format. The list of supported conver­sions can be found at https:­//a­ka.m­s/­one­dri­vec­onv­ersions
Convert file using path
This operation converts a file to another format using the path. The list of supported conver­sions can be found at https:­//a­ka.m­s/­one­dri­vec­onv­ersions

Excel Online (Business) ♦

Add a key column to a table
Add a key column to an Excel table. The new column will be appended to the right.
Add a row into a table
Add a new row into the Excel table.
Create table
Create a new table in the Excel workbook.
Create worksheet
Create a new worksheet in the Excel workbook.
Delete a row
Delete a row using a key column.
Get a row
Get a row using a key column.
Get tables
Get a list of tables in the Excel workbook.
Get worksheets
Get a list of worksheets in the Excel workbook.
List rows present in a table
List rows present in a table.
Run script
Runs an Office Script against an Excel workbook. Use this action when the script is saved in the default location.
Run script from SharePoint library
Runs an Office Script against an Excel workbook. Use this action when the script is saved outside of the default location.
Update a row
Update a row using a key column. The input value will overwrite the specified cells and columns left blank will not be updated. In order to append (instead of overwrite) a value, use the "Get a row" action to retrieve the content first.

OneDrive ♦

Convert file
This operation converts a file to another format. The list of supported conver­sions can be found at https:­//a­ka.m­s/­one­dri­vec­onv­ersions
Convert file using path
This operation converts a file to another format using the path. The list of supported conver­sions can be found at https:­//a­ka.m­s/­one­dri­vec­onv­ersions
Copy file
This operation copies a file within OneDrive.
Copy file using path
This operation copies a file within OneDrive by path.
Create file
This operation creates a file.
Create share link
This operation creates a share link for a file.
Create share link by path
This operation creates a share link for a file using the path.
Delete file
This operation deletes a file.
Extract archive to folder
This operation extracts an archive file into a folder (example: .zip). Maximum archive size is 50 MB and 100 files inside.
Find files in folder
This operation finds files within a folder 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
This operation gets the thumbnail of a file. The thumbnail will only be valid for 6 hours.
List files in folder
This operation gets the list of files and subfolders in a folder.
List files in root folder
This operation gets the list of files and subfolders in the root folder.
Move or rename a file
This operation moves or renames a file.
Move or rename a file using path
This operation moves or renames a file using the path.
Update file
This operation updates a file.
Upload file from URL
This operation uploads a file from a URL to OneDrive.
Add file tag
This operation adds a tag to a file
Get file tags
This operation gets the tags of a file
Remove file tag
This operation removes a tag from a file
 

Comments

thank you!

VJR VJR, 04:50 29 Jul 23

You're welcome!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          ElectroNeek - Studio Pro V1.0 Cheat Sheet