Activities

Overview

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

• Calendar
• Excel Online
• Files
• Outlook
• SharePoint List

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.
Get Event by ID	Retrieve an event by its ID.
Get Calendars	Retrieves a list of calendars.
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.
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:

• Microsoft Outlook 365 for Calendar and Outlook activities.
• Microsoft OneDrive & SharePoint for Excel and Files activities.

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