- Release Notes
- About the Excel Activities Package
- Project Compatibility
- Project Settings
- Use Excel File
- Append Range
- Auto Fill
- Autofit Range
- Change Pivot Data Source
- Clear Sheet/Range/Table
- Copy/Paste Range
- Create Pivot Table
- Delete Column
- Delete Rows
- Delete Sheet
- Duplicate Sheet
- Export to CSV
- Fill Range
- Filter
- Filter Pivot Table
- Find First/Last Data Row
- Find/Replace Value
- For Each Excel Row
- For Each Excel Sheet
- Format As Table
- Format Cells
- Get Excel Chart
- Insert Column
- Insert Chart
- Insert Rows
- Insert Sheet
- Lookup
- Match Function
- Protect Sheet
- Read Cell Formula
- Read Cell Value
- Read Range
- Refresh Excel Data Connections
- Refresh Pivot Table
- Remove Duplicates
- Rename Sheet
- Run Spreadsheet Macro
- Save Excel File
- Save Excel File As
- Save Excel File As PDF
- Sort Range
- Text to Columns
- Unprotect Sheet
- Update Excel Chart
- VLookup
- Write Cell
- Write DataTable to Excel
- Get Cell Color
- Invoke VBA
- Excel Application Scope
- Append To CSV
- Read CSV
- Write CSV
- Delete Column
- Filter Table
- Get Table Range
- Insert Column
- Sort Table
- Append Range
- Close Workbook
- Get Cell Color
- Read Cell
- Read Cell Formula
- Read Column
- Read Range
- Read Row
- Select Range
- Set Range Color
- Write Cell
- Write Range
- Save Workbook
- Create Table
- Get Workbook Sheet
- Get Workbook Sheets
- Refresh Pivot Table
- Create Pivot Table
- Get Selected Range
- Copy Sheet
- Delete Range
- Auto Fill Range
- Copy Paste Range
- Execute Macro
- Insert/Delete Columns
- Insert/Delete Rows
- Invoke VBA
- LookUp Range
- Remove Duplicates Range
- Excel Process Scope
- Manage CSV Files
- Filter CSV Files
- Verify CSV Files
- Table Functions
- Manage Multiple Excel Files
- Interpret Excel Results
- Manage Pivot Tables
- Manage Range Selection
- Read From Excel Files
- Manage Databases in Excel
- Compare CSV Files
- Compare Numeric Values
- Sort Data in Excel Files
- Filter and Delete Rows in Excel Files
- Manipulate Range Selections
- Verify Excel Workbook Data
- Read, Write, and Append Data in Excel
- Release notes
- About the Google Workspace activities package
- Project compatibility
- GSuite Application Scope
- Add Attendee
- Create Event
- Delete Event
- Modify Event
- Search Events
- Use Google Drive
- Share File
- Delete File Permission
- Get File Permissions
- Update File Permission
- Copy File
- Create Folder
- Delete File
- Download File
- Find Files and Folders
- Get File Info
- Move File
- Upload File
- Create Document
- Create New Spreadsheet
- Get Mail Messages
- Send Mail Messages
- Change Labels
- Use Google Spreadsheet
- Add Delete Columns
- Add Delete Rows
- Auto Fill Range
- Add New Sheet
- Append Row
- Batch Spreadsheet Updates
- Copy Sheet
- Copy Paste Range
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Clear Range
- Download Spreadsheet
- Use Google Document
- Batch Document Updates
- Get Document
- Get Text Index
- Insert Text
- Replace Text
- Read All Text
- Create Script Project
- Get Project Content
- Upload Script File
- Create Deployment
- Run Script
- Release notes
- About the Microsoft 365 activities package
- Project compatibility
- Merge multiple sheets into a new summary Excel sheet
- Automatically accept calendar invites from your manager
- Move files to dedicated folders by type
- Verify if new employment documents (I9 and ID) match
- Add new customers to a SharePoint List
- Delete SharePoint List items newer than yesterday
- Notify me on Slack when an important Outlook Email is received
- Include creation date in new OneDrive file names
- Notify me by email when a new file is created
- Microsoft Office 365 Scope
- Add Sheet
- Append Range
- Clear Range
- Copy Range
- Copy Sheet
- Create Workbook
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Set Range Color
- Create Table
- Get Table Range
- Insert Column
- Delete Column
- Insert Rows
- Delete Rows
- VLookup Range
- Use OneDrive & SharePoint
- Copy File/Folder
- Create Folder
- Delete File/Folder
- Download File
- Export File as PDF
- Find Files And Folders
- Get File/Folder
- Move File/Folder
- Upload File
- Share File/Folder
- For Each File/Folder
- Forward Mail
- Get Mail
- Move Mail
- Send Mail
- Reply to Mail
- Delete Mail
- Set Mail Categories
- Add Attachment
- Add Attendee
- Add Location
- Create Event
- Delete Event
- Find Meeting Times
- Get Calendars
- Modify Event
- RSVP
- Search Events
- Create Group
- Delete Group
- Get Group
- List Groups
- Create Bucket
- Delete Bucket
- List Buckets
- List Bucket Tasks
- Create Plan
- Get Plan
- List Plans
- Create Task
- Delete Task
- Get Task
- List Tasks
- Update Task
- For Each List
- Get List Info
- For Each List Item
- Delete List Item
- Add List Items
- Update List Item
- Get List Items
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.
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 List | Retrieve 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 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 |
---|---|
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 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 |
---|---|
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. |
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
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:
- 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:
- Click the field with the Browse button to navigate to the root folder.
- Double-click to open the Outlook, OneDrive, or SharePoint parent folder and navigate to the specific item.
- 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
).