- 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
- Filter Excel files by cell color
- 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
- Project settings
- Google Workspace HTTP Request
- Archive Email
- Delete Email
- Download Email
- Download Email Attachments
- Get Email List
- For Each Email
- Forward Email
- Get Email by ID
- Get Newest Email
- Mark Email as Read/Unread
- Move Email
- Reply to Email
- Send Email
- Apply Gmail Labels
- Remove Gmail Labels
- Get Single Gmail Label
- Get Gmail Labels List
- Turn On Automatic Replies
- Turn Off Automatic Replies
- 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 and Resume
- 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 Row Added to the Bottom of a Sheet
- 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
- Release Notes
- New Outlook impact on UiPath Outlook Desktop activities
- Project compatibility
- Microsoft 365
- Release notes
- About the Microsoft 365 activity package
- Project compatibility
- Project settings
- Wait for Email Sent and Resume
- Wait for Email Received and Resume
- 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 and Resume
- Wait for File Created and Resume
- Wait for File Updated and Resume
- Wait for Worksheet Created and Resume
- Wait for Cell in Worksheet Updated and Resume
- Wait for Row Added to the Bottom of a Table and Resume
- Wait for List Item Added and Resume
- Wait for List Item Updated and Resume
- 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
- Find Meeting Times
- Get Mail
- Move Mail
- Send Mail
- Reply to Mail
- Delete Mail
- Set Mail Categories
- Add Attachment
- Add Attendee
- Add Location
- Create Event
- Delete Event
- 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
New Outlook impact on UiPath Outlook Desktop activities
Starting with August 1, 2024, Microsoft has made available the new Outlook as a replacement for classic Outlook. Switching to the new Outlook application breaks compatibility with the UiPath Outlook Desktop activities and the Use Outlook 365 activity.
The issue occurs because Microsoft, as a third-party service provider, has removed the Outlook Desktop COM API from the new Outlook. While the COM API is still available in the classic version of Outlook, UiPath Outlook Desktop activities depend on it to work.
The change impacts the following activities:
- Use Outlook 365
- Delete Outlook Desktop Mail Message
- Get Outlook Desktop Mail Messages
- Mark Outlook Desktop Mail Message As Read/Unread
- Move Outlook Desktop Mail Message
- Outlook Desktop Mail Message Trigger
- Reply To Outlook Desktop Mail Message
- Save Outlook Desktop Mail Message
- Send Outlook Desktop Mail Message
- Set Outlook Desktop Mail Message
The following Gmail and Outlook activities also work with O365, and are only impacted when used inside the Use Desktop Outlook App activity:
- Archive Email
- Delete Email
- For Each Email
- Forward Email
- Get Email By Id
- Mark Email As Read/Unread
- Move Email
- Reply To Email
- Save Email
- Save Email Attachments
- Send Calendar Invite
- Send Email
- Use Desktop Outlook App
- Use Gmail
- Use Outlook 365
According to Microsoft, classic Outlook is expected to remain functional until around August 2027. As a result, you can still use the classic version until Microsoft plans to completely remove it. For more details, check Communications between stages.
As a temporary solution, you are advised to keep using classic Outlook with your automations, and not upgrade to the new Microsoft Outlook version.
If you want to use the new Outlook, you must manually migrate your existing Outlook Desktop activities to the Microsoft 365 activities.
If you accidentally upgrade Outlook, you can still revert to the classic version by disabling the new Outlook. For more details, check Toggle out of the new Outlook for Windows.
For questions or issues with toggling out of the new Outlook, contact Microsoft.
Microsoft 365 activities automate Outlook through the Microsoft Graph API, which is the recommended approach to automate Outlook moving forward.
If you decide to migrate your Outlook Desktop activities to Microsoft 365 activities, follow these recommendations:
General recommendations
- If you use Studio Web, use the Outlook activities that also use the Integration Service connection. Make sure you have access to Integration Service.
- If you use Studio Desktop and:
- have access to Automation Cloud, use the Integration Service connection. Make sure you have access to Integration Service.
- cannot use Automation Cloud, use Automation Suite version 2024.10, which supports Integration Service.
- If you use Studio Desktop with either a standalone Orchestrator or an Automation Suite version older than 2024.10, and cannot upgrade to Automation Cloud or Automation Suite 2024.10, it is recommended to use the Outlook activities together with the Microsoft 365 Scope activity. For more details, check How to use Microsoft 365 activities without Integration Service connections.
-
If the Outlook application is connected to a different server than Microsoft 365, alternatively, you can use one of the following activities:
- Exchange
- SMTP, IMAP, or POP3
- Google Workspace, if you are connected to a Gmail server.
Authentication recommendations
Use the OAuth 2.0 Authorization code, because it impersonates a user, and allows the connection to have access only to that particular user. For more details, check Microsoft identity platform and OAuth 2.0 authorization code flow.
- For Integration Service, use the OAuth 2.0 Authorization code.
- For Microsoft 365 Scope, use the Interactive token.
Alternatively, you can use the OAuth 2.0 client credentials authentication method. This is also referred to as a service account that can have access to a wide range of mailboxes.
- For Integration Sservice, use the OAuth 2.0 client credentials. To restrict the service account, specify in the Account field of the connection configuration page the mailbox it should access.
- For Microsoft 365 Scope, use the Application ID and Secret or Application ID and Certificate. To restrict the service account to a particular mailbox to impersonate, specify the account in the Impersonated User Email Address field of the Microsoft 365 Scope activity.
The following table shows which Microsoft 365 activities correspond to Outlook activities:
| Outlook Desktop activities | Microsoft 365 activities | Notes |
|
Send Email or Forward Email | Microsoft 365 does not support sensitivity labels. |
| Download Email and Move File, to specify the location. | Download Email does not support specifying the mail message format, such as .msg, .oft, .html, .mht.
|
| Reply to Email |
N\A |
| Get Email List, For Each Email , or Get Email by ID. |
The filters may differ, as the Microsoft 365 activities use a different filter mechanism. For example, you cannot sort by date. |
|
Outlook: Delete Outlook Mail Messages | Delete Email |
N\A |
| Mark Outlook Mail As Read/Unread | Mark Email as Read or Unread |
N\A |
| Mark Email as Read or Unread | Move Email |
N\A |
| Set Outlook Mail Categories | Set Email Categories |
N\A |
| Outlook Mail Message trigger | Email Received |
Note: Triggers work only if you have access to Integration Service.
|
| Save Attachments | Download Email Attachments and Move File, to specify the location. |
N\A |
Microsoft 365 activities enhance the user experience by providing intuitive design-time tools like folder pickers, filter builders, and dynamic dropdowns. These features make it easier even for users with limited technical knowledge to build automations.
In addition, you can manage out-of-office settings or create more complex long-running workflows with the help of Wait for Events and Email Sent triggers.
Microsoft 365 activities are compatible with cross-platform projects, enabling a seamless transition to cloud and serverless environments. This can lead to reduced infrastructure costs and lower dependency on Microsoft Office licenses.
