Activities
latest
false
Activities - Other latest
logo
Productivity Activities
Last updated 2023年12月6日

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

Create Event

Adds an event to the indicated Outlook calendar.

Delete Event

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

For Each Event

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

Forward Event

Forwards an event to all specified attendees.

Respond To Event Invitation

Defines a reply to an event invitation.

Update Event

Updates the properties of the chosen event.

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

Trigger: Calendar Event Created

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

Trigger: Calendar Event Received

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

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

Excel Online activities

Activity

Description

Add Sheet

Adds a sheet to the specified Excel workbook.

Create Workbook

Creates a new Excel workbook.

Delete Range

Deletes a cell range from the specified Excel workbook.

Delete Sheet

Deletes a sheet from the specified Excel workbook.

For Each Row in Workbook

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

For Each Sheet in Workbook

Iterates through the sheets within a workbook.

Read Cell

Reads information from the indicated Excel workbook cell.

Read Range

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

Rename Sheet

Renames a sheet from the specified Excel workbook.

Write Cell

Writes information in the indicated Excel workbook cell.

Write Range

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

Write Row Write a row in a selected workbook file using an Array Row or a Data Row.
Write Column Write a column in a selected Excel file using an Array Column or a Data Column.
Delete Rows Delete one or several rows from a specified position in a Workbook range. When you delete a row, the cells below are shifted up.
Delete Column Delete 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

Trigger: File Created

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

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

Copy File/Folder

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

Create Folder

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

Delete File/Folder

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

Download File

Downloads a specified file to a local folder.

For Each File/Folder

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

Get File List

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

Get File/Folder

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

Move File/Folder

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

Share File/Folder

Shares a file or folder with the specified recipients.

Upload Files

Uploads files to a specified OneDrive or SharePoint location.

Outlook activities

Activity

Description

Trigger: Email Sent

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

Trigger: Email Received

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

Archive Email

Archives a specified email.

Delete Email

Deletes a specified email.

Download Email

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

Download Email Attachments

Downloads the specified email attachments to a local folder.

For Each Email

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

Forward Email

Forwards a specified email to new recipients.

Get Email By Id

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

Get Newest Email

Returns the most recent email that matches the search criteria.

Mark Email as Read/Unread

Marks an email as read or unread.

Move Email

Moves an email to a folder within the same mailbox.

Reply to Email

Replies to a specific email.

Send Email

Sends an email message.

Set Email Categories

Assigns categories to an email.

Get Email List

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

SharePoint activities

Activity Description
Get List Items Retrieve SharePoint List Items from the specified list.
Add List Item

Add an item to a SharePoint List.

Delete List Items Retrieve a single SharePoint list item from the specified list.
Get Single List Item Retrieve a single SharePoint list item from the specified list.
Update Single List Item Update item to 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).

logo
Get The Help You Need
logo
Learning RPA - Automation Courses
logo
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2023 UiPath. All rights reserved.