activities
latest
false
- Overview
- Excel
- Release Notes
- About the Excel activity package
- Project Compatibility
- Supported character encoding
- Project Settings
- Add or Update Excel Sensitivity Label
- 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 Cell Color
- Get Excel Chart
- Get Excel Sensitivity Label
- Get Selected Range
- Insert Column
- Insert Chart
- Insert Rows
- Insert Sheet
- Invoke VBA
- 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
- Select Range
- Sort Range
- Text to Columns
- Unprotect Sheet
- Update Excel Chart
- Use Excel File
- VLookup
- Write Cell
- Write CSV
- Write DataTable to Excel
- 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
- Google Workspace
- Release notes
- About the Google Workspace activities package
- Project compatibility
- Wait for Calendar Event Created and Resume
- Wait for Calendar Event Received and Resume
- Wait for Calendar Event Replied and Resume
- Wait for Calendar Event Updated
- Wait for Email Received and Resume
- Wait for Email Sent and Resume
- Wait for File Created and Resume
- Wait for File Updated and Resume
- Wait for Folder Created and Resume
- Wait for Sheet Created and Resume
- Wait for Sheet Cell Updated and Resume
- Wait for Task Created and Resume
- Wait for Task Completed and Resume
- 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
- Mail
- Microsoft 365
- Release notes
- About the Microsoft 365 activity package
- Working With Spreadsheet templates
- Batching API calls for performance improvements
- Microsoft 365 output object properties
- Project compatibility
- Connections
- AddEmailCategories
- ArchiveEmail
- DeleteEmail
- DownloadEmail
- DownloadEmailAttachment
- DownloadEmailAttachments
- ForwardEmail
- GetEmail
- GetEmailAttachmentsInfo
- GetEmails
- GetMailFolders
- GetNewestEmail
- MarkEmailAsRead
- MarkEmailAsUnread
- MoveEmail
- RemoveEmailCategories
- ReplyToEmail
- SendEmail
- TurnOffAutomaticReplies
- TurnOnAutomaticReplies
- 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 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
- Authentication troubleshooting
- AADSTS50011: Redirect URI mismatch
- AADSTS50076: Using multifactor authentication
- AADSTS50079: The user is required to use multifactor authentication
- AADSTS500113: No reply address registered for the application
- AADSTS65001: The user or administrator has not consented to use the application
- AADSTS7000218: The request body must contain the following parameter: client_assertion or client_secret
- AADSTS70002: InvalidClient - Error validating the credentials
- AADSTS50055: The password is expired
- AADSTS700082: The refresh token has expired due to inactivity
- AADSTS50194: Application is not configured as a multitenant application
- Mail troubleshooting
- Calendar troubleshooting
- Files troubleshooting
- Sheets troubleshooting
- Presentations
- Release Notes
- About the Presentations activity package
- Project Compatibility
- Add or Update Powerpoint Sensitivity Label
- Add Data Table to Slide
- Add File to Slide
- Add Image or Video to Slide
- Add New Slide
- Add Text to Slide
- Copy Paste Slide
- Delete Slide
- Format Slide Content
- Get Powerpoint Sensitivity Label
- Replace Text in Presentation
- Paste Item Into Slide
- Run Presentation Macro
- Save PowerPoint File As
- Save Presentation as PDF
- Use PowerPoint Presentation
- Word
- Release Notes
- About the Word Activities Package
- Project Compatibility
- Word Application Scope / Use Word File
- Add or Update Word Sensitivity Label
- Add Hyperlink to Document
- Add Picture
- Append Text
- Get Word Sensitivity Label
- Insert DataTable in Document
- Paste Chart/Picture Into Document
- Read Text
- Replace Picture
- Replace Text in Document
- Save Document As
- Save Document as PDF
- Set Bookmark Content
Productivity Activities
Last updated Nov 21, 2024
Microsoft 365 output object properties
This table lists all available properties exposed for output variables in the Microsoft 365 activities.
| Object | Property | Type | Description |
|---|---|---|---|
O365EventItem | Account | String | The user who owns the event as an email address |
| AllAttendeesEmailList | String | The list of all attendees emails as strings separated by semicolons | |
| AllAttendeesExceptMeEmailList | String | All attendees except me email list | |
| AllowNewTimeProposals | Boolean | Allows attendees to propose new meeting times | |
| Attendees | IEnumerable<string> | Attendee list | |
| AttendeesEmailList | IEnumerable<string> | Attendees email addresses | |
| AttendeesPlusOrganizer | IEnumerable<string> | Attendee list, plus the organizer | |
| Body | EventBody | The event body | |
| BodyPreview | String | A short preview of the event body | |
| Categories | IEnumerable<string> | The categories the event belongs to | |
| CreatedDateTime | DateTimeOffset | Created datetime | |
| End | DateTimeTimeZone | End time | |
| EndDateTime | DateTime | End date | |
| HasAttachments | Boolean | True if has attachments | |
| HideAttendees | Boolean | True if it hides attendees. | |
| ICalUId | String | ICal event id | |
| Id | String | The id of the event | |
| Importance | String | Event importance | |
| IsAllDay | Boolean | True if this is an all day event | |
| IsCancelled | Boolean | True if cancelled | |
| IsDraft | Boolean | True if it is a draft | |
| IsOnlineMeeting | Boolean | True if it is an online meeting | |
| IsReminderOn | Boolean | True if reminders are on | |
| LastModifiedDateTime | DateTimeOffset | Last modified datetime | |
| Location | String | Event location | |
| OccurrenceId | String | Occurrence master Id | |
| OnlineMeetingProvider | String | Online meeting provider name | |
| OnlineMeetingUrl | String | Meeting url | |
| OptionalAttendeesEmailList | String | Optional attendees email list | |
| Organizer | User | Event organizer | |
| OrganizerAddress | String | Event organizer address | |
| OrganizerName | String | Event organizer name | |
| Recurrence | String | Recurrence | |
| ReminderMinutesBeforeStart | Integer | Reminder (minutes) before start | |
| RequiredAttendeesEmailList | String | Required attendees email list | |
| RequiredAttendeesExceptMeEmailList | String | Required attendees except me email list | |
| ResourceAttendeesEmailList | String | Resource attendees email list | |
| ResponseRequested | Boolean | True if a response has been requested by the event organizer | |
| Sensitivity | String | Event sensitivity | |
| SeriesMasterId | String | Series master id. | |
| ShowAs | String | Show as | |
| Start | DateTimeTimeZone | Start time | |
| StartDateTime | DateTime | Start date | |
| Subject | String | Event title/subject | |
| Type | String | The type of the event | |
| WebLink | String | The weblink |
| Onject | Property | Type | Description |
|---|---|---|---|
|
Represents a remote O365 file/folder. Inherits
IRemoteResource.
| CreationDate | DateTime | Creation date and time |
| Extension | String | File extension | |
| FullName | String | Full name of the resource | |
| IsFolder | Boolean | True if the resource is a folder | |
| LastModifiedDate | DateTime | Last modified date and time | |
| Created by | DriveItemIdentitySet | Returns the identity of the user, device, or application which created the item. | |
| Created by {display name} | String | Returns the DisplayName of the user, device, or application which created the item. | |
| Created by {ID} | String | Returns the ID of he user, device, or application which created the item. | |
| Last modified by | String | Returns the identity of the user, device, or application which last modified the item. | |
| Last modified by {display name} | String | Returns the DisplayName of the user, device, or application which lsat modified the item. | |
| Last modified by {ID} | String | Returns the ID of he user, device, or application which lsat modified the item. | |
| Name | String | Name of the resource | |
| ParentUri | String | Returns the Url of the parent folder. The parent Url of the root folder is null. | |
| Uri | String | Web url of the resource. Deprecated. Use Url instead. | |
| Url | String | Web url of the resource. |
| Object | Property | Type | Description |
|---|---|---|---|
O365DriveLocalItem,
O365AttachmentLocalItem,
O365MailLocalItemLocal representation of a One Drive/SharePoint file. Inherits
ILocalResource.
| CreationDate | DateTime | Creation date and time |
| Extension | String | File extension | |
| FullName | String | Full name of the resource | |
| IsFolder | Boolean | True if the resource is a folder | |
| LastModifiedDate | DateTime | Last modified date and time | |
| Name | String | Name of the resource |
| Object | Property | Type | Description |
|---|---|---|---|
Office365Message | AttachmentCount | Integer | The total number of attachments of the current email |
| Attachments | AttachmentCollection | Deprecated | |
| AttachmentsInfoList | List | The attachment's info. | |
| AttachmentsNamesList | IEnumerable<String> | The names of all attachments of the current email | |
| Bcc | MailAddressCollection | Gets the address collection that contains the blind carbon copy (BCC) recipients for this email message | |
| Body | String | Gets or sets the message body | |
| BodyAsHtml | String | The Html version of the email, if available | |
| BodyPreview | String | Gets the body preview | |
| Categories | String | Contains the categories of the message | |
| CC | MailAddressCollection | Gets the address collection that contains the carbon copy (CC) recipients for this email message | |
| Flag | FollowupFlag | Gets the flag | |
| FromAddress | String | From address for this email message | |
| FromDisplayName | String | From display name for this email message | |
| Importance | Importance | Gets the importance | |
| InlineAttachmentCount | Integer | The number of inline attachments of the current email | |
| InlineAttachmentNames | IEnumerable<String> | The names of inline attachments of the current email | |
| InternetMessageId | String | Gets the Internet Message ID | |
| IsRead | Boolean | Gets a value indicating whether the instance is read | |
| LastModifiedDateTime | DateTime | Gets the last modified date time | |
| MessageId | String | The Office 365 ID of the message | |
| ParentFolderId | String | Gets the parent folder identifier | |
| Priority | MailPriority | Gets or sets the priority of this email message | |
| ReceivedDateTime | DateTime | Gets the received date time | |
| ReplyTo | MailAddress | Deprecated | |
| ReplyToList | IEnumerable<string> | Gets the list of addresses to reply to for the mail message | |
| SenderAddress | String | Sender's address for this email message | |
| SenderDisplayName | String | Sender's display name for this email message | |
| SentDateTime | Date | Gets the send date time | |
| StandardAttachmentCount | Integer | The number of standard attachments of the current email | |
| StandardAttachmentNames | IEnumerable<string> | The names of standard attachments of the current email | |
| Subject | String | Gets or sets the subject line for this email message | |
| SubjectEncoding | N/A | N/A | |
| To | MailAddressCollection | Gets the address collection that contains the recipients of this email message | |
| WebLink | String | Gets the web link |
