Power Automate Desktop Actions Cheat Sheet by VJR

Get the integral or fractional digits of a numeric value, or round up the value to a specified number of decimal places

Generate a random number or a list of random numbers that fall between a minimum and maximum value

Remove all items from a list

Remove one or multiple items from a list

Sort the items of a list. Use items of the same type

Create a random permut­ation of a list

Merge two lists into one

Reverse the order of the items of a list

Remove the multiple occurr­ences of items in a list, so that in the resulting list each item will be unique

Compare two lists and create a new list with the items that are common to both

Compare two lists and create a new list with the items that are in the first list but not in the second

Convert the contents of a data table column into a list

Convert a JSON string to a custom object

Convert a custom object to a JSON string

Αppend a new item to a list

Create a new empty list

Increase the value of a variable by a specific amount

Decrease the value of a variable by a specific amount

Set the value of a new or existing variable, create a new variable or overwrite a previously created variable

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

Suspends the execution of the automation until a specific piece of text or UI element appears or disappears from a Window

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

Performs desktop and taskbar related operations

Selects a tab from a group of tabs

This action waits until a specific image appears on the screen or on the foreground window

Hover the mouse over any UI element on window

Clicks on any UI element of a window

Selects an option in a menu of a window

Drags and drops a UI element of a window

Expands or collapses a node of a tree view residing in a 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

Suspends the execution or the process until a specific window opens, closes, get or loses the focus

Gets a property of a window such as its title or its source text

Gets the value of a UI element's attribute in a window

Retrieves the names of the selected checkboxes in a checkbox group or the state of a specific checkbox

Retrieves the names of the selected radio button in a radio button group or the state of a specific radio button

Extracts data from specific parts of a window in the form of single values, lists, or tables

Takes a screenshot of a UI element in window

Extracts data from a table in the form of a datatable

Sets the focus on a text box of a window and scrolls it into view

Fills a text box in a window with the specified text

Presses a window button

Selects a radio button on a window

Checks or unchecks a checkbox in a window form

Sets or clears the selected option(s) for a drop-down list in a window form

Gets a running window, for automating desktop applic­ations

Activates and brings to the foreground a specific window

Restores, maximizes or minimizes a specific window

Shows a hidden window or hides a visible window

Sets the position of a specific window

Sets the size of a specific window

Closes a specific window

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

Suspend the flow until a specific piece of text or web page element appears or disappears from a web page

Launch a new instance or attach to a running instance of Internet Explorer for automating web sites and web applic­ations

Launch a new instance or attach to a running instance of Firefox for automating web sites and web applic­ations

Launch a new instance or attach to a running instance of Chrome for automating web sites and web applic­ations

Launch a new instance or attach to a running instance of Edge for automating web sites and web applic­ations

Create a new tab and navigate to the given URL (supported in Edge, Chrome and Firefox)

Navigate the web browser to a new page

Click on a link or any other element of a web page

Click on a link in a web page that results in downlo­ading a file

Run a JavaScript function on the web page and get the returned result

Hover the mouse over an element of a web page

Close a web browser window

Set the focus on an input element of a web page and scroll it into view

Fill a text field in a web page with the specified text

Check or uncheck a check box in a web form

Select a radio button on the web page

Set or clear the selected option for a drop-down list in a web form

Press a web page button

Extract data from specific parts of a web page in the form of single values, lists, rows or tables

Get a property of a web page, such as its title or its source text

Get the value of an element's attribute on a 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

Downloads text or a file from the web and stores it

Invokes a method from a SOAP web service

Invokes a web service by sending data and retrieves the response from the web service

Blocks user mouse and keyboard input, so that the flow can perform mouse and keyboard actions without interf­erence from the user

Retrieves the current position of the mouse cursor on the screen in pixel coordi­nates

Moves the mouse to a specific position

Moves the mouse over an image found on screen or on the foreground window

Moves the mouse over a text found on the screen or on the foreground window using OCR

Sends a mouse click event

Sends keys to the applic­ation that is currently active

Presses (and holds) or releases one or more modifier keys (Alt, Control, or Shift)

Sets the state (on or off) for the keys Caps Lock, Num Lock or Scroll Lock

Suspends the execution of the flow until the mouse pointer changes, usually to or from the 'wait cursor' or hourglass

Retrieves the active keyboard identifier from the machine's registry

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

Creates an Azure session

Gets subscr­iptions that the current account can access

Ends an Azure session

Gets the resource groups based on the specified criteria

Creates a new resource group

Deletes the specified resource group and all the contained resources

Gets the basic inform­ation for the virtual machines

Gets all the inform­ation for the virtual machine(s) based on the specified criteria

Starts the virtual machine

Stops the virtual machine and deallo­cates the related hardware (CPU and memory) and network resources

Shuts down the operating system of a virtual machine

Restarts a virtual machine

Encrypt a string with AES, using a key and a specified encoding format

Decrypt a string with AES based on a specified key and an encoding format

Encrypt the contents of a file with AES, using a key and a specified encoding format

Decrypt a string to a file with AES based on a specified key and an encoding format

Hash a string, using a specified algorithm and an encoding format

Hash the contents of a file, using a specified algorithm and an encoding format

Hash a string with a key, using a specified algorithm and an encoding format

Hash the contents of a file with a key, using a specified algorithm and an encoding format

Retrieves a password for a specific applic­ation from CyberArk

Invokes the Google Cloud Natural Language service named 'Analyze Sentiment'

Invokes the Google Cloud Natural Language service named 'Analyze Entities'

Invokes the Google Cloud Natural Language service named 'Analyze Syntax'

Invokes the Google Cloud Vision service named 'Label Detection'

Invokes the Google Cloud Vision service named 'Landmark Detection'

Invokes the Google Cloud Vision service named 'Text Detection'

Invokes the Google Cloud Vision service named 'Logo Detection'

Invokes the Google Cloud Vision service named 'Image Properties Detection'

Invokes the Google Cloud Vision service named 'Safe Search Detection'

Updates the contents of the file specified by the file identi­fier.

Deletes the file specified by the file identi­fier.

Gets file contents using the file path.

Get file contents using the file identi­fier. The contents can be copied somewhere else, or be used as an attach­ment.

Uploads a file to a SharePoint site. Make sure to pick an existing library.

Returns files contained in a SharePoint folder.

Get all lists and libraries.

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.

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.

Gets inform­ation about the folder. Uses a file identifier to pick the folder.

Gets inform­ation about the folder. Uses a folder path to pick the folder.

Returns files in the root SharePoint folder.

Extracts an archive file into a SharePoint folder (example: zip).

Gets SharePoint lists from a site.

Create sharing link for a file or folder.

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.

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.

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.

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 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.

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 a checked out file in a document library, which makes the version of the document available to others.

Gets views from a SharePoint list.

Adds a new attachment to the specified list item

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.

Delete all links giving access to an item or a file and remove all people with direct access except for owners.

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.

Updates the values stored in library columns for a file analyzed by the model specified by the ModelId.

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.

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.

Creates a new item in a SharePoint list.

Creates a new folder or folder path.

Deletes the specified attach­ment.

Deletes an item from a SharePoint list.

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.

Returns file contents using the file identi­fier. The contents can be copied somewhere else, or be used as an attach­ment.

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.

Returns inform­ation about columns that have changed within a given time window. Note: The list must have Versioning turned on.

Updates an item in a SharePoint list.

Gets a single item by its id from a SharePoint list.

Gets items from a SharePoint list.

Creates a new document list item

Grant access to an item or a folder in SharePoint to specific people

Construct a SharePoint REST API to invoke. Note - This action may execute any SharePoint REST API you have access to. Please proceed with caution.

Adds a custom text message to the flow run action details

Create a new page in the Quick Notes section.

Create new page in a specified section.

Create section in a notebook.

Delete a page.

Get HTML page content.

Get pages for a specific section.

Get recent notebooks.

Get sections in a specific notebook.

Update HTML page content.

Gets a PDF version of the selected file

Reads a Microsoft Word template to then fill the template fields with selected dynamic values to generate a Word Document.

Opens a new Word instance or opens a Word document

Attaches to a Word document that's already open

Saves a previously launched Word instance

Closes a Word instance

Reads the text content from a document of a Word instance

Write or append text to a Word file

Insert an image to a Word file

Finds text and replaces it with another in the active worksheet of an Excel instance

Open the SAP GUI applic­ation and connect to an SAP system

Creates a new SAP session based on the same SAP instance

Select an SAP menu item in the window tool bar

Opens a specific transa­ction code in existing session

Closes the SAP transa­ction in a specific SAP instance and returns to the SAP easy access menu

Close the SAP connection of the selected SAP instance

Interacts through click action on any UI element of an SAP window

Gets the value of an SAP UI element's attribute in an SAP window

Fills a text box in an SAP window with the specified text

Retrieves the values of a credential created through Power Automate's portal page for this enviro­nment

Creates a new data table variable

Inserts a row at the end or before a specific index value

Finds and/or replaces data table values

Update a data table row item on a defined column

Delete a data table row item

Inserts a column at the end or before a specific index value

Delete a data table column at the specified column index or column name

Deletes the rows of the data table that have all of their cells empty

Deletes all the rows that are duplicate from the data table, if the values have the same data type in each column

Deletes all the rows of the data table, keeping table headers unaffected

Sorts the data table rows in ascending or descending order by the specified column, if all its values have the same data type

Filters the data table rows based on the applied rules

Merges two data tables together, specifying the merging behavior in case their number of columns is different

Joins two data tables based on the specified join rule

Generates a data table from a CSV text

Converts a data table to a CSV text

An expression that, if met, a block of actions associated with that particular case runs

A block of actions that is run, if no case expression has been met in the switch body

Marks the beginning of a block of actions that ran if the condition specified in the preceding 'If' statements aren't met

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

Marks the beginning of a block of actions that is run if the condition specified in this statement is met

Dispatches execution to different parts of the switch body based on the value of the expression

Terminates the loop and the flow resumes at the next action or statement following the loop

Iterates over items in a list, data table or data row, allowing a block of actions to be executed repeatedly

Iterates a block of actions for a specified number of times

Iterates a block of actions as long as a specified condition proves to be true

Forces the next iteration of the block to take place, skipping any actions in between

Mark the beginning of a condit­ional block of actions depending on whether a folder exists or not

Retrieve the list of files in a folder

Retrieve the list of subfolders in a folder

Create a new folder

Delete an existing folder and its contents (files and subfol­ders)

Delete all the contents of a folder (files and subfol­ders) without deleting the folder itself

Copy a folder into a destin­ation folder

Move an existing folder into a destin­ation folder

Change the name of a folder

Retrieve the path of a Windows' special folder (such as Desktop, My Pictures, Internet Cache etc)

Compress one or more files or folders into a ZIP archive

Uncompress one or more files or folders contained in a ZIP archive

Prints a document on the default printer

Gets the name of the default printer

Sets a printer as the default printer

Logs off the current user

Instructs the computer to shut down

Shows the desktop

Locks the workst­ation's display to protect it from unauth­orized use

Plays a system sound or a wav file

Deletes all files from the windows recycle bin

Takes a screenshot of the foreground window or the specified screen and saves the image in a file or to the clipboard

Enables, disables, starts or stops the screen­saver

Gets the width, height, bit count and frequency of a selected monitor

Sets the width, height, bit count and frequency of a selected monitor during an attended desktop flow run.

Marks the beginning of a condit­ional block of actions depending on whether a process is running or not

Suspends the execution until a process starts or stops

Executes an applic­ation or opens a document by executing the associated applic­ation

Immedi­ately stops a running process

Sends a message to determine whether a remote computer is accessible over the network

Sets an enviro­nment variable to a given value

Retrieves the value of an enviro­nment variable

Deletes an enviro­nment variable from a given scope

Extract text from a PDF file

Extract tables from a PDF file

Extract images from a PDF file

Extract pages from a PDF file to a new PDF file

Merges multiple PDF files into a new one

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 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 from a given source using the given OCR engine

Appends a new line of text to a text value

Retrieve a subtext from a text value

Retrieves a text value that occurs before, after or between the specified text flag(s) in a given text

Creates a fixed length text by adding characters to the left or to the right of an existing 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

Reverses the order of letters in a text string

Changes the casing of a text to uppercase, lowercase, title case or sentence case

Converts a text repres­ent­ation of a number to a variable that contains a numeric value

Converts a number to text using a specified format

Converts a text repres­ent­ation of a date and/or time value to a datetime value

Converts a datetime value to text using a specified custom format

Generates a text of specified length consisting of random charac­ters. This can be useful for generating passwords

Converts a list into a text value by separating its items with a specified delimiter

Creates a list containing the substrings of a text that are separated by a specified delimiter or a regular expression

Parses a text to find the first or all occurr­ences of a specified subtext or a regular expression pattern

Replaces all occurr­ences of a specified subtext with another text. It can also be used with regular expres­sions

Escapes a minimal set of characters (, *, +, ?, |, {, [, (,), ^, $,., #, and white space) by replacing them with their escape codes

Recognizes entities in text, such as numbers, units, data/time and others expressed in natural language across multiple languages

Generates rich HTML content and stores it in a variable

Read the contents of an XML file into a variable

Write the contents of an XML node variable into a file

Extract values from an XML document based on the provided XPath query

Get the value of an attribute of an XML element

Set the value of an attribute of an XML element

Remove an attribute from an XML element

Get the value of an XML element

Set the value of an XML element

Insert a new XML element into an XML document

Remove one or more XML elements from an XML document

Open a new connection to a database

Connect to a database and execute a SQL statement

Close an open connection to a database

Open a new CMD session

Read the output of a CMD session

Execute a command on an open CMD session

Wait for a specific text on a previously opened CMD session

Close a previously opened CMD session

Marks the beginning of a condit­ional block of actions depending on whether a service is running, paused, stopped or installed on the computer

Suspend the execution of the automation until a service is running, paused or stopped on the computer

Start a stopped Windows service

Stop a running Windows service

Pause a running Windows service

Resume a paused Windows service

Gets the snapshots based on the specified criteria

Creates a snapshot from the specified disk

Deletes the snapshot with the specified name and resource group

Gets the disks based on the specified criteria

Attaches an existing disk to the virtual machine with the specified name and resource group

Detaches the disk from the virtual machine with the specified name and resource group

Creates a managed disk with the specified settings

Deletes the managed disk with the specified name and resource group

Connects to an Active Directory server

Closes the connection with the Active Directory server

Creates a group in the Active Directory

Gets inform­ation about a group from the Active Directory server

Gets the members of a group in the Active Directory

Modifies a group in the Active Directory

Creates an object in the Active Directory

Deletes an object in the Active Directory

Moves an object in the Active Directory

Renames an object in the Active Directory

Invokes the Microsoft Cognitive service named 'Bing Spell Check'

Invokes the Microsoft Cognitive service named 'Analyze Image'

Invokes the Microsoft Cognitive service named 'Describe Image'

Invokes the Microsoft Cognitive service named 'OCR'

Invokes the Microsoft Cognitive service named 'Tag Image'

Invokes the Microsoft Cognitive service named 'Text Analytics - Detect Language'

Invokes the Microsoft Cognitive service named 'Text Analytics - Key Phrases'

Invokes the Microsoft Cognitive service named 'Text Analytics - Sentiment'

Gets clipboard text.

Sets clipboard text.

Clears clipboard contents.

Get a response generated by GPT.

This operation creates a new contact in a contacts folder.

This operation creates a new event in a calendar.

This operation deletes a contact from a contacts folder.

This operation deletes an email by id.

This operation deletes an event in a calendar.

Export the content of the email in the EML file format.

Find meeting time sugges­tions based on organizer, attendee availa­bility, and time or location constr­aints

This operation updates an email flag.

Forward an email.

This operation gets an email attachment by id.

This operation gets all events (including instances of recurr­ences) in a calendar using Graph API. Recurrence property is null in this case.

This operation lists available calendars.

This operation gets a specific contact from a contacts folder.

This operation gets contacts from a contacts folder.

This operation gets an email by id.

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.

This operation gets a specific event from a calendar using Graph API. (V3)

This operation gets events from a calendar using Graph API. (V4)

Get all the room lists defined in the user's tenant

Get all the meeting rooms defined in the user's tenant

Get the meeting rooms in a specific room list

This operation marks an email as read/u­nread.

This operation moves an email to the specified folder within the same mailbox.

This operation replies to an email.

Respond to an event invite.

This operation sends an email message.

This operation sends an email from a shared mailbox. Your account should have permission to access the mailbox for this operation to succeed.

Set the automatic replies setting for your mailbox.

This operation updates a contact in a contacts folder.

This operation updates an event in a calendar using Graph API.

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

This operation retrieves all items from an RSS feed.

This operation adds a user to a tags.

This operation adds a member to a team.

This operation is used to create a new channel for a specific Team.

This operation creates a one on one or group chat

This operation creates a tag.

This operation a creates a new team.

Create a meeting with a link at the bottom of the invite to join the meeting online on Teams

This operation deletes a member from a tag.

This operation deletes a tag.

This operation returns details for a team using the team's unique ID.

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.

This operation creates a token that can be inserted into a message or adaptive card to @mention a user.

This operation gets details of a message in a chat or a channel.

This operation is used to get messages from a channel in a specific Team.

This operation retrieves a list of tags.

This operation retrieves a list of all the channels for a specific Team.

This operation retrieves a list of recent chats.

This operation list members based on a threadtype (chat, channel, etc).

This operation retrieves a list of all the Teams (Office 365 Groups) you are a member of.

This operation lists the members for a tag.

This operation posts a feed notifi­cation.

This operation posts a card to a chat or a channel.

This operation posts a message to a chat or a channel.

This operation replies with a message in a channel.

This operation replies with an adaptive card to a channel.

This operation updates an existing adaptive card.

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

This action retrieves a form response

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

Create a new row in a table in a Power Platform enviro­nment

Delete a row from a table in a Power Platform enviro­nment

Retrieve file or image data from a row in a Power Platform enviro­nment

Get a row from a table in a Power Platform enviro­nment

List rows from a table in a Power Platform enviro­nment

Run a Dataverse action bound to a table in a Power Platform enviro­nment, including custom actions

Run a global Dataverse action in a Power Platform enviro­nment, including custom actions

Associate individual rows in tables that have a one-to­-many or many-t­o-many relati­onship in the same Power Platform enviro­nment

Remove the associ­ation between individual rows in a Power Platform enviro­nment

Update file or image content in a row in a Power Platform enviro­nment

Update or add (upsert) a row in a table in a Power Platform enviro­nment

User comment

Set rules and manage the course of the flow

Exits current subflow and returns to the point it was called from

Retrieves the last error that occurred in the flow

Transfers the flow of execution to another point, indicated by a label

Acts as the destin­ation of a 'go to' statement

Marks the beginning of a block to handle actions errors

Run a subflow specifying any required arguments

Terminates the flow

Suspends the execution of the flow for a specified amount of seconds

Marks the beginning of a group of actions

Marks the end of a group of actions

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.

Marks the beginning of a condit­ional block of actions depending on whether a file exists or not

Suspend the execution of the automation until a file is created or deleted

Copy one or more files into a destin­ation folder

Move one or more files into a destin­ation folder

Delete one or more files

Change the name of one or more files

Read the contents of a text file

Write or appends text to a file

Read a CSV file into a data table

Write a data table, data row or list to a CSV file

Retrieve one or more parts (direc­tory, filename, extension etc) from a text that represents a file path

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 a file to Base64 encoded text

Convert a Base64 encoded text to file

Convert a file to binary data.

Convert binary data to file.

Retrieves email messages from an IMAP server

Moves, deletes or marks as unread an email (or a list of emails) retrieved by a Retrieve emails action

Creates and sends a new email message

Open a new connection to an Exchange server

Retrieve email messages from the specified Exchange server

Create and send a new email message

Move, delete or mark as unread an email message (or a list of email messages)

Launch Outlook and create a new Outlook instance

Retrieve email messages from an Outlook account

Create and send a new email message through Outlook

Move or deletes an email (or a list of email messages) retrieved by a 'Retrieve emails from Outlook' action.

Save Outlook email messages given an account

Respond to an Outlook message, by replying, replying to all or forwarding it

Close a previously launched Outlook instance

Resizes a selection of columns or rows in the active worksheet of an Excel instance

Runs a specified macro on the document of an Excel instance

Retrieves an Excel document's active worksheet

Retrieves all worksheet names of an Excel document

Deletes a specific worksheet from an Excel instance

Renames a specific worksheet of an Excel instance

Activate a cell in the active worksheet of an Excel instance, by providing column, row and offset

Selects a range of cells in the active worksheet of an Excel instance

Retrieve the selected range of cells in a structure consisting of first column, first row, last column and last row

Copies a range of cells from the active worksheet of an Excel instance

Pastes a range of cells to the active worksheet of an Excel instance

Deletes a cell or a range of cells from the active worksheet of an Excel instance

Inserts a row above a selected row of an Excel instance

Deletes a selected row from an Excel instance

Inserts a column to the left of a selected column of an Excel instance

Deletes a selected column from an Excel instance

Finds text and replaces it with another in the active worksheet of an Excel instance

Retrieve the first free row, given the column of the active worksheet

Copies a worksheet from an Excel document and paste it to the Excel document of the same or different Excel instance

Reads the formula inside a cell in Excel

Retrieves the range of a table in the active worksheet of an Excel instance

Auto fills a range with data, based on the data of another range, in the active worksheet of an Excel instance

Appends a range of cells to the active worksheet of an Excel instance

Finds and returns the result of Excel's LOOKUP function

Fills the background of the selected cells with the specified color, in the active worksheet of an Excel instance

Launches a new Excel instance or opens an Excel document

Attaches to an Excel document that's already open

Reads the value of a cell or a range of cells from the active worksheet of an Excel instance

Get the active cell in the active worksheet of the Excel document

Saves a previously launched Excel instance

Writes a value into a cell or a range of cells of an Excel instance

Closes an Excel instance

Activates a specific worksheet of an Excel instance

Adds a new worksheet to the document of an Excel instance

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

Gets the name of the column

Clears a range of cells or a named cell in the active worksheet of an Excel instance

Sort cells based on one or more columns in an Excel worksheet

Applies filters on a specified column in an Excel worksheet

Clear filters on a specified column in an Excel worksheet

Get empty cell

Displays a message box

Displays a dialog box that prompts the user to enter text

Displays a dialog box that prompts the user to enter a date or date range

Displays a dialog box with options that lets the user select from a list

Displays the select file dialog and prompts the user to select one or more files

Displays the select folder dialog and prompts the user to select a folder

Display a customized form that can include multiple types of elements, like text, number or file inputs etc.

Adds (or subtracts) a specific number of seconds, minutes, hours or days to a datetime value

Finds the time difference between two given dates in days, hours, minutes, or seconds

Retrieves the current date or the current date and time

Executes a DOS command or console applic­ation in invisible mode and retrieves its output upon completion

Executes some custom VBScript code and retrieves its output into a variable

Executes some custom JavaScript code and retrieves its output into a variable

Executes some custom PowerShell script and retrieves its output into a variable

Executes Python 2 script code and retrieves its output

Executes a user provided .NET script and stores its output in variables.

This action establ­ishes a specific connection to a remote FTP server, and stores that connection as a variable for later use.

This action returns the subdir­ect­ories and files contained in the current directory of an 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

This action closes an open FTP connection

This action sets the current working directory for an FTP connection

Downloads one or more files from an FTP server

Downloads one or more folders from an FTP server

Uploads one or more files to an FTP server

Uploads one or more folders to an FTP server

Deletes one or more files from an FTP server

Renames a file that resides on an FTP server

Creates a directory on an FTP server

Deletes a directory from an FTP server

Invokes the given literal FTP command on the server

Synchr­onize the files and subdir­ect­ories of a given Folder with a given remote FTP directory

Create an EC2 client to automate EC2 web services

Dispose an open EC2 client

Start EC2 instan­ce(s)

Stop EC2 instan­ce(s)

Reboot EC2 instan­ce(s)

Get inform­ation for the relevant EC2 instances

Returns all the inform­ation for the specified EC2 instan­ce(s)

Create a snapshot of an EBS volume and stores it in Amazon S3

Describes the specified EBS snapshots available

Delete the specified snapshot

Create an EBS volume

Attach an EBS volume to an EC2 instance

Detach an EBS volume from an EC2 instance

Describe the specified EBS volumes

Delete the specified EBS volume

Creates a user in the Active Directory

Gets a user's inform­ation in the Active Directory

Modify a user in the Active Directory

Unlocks an Active Directory user

Updates a user's inform­ation in the Active Directory

Open a new terminal session

Close an open terminal session

Move the terminal's cursor on the specified position

Get text from a terminal session

Set text on a terminal session

Send a control key to a terminal session

Wait for a specific text to appear on a terminal session

Search for all occurr­ences of a specific text on a terminal session

Invokes the IBM service named 'Convert Document'

Invokes the IBM service named 'Classify Image'

Invokes the IBM service named 'Trans­late'

Invokes the IBM service named 'Identify Language'

Invokes the IBM service named 'Analyze Tone'

Indicates to the orches­trator that the machine is ready to process one or more work queue items, if available

Updates the status and processing result of a specific work queue item

Add a work queue item into a work queue

Requeue a work queue item and delay it until a specified date and time

Adds one or more work queue items to a work queue based on the data provided in the work queue item data table

Updates the processing notes of a specific work queue item

Retrieves one or more work queue items based on FetchXML filtering expres­sions

This operation copies a file within OneDrive.

This operation copies a file within OneDrive by path.

This operation creates a file.

This operation creates a share link for a file.

This operation creates a share link for a file using the path.

This operation deletes a file.

This operation extracts an archive file into a folder (example: .zip). Maximum archive size is 50 MB and 100 files inside.

This operation finds files within a folder using search or name pattern match.

This operation finds files within a folder by path using search or name pattern match.

This operation gets the content of a file.

This operation gets the content of a file using the path.

This operation gets the metadata for a file.

This operation gets the metadata of a file using the path.

This operation gets the thumbnail of a file. The thumbnail will only be valid for 6 hours.

This operation gets the list of files and subfolders in a folder.

This operation gets the list of files and subfolders in the root folder.

This operation moves or renames a file.

This operation moves or renames a file using the path.

This operation updates a file.

This operation uploads a file from a URL to OneDrive.

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

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

Add a key column to an Excel table. The new column will be appended to the right.

Add a new row into the Excel table.

Create a new table in the Excel workbook.

Create a new worksheet in the Excel workbook.

Delete a row using a key column.

Get a row using a key column.

Get a list of tables in the Excel workbook.

Get a list of worksheets in the Excel workbook.

List rows present in a table.

Runs an Office Script against an Excel workbook. Use this action when the script is saved in the default location.

Runs an Office Script against an Excel workbook. Use this action when the script is saved outside of the default location.

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.

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

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

This operation copies a file within OneDrive.

This operation copies a file within OneDrive by path.

This operation creates a file.

This operation creates a share link for a file.

This operation creates a share link for a file using the path.

This operation deletes a file.

This operation extracts an archive file into a folder (example: .zip). Maximum archive size is 50 MB and 100 files inside.

This operation finds files within a folder using search or name pattern match.

This operation finds files within a folder by path using search or name pattern match.

This operation gets the content of a file.

This operation gets the content of a file using the path.

This operation gets the metadata for a file.

This operation gets the metadata of a file using the path.

This operation gets the thumbnail of a file. The thumbnail will only be valid for 6 hours.

This operation gets the list of files and subfolders in a folder.

This operation gets the list of files and subfolders in the root folder.

This operation moves or renames a file.

This operation moves or renames a file using the path.

This operation updates a file.

This operation uploads a file from a URL to OneDrive.

This operation adds a tag to a file

This operation gets the tags of a file

This operation removes a tag from a file