Activities
latest
false
Activities - Other latest
Banner background image
logo
Productivity Activities
Last updated Feb 16, 2024

Activities

Overview

The following tables list the cross-platform activities included in the Microsoft Office 365 activity package, under each category:

These activities are also available in Studio Windows projects.

Note: These activities use Integration Service connections.

Calendar activities

Activity

Description

Adds an event to the indicated Outlook calendar.

Cancels an Outlook calendar event and sends a cancellation notification to all event attendees.

Iterates through a list of calendar events defined by the filter criteria.

Forwards an event to all specified attendees.

Defines a reply to an event invitation.

Updates the properties of the chosen event.

Get Event ListRetrieve a list of calendar events defined by the filter criteria.

Executes an automation workflow when a new event is created in the selected user's calendar.

Executes an automation workflow when a new event invitation is received in the selected user's calendar.

Calendar Event RepliedExecutes an automation workflow when someone replies to a calendar event in the select user's calendar.
Calendar Event UpdatedExecutes an automation workflow when an event is updated in the selected user's calendar.

Excel Online activities

Activity

Description

Adds a sheet to the specified Excel workbook.

Creates a new Excel workbook.

Deletes a cell range from the specified Excel workbook.

Deletes a sheet from the specified Excel workbook.

Iterates through the rows in a specified range within a worksheet.

Iterates through the sheets within a workbook.

Reads information from the indicated Excel workbook cell.

Reads and saves the information from a specified Excel workbook cell range.

Renames a sheet from the specified Excel workbook.

Writes information in the indicated Excel workbook cell.

Writes a DataTable variable to a specified Excel workbook cell range.

Write RowWrite a row in a selected workbook file using an Array Row or a Data Row.
Write ColumnWrite a column in a selected Excel file using an Array Column or a Data Column.
Delete RowsDelete one or several rows from a specified position in a Workbook range. When you delete a row, the cells below are shifted up.
Delete ColumnDelete a specified column from a sheet, table or range. The column on the right of the deleted column is shifted to the left.

Files activities

Activity

Description

Executes an automation workflow when a new file is created in the specified OneDrive location.

Trigger: File UpdatedExecutes an automation workflow when a new file is updated in the specified OneDrive location.

Copies a file or folder to the specified destination folder in OneDrive or SharePoint.

Creates a folder at the specified location in OneDrive or SharePoint.

Deletes a file or folder from the specified location in OneDrive or SharePoint.

Downloads a specified file to a local folder.

Iterates through a list of files and folders from OneDrive or SharePoint.

Retrieves a list of files or folders from a specified OneDrive or SharePoint location.

Retrieves a file or folder from a specified OneDrive or SharePoint location.

Moves a file or folder to the specified destination folder in OneDrive or SharePoint.

Shares a file or folder with the specified recipients.

Uploads files to a specified OneDrive or SharePoint location.

Outlook activities

Activity

Description

Initiates an automation workflow when an email is sent in Outlook.

Initiates an automation workflow when a new email arrives in Outlook.

Archives a specified email.

Deletes a specified email.

Downloads a specified email to a local folder. The email is downloaded in the .eml file format.

Downloads the specified email attachments to a local folder.

Repeats the contained activities for each email matching the filter criteria.

Forwards a specified email to new recipients.

Retrieves an email with a specified unique identifier (ID).

Returns the most recent email that matches the search criteria.

Marks an email as read or unread.

Moves an email to a folder within the same mailbox.

Replies to a specific email.

Sends an email message.

Assigns categories to an email.

Retrieve a list of emails from the specified folder that matches the filter criteria.

SharePoint activities

ActivityDescription
Get List ItemsRetrieve SharePoint List Items from the specified list.
Add List Item

Add an item to a SharePoint List.

Delete List ItemsRetrieve a single SharePoint list item from the specified list.
Get Single List ItemRetrieve a single SharePoint list item from the specified list.
Update Single List ItemUpdate item to SharePoint list.
For Each List Item

Iterates through the items of a SharePoint list.

Using cross-platform activities

The activities in the cross-platform category are designed for cross-platform projects in Studio Web and Studio Desktop.

Connect to your Office 365 account

When you add an activity that interacts with an online application using an Integration Service connector, you must select the connection for the account to use in that activity.

Microsoft Office 365 activities use the following connectors:

Depending on whether or not connections are already set up in the Integration Service for the connector, one of the following may occur:

  • No connection exists - You are prompted to add a connection in the activity. From the connection drop-down, select Add new connection to start the authentication process and enable the required permissions. For more information, see the Integration Service documentation for the connector you want to use.
  • Connections already exist - Select a connection from the connection drop-down in the activity. The connection that is set as default is automatically selected. To add a new connection, select Add new connection from the drop-down.
  • A connection is selected but is invalid - If a connection is selected, but no additional properties are available in the activity, this indicates the connection is broken. From the connection drop-down, select Manage connections to go to the Integration Service and fix the connection.
Iterate through items with For Each activities

The For Each File/Folder, For Each Event, and For Each Email activities execute an activity or a series of activities for each file, event, file or folder, or email in a specified Outlook 365, OneDrive, or SharePoint location.

Add the activities to repeat inside the Body section of the For Each activities and, when you configure these activities, indicate that you want to process each item in the iteration by selecting the current item variable for that item:

  • CurrentEvent in the body of For Each Event.
  • CurrentItem in the body of For Each File/Folder.
  • CurrentEmail in the body of For Each Email.
Select the item to use in an activity

To indicate a specific file file, folder, calendar, or folder Excel workbook to use in an activity:

  1. Click the field with the Browse button to navigate to the root folder.
  2. Double-click to open the Outlook, OneDrive, or SharePoint parent folder and navigate to the specific item.
  3. Select the item and click Save.
Calendar activities

The Microsoft Office 365 Calendar cross-platform activities provide methods to manage your calendar events.

Set start and end dates and times

Activities such as Create Event or Update Event let you choose the start and end date and time of that particular event. To set a start or end date and time, click the calendar icon next to the field to open the calendar widget and select the date and time. Alternatively, click the Plus button menu to use a variable. In Studio Web, you can also use one of the predefined snippets (Today, Yesterday, Tomorrow, StartOfNextWeek, StartOfNextMonth, Now).

Excel activities

The Microsoft Office 365 Excel cross-platform activities provide methods to create, extract, and insert data into Excel cells, ranges, worksheets, and workbooks.

Range types

Activities such as Read Range, Write Range, and For Each Row in Workbook allow you use data from a specified range of cells in a workbook or worksheet.

There are several types of ranges that you can use: Range (named ranges whose scope is limited to a given worksheet), Table (Excel tables), Sheet (entire sheets), and Global Range (named ranges that are available for use throughout the workbook), or Default (which includes all the previous types and allows you to manually enter a custom range, e.g., Sheet1!A1:B6).
Support and Services icon
Get The Help You Need
UiPath Academy icon
Learning RPA - Automation Courses
UiPath Forum icon
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.