Release notes

Browse the release notes by clicking on the desired version in the table of contents on the right.

v2.7.24

Release date: November 6, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The Move Email activity failed to move emails when using a shared mailbox.

v2.7.23

Release date: October 31, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The Get Mail activity failed to retrieve emails due to incorrect metadata, such as invalid characters, associated with attachment contents.
• Before, when the Get Mail activity tried to retrieve a list of emails, and some emails threw an exception, while the rest were successful, it failed overall. Now, the activity retrieves the successful list of emails.

v2.7.22

Release date: 27 September 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• A design time exception occurred when trying to add a new account in Microsoft 365 Scope when OAuth Application was set to UIPATH.

v2.7.21

Release date: September 24, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Improvements

We have an improved activity override experience for working with files and folders. Before, when you configured an activity and selected a file or folder, we saved the connection ID and element ID. However, when you changed the connection used in a workflow, the element ID also changed, even if its path remained the same. We now save the full path of an element as a fallback mechanism, using the path to correctly identify a resource if the saved ID isn't valid.

In the Get File or Folder List and For Each File or Folder activities, you can now input files using the Relative path option. Note that the Relative Path method does not support personal OneDrive accounts.

You can now add items to a SharePoint list using DataRow variables in the Add List Item and Update Single List Item activities.

The Categories to assign field in the Set Email Categories activity now has an auto-complete dropdown menu, listing the user's available categories.

The Add Sheet activity now includes an If Sheet Already Exists field, to indicate the conflict resolution behavior in case a sheet with the same name already exists.

You can now use a free text filter in the Get File or Folder List activity. In addition to the standard filtering capabilities, you can now search for a list of files or folders containing a specific text.

We exposed the InternetMessageID property on Office365Message objects. You can also use this value as input in the Get Email by ID activity.

The Office365Message object now includes attachments metadata support. We added a new AttachmentsInfoList property which includes the following metadata: name, size, and extension (MIME type).

Working with SharePoint files and folders metadata

You can work with metadata using the new Get file or folder metadata and Update file or folder metadata activities.

You can filter files by metadata. In the Get File or Folder List activity, when using the advanced search option, you have a new Metadata filter option. This field populates dynamically if you select a document library as the file/folder source.

Working with scopes

It is now easier to identify the required scopes for working with Microsoft 365 activities. Each activity now includes a warning informing you of the scope(s) it needs to run properly. When you add an activity to your workflow, we automatically check if the connection you're using has the necessary permissions to perform said action.

Sensitivity labels

We are introducing support for sensitivity labels with two new activities: Assign Sensitivity Labels and Get Sensitivity Labels. Learn more about this feature in Working with sensitivity labels.

New activities

To improve your experience of working with SharePoint files, we added a new activity: File Check-in/Check-out.

Deprecations

Erratum – Added November 6, 2024 The Classic Find Files and Folders activity has been deprecated. Use For Each File or Folder instead.

Bug fixes

• When using the Folder path input method, identifying folders with slashes or backslashes in the name failed because the slash element was interpreted as a folder separator. You can now use HTML encoding for names (“%2F” instead of “/”).

v2.6.25

Release date: 12 August 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• This release brings updates to some dependencies for security reasons.

v2.6.24

Release date: 26 June 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Authentication using Microsoft 365 Scope via the Asset connection method failed because of scopes mismatch.
• Accessing files and folders in SharePoint was not possible when you only had access to specific subfolders, and not the full folder path. Before, you could select the file or folder at design time, but received an error at runtime because of access issues. Now you can retrieve items with no issues.

v2.6.23

Release date: 18 June 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The HTTP Request activity failed when used inside the Scope because authentication scopes could not be set. Now, when you add the HTTP Request activity inside Microsoft 365 Scope, a Required scopes field is displayed. This field allows you to add any additional scopes needed for running HTTP Request , other than the scopes defined in Microsoft 365 Scope.
• Erratum – Added October 1, 2024: To retrieve all emails when using a shared mailbox, you can leave the Email folder path empty or enter "*".

v2.6.22

Release date: 10 June 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Fixed an issue which caused the Row added to the bottom of a table trigger to fail.

v2.6.21

Release date: 14 May 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Coded workflows support

If you prefer to code when building automations, you can now achieve this using coded automations and UiPath services. The Microsoft 365 activity package now includes APIs that enable you to create automations for Outlook, OneDrive SharePoint Lists, and Excel using code. Visit Coded Automations to learn more about coded automations in UiPath Studio and Microsoft 365 APIs for the full list of supported APIs.

New activities

Calendar

Two new calendar activities are now available: Get Calendar by ID and Get Calendars.

HTTP Request

The new HTTP Request activity allows you to make requests to any endpoint of the Microsoft Graph API. This means you are no longer limited to the functionalities of our predefined activities, and you can access the full capabilities of Microsoft APIs. To use this activity, create a connection to the new Microsoft 365 connector.

New features and improvements

Outlook shared mailbox

This release introduces support for shared mailboxes for Outlook activities and triggers. This means you can retrieve emails from a shared mailbox, manage emails within a shared mailbox, and send, reply, or forward emails from within a shared mailbox.

You can also monitor events on shared mailboxes: the Email Received and Email Sent triggers support shared mailboxes.

Outlook shared calendars

The following Outlook triggers now support shared calendars: Calendar Event Created, Calendar Event Received.

General improvements

To support SharePoint list caching, we added a Reload SharePoint List option for the SharePoint List activities.

We exposed some new properties on DriveItem objects: CreatedBy and ModifiedBy, CreatedByUser and LastModifiedByUser.

The classic Upload File activity now includes a Checkin field, which enables you to check in the file after upload. If you use SharePoint libraries with version control, the uploaded file becomes visible only if you enable this checkbox.

We renamed the Browse input method from the context menu to Folder picker or File or folder picker, depending on activities. This change also impacts the Reload browser field, now renamed to Reload file/folder picker.

Microsoft 365 Scope improvements

We improved the Asset connection method by adding a Reload assets option. This allows you to reload your available assets in Orchestrator directly when setting up the connection.

The Asset connection method now supports all authentication types.

An Impersonated User Email Address field is now available, to be used for Application permissions. This field provides an impersonation account for modern activities used inside the Scope.

A Runtime connection assets field is now available, so that you can use different assets between design time and runtime. This means you can use a regular, unencrypted asset at design time, that allows you to configure the activity, then use a more secure asset at runtime. This can also be a credential-type asset. When you create a runtime asset of the credential type, you can enter any value for the username field.

Bug fixes

• Activities failed when using the Microsoft 365 Scope activity with Application ID and Secret authentication method, because the activity did not send the correct scope.
• An issue prevented you from retrieving the Importance property from an email (Office365Message) object.
• The Get File or Folder failed after upgrading to a newer version of the package.
• The Reply to Email activity failed when used with a shared mailbox, because the API call wrongly contained the main mailbox email.

v2.5.9

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Release date: 2 April 2024

Bug fixes

• The classic Add List Items activity failed after upgrading from specific package versions.
• The Write Row and Write Column activities failed to write data when using the What to write - Individual Fields options.

v2.5.8

Release date: 1 March 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Bindings created from root folders did not work. When selecting root drives using the Browse method, the ID returned was that of the drive, not of its root.

v2.5.7

Release date: 16 February 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Some activities were not able to load the OneDrive file picker if specific broken folders were present in the user's environment.
• The Get File and Folder activity failed to work in an override context if its configuration was upgraded from specific package versions.

v2.5.6

Release date: 2 February 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Fixed an issue which caused the Read Range activity to fail when used inside a For Each with a Send Email activity.

v2.5.5

Release date: 29 January 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

New features and improvements

On-prem support for connections

You can now use all the Microsoft 365 activities on-prem, even if you don't have Integration Service, through Microsoft 365 Application Scope. When added inside the Scope, the activities inherit connection information from it. To support this improvement, we also revamped the Scope activity to introduce an Asset connection method, which allows you to set up an asset in Orchestrator and use it to create a connection. Configuring the connection using the Properties panel is still supported.

Batching API calls for performance improvements

We introduced batching capabilities for some activities, to bypass the API response time limitation. For loops that continuously read or write, we batch API calls into one single call, to increase runtime performance. The loop activities that support batching are For each email, For each file or folder, For each row, and For each item list. The impacted activities are Send Email, Write row, Create event, Add List Item and Update Single List Item. Note that the Microsoft Graph API supports batching 20 requests at a time.

Dynamic DataTable improvements

A refresh tables mechanism is now available at activity level, with Update table and Update fields options for Read range, For each row, Write row, and Write column activities. With these options you can refresh the dynamic DataTable at design time after you add or modify a column in your sheets.

We added new dynamic DataTable worksheet metadata to the Read Range and Row added to the bottom activities: SheetRowIndex, [Name] Address, and [Name] ColumnAddress.

Columns generated through dynamic DataTables are available as simplified attributes in variables.

Simplified view for Studio Web

All the activities now support the Studio Web simplified view for output types. We also updated the curated shortlist of properties displayed for output objects, based on usage and priority.

We updated the properties available for output objects. For Office365Message, we added AttachmentsCount and AttachmentNames (replacing Attachments, which has been deprecated), ToAddressList, CCAddressList, and BCCAddressList. For O365EventItem, we added AttendeesEmailList.

We also added URL to object properties and deprecated URI.

Default values for folders, inbox, and calendars

We introduced default values for some fields in the activities. Your inbox is now the default folder on all email activities. For calendar activities and triggers, the user connection name is the default value for the Calendar field. For Drive and Excel Online activities and triggers, OneDrive is the default value for the In Location field. If you modify this default value, the next activity added in the workflow will automatically retrieve the latest user selection.

Other improvements

We added a new SharePoint List activity: For Each List Item.

You can now iterate through all the emails in Outlook, regardless of folders, by selecting All Mail in the folder browser.

Microsoft 365 activities can benefit from the updated Studio Web Test trigger feature. At design time, you can test the trigger, and Studio Web calls the activity and returns the object that triggers the event. This allows you to see all available object properties, and use these values further in the workflow.

We updated the names of output variables for all activities and triggers.

We also added additional filter operators to triggers, to enhance filtering capabilities.

We improved the error message for out of range scenarios, providing more clarity.

We implemented a retry mechanism on Get [object] activities to prevent file availability errors.

Errata

Added: 6 June 2024: This release also included two new Out of Office activities: Turn On Automatic Replies and Turn Off Automatic Replies. To use these new activities, you must reauthenticate to your Outlook connector, to authorize the required scope (MailboxSettings.ReadWrite).

Bug fixes

• Processes failed at runtime when using the Use OneDrive & SharePoint scope activity with an Integration Service connection.
• After migrating a process to another tenant and modifying user selections for the SharePoint site field, the SharePoint activities used the site initially configured on the first tenant. Now, after migration, the process uses the site configured on the new tenant.
• The Get or file or folder activity failed to appear under Package Requirements in Orchestrator when using the Relative file or folder path input option.
• The Classic Forward email activity sent the body message as plain text even when the Body as HTML option was selected.

• We have increased the limit for the maximum number of shared drives retrievable in an activity, from 100 to 500.

v2.4.3

Release date: 2 November 2023

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

Fixed a minor issue in the Get Newest Email activity.

v2.4.2

Release date: 30 October 2023

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

New features and improvements

For SharePoint Lists you can now manage Person lookup fields by a component of the reference value. In the Person type field, you can also add Person's email as string input.

New activities

This release introduces two new Excel Online activities: Delete Rows and Delete Column.

New Excel Online triggers

We are also expanding our trigger capabilities with three new Excel Online triggers: Cell in Worksheet Updated, Worksheet Created, and Row Added to the Bottom of a Table.

v2.3.3

Release date: 26 September 2023

The improved activities included in the latest release set the foundation stone for core automation use cases in Studio Web and Cross-platform. Continue reading to learn what's new in this release and how you can benefit from the most recent features.

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

General improvements

The folder picker in the Get File/Folder activity includes a new option: Relative path. You can now manage folders better by iterating through them and referencing parent folders and file/folders through relative paths. By doing this, you can dynamically parse recursively from the file to the parent’s parent folder and the whole folder hierarchy until the root.

All the Files and Excel activities include new options in the folder picker for specific fields: Enter ID and Enter URL.

The activity package supports the latest connection features for the Microsoft Outlook 365 and OneDrive connectors, which allow using Azure for Government.

We also restructured the hierarchy in the Browser widget for calendars, email folders, and OneDrive and SharePoint folders.

Activity caching

Sharing information between activities is important to achieve faster loading times. With this in mind, some caching improvements were introduced in this release.

Connection caching is also available. When you change the connection in an activity, the other activities in the workflow are reloaded with the new connection.

Activities which use calendars, email folders, and folders include a Reload browser option, which allows you to retrieve the latest data if you've performed any changes in your folders. For example, this option is available in For Each Event, Get File/Folder, Read Range, or Get Newest Email.

The Excel Online activities include two options that enhance caching: Update ranges and Update sheets. They allow you to retrieve the latest data from your spreadsheets without reselecting a file. You can find Update ranges, for example, in the For Each Row in Spreadsheet, Read Cell, and Write Cell activities; and Update sheets in Rename Sheets or Delete Sheets.

A new option in SharePoint activities – Update List Columns – allows you to retrieve the latest data if you've performed any changes to your lists.

Excel Online activities

Two new Excel Online activities are available: Write Row and Write Column. You can manage entire rows and columns and manipulate cells within with Append, Insert, or Overwrite options.

Excel Online activities introduce a new dimension of worksheets control using A1 Notation metadata and the new activities. Excel activities now offer metadata about the worksheet they are working on to give more control and enable complex scenarios for business users. Until now, users had to make additional auxiliary calculations to store a range of metadata and to know where the robot acts at any moment in Excel Online. With the metadata now exposed and the new activities, we reduced the redundant auxiliary logic a business user must apply to automate an Excel file. This also reduces the barrier for more complex scenarios where the range doesn’t start from A1.

The Range information output field is available in the Read range activity. This field can be a complex object or a string, and it exposes information such as FullRangeAddress, RangeAddress, StartCell, EndCell etc.

The following additional worksheet metadata is now exposed: WorksheetsRowIndex – the worksheet row value in the context of the specified Range; [Column Name] Address – the A1 notation address of the specified cell; [Column Name] Column Address – the A1 notation of the column of the specified cell; and Range information.

The Remove empty rows or columns field was renamed to Delete behavior.

We improved the validation message that indicates where the duplicate or empty columns are located.

The Has Headers option in For Each Row in Workbook is now set to True by default.

You can use the Write Range activity to insert a new row using the Append option.

We also added some improvements to dynamic datatables: the Column Names are now available in a Description property.

SharePoint List activities

New filtering options are available. You can filter items by IDs or by empty columns (e.g., to retrieve items which don't have a Salesforce ID).

Triggers

For a comprehensive integration with SharePoint List, we added two new triggers: List Item Added and List Item Updated. The activity package now includes five SharePoint List activities and two triggers, allowing you to perform all the basic actions (Add, Get, Update, and Delete) on all the items.

The OneDrive File Created and File Updated triggers now support Groups and SharePoint libraries.

Bug fixes

• Complex field types (PersonOrGroup data type) were erased when updating any other list item fields in a SharePoint list.
• When using Use OneDrive & SharePoint activity with the Use Integration Service option, only connections in the personal workspace were visible. Folders support is now available, so connections from other folders are displayed.
• The Get Email List activity failed when using a shared mailbox and running the process from Orchestrator through an unattended robot.
• The Get Mail activity failed when the email subject included a line break.

Known issues

SharePoint List activities can't be used in long-running workflows before pausing. You must fetch the items again after resuming the job.

v2.2.7

Release Date: 24 July 2023

Bug fixes

• When using the Get Mail activity for emails that include inline images, the images were saved as external attachments instead of embedded in the email body.
• Fixed an issue which caused File activities to throw an error when using Application authentication type, despite performing the action successfully.

v2.2.6

Release date: 23 June 2023

Bug fixes

• Fixed a bug which caused the Delete Range activity to fail when setting a custom Range value using the Expression editor.

v2.2.4

Release Date: 20 June 2023

Bug Fixes

• This release includes additional minor bug fixes.

v2.2.3

Release Date: 16 June 2023

Bug Fixes

This release includes minor bug fixes.

v2.2.2

Release Date: 12 June 2023

New Features and Improvements

The Total number of items processed output property in the cross-platform For Each activities has been renamed. Instead of "items", the property now includes the object name. For example, in the For Each Event activity, the output property is now Total number of events processed. This property can also be used inside the For Each to count the total number of items processed. It iterates through items and is incremented by 1 at the end of each iteration.

The cross-platform and trigger activities now include support for Shared with me, SharePoint, and Groups folders.

Range caching is available for the Excel activities, making it easier to share information between activities using the same connection and workbook. Caching is also available within each activity, with information stored in memory. When you select a workbook, the Range field is prepopulated. If you select the same workbook in another activity, the ranges load from the cache memory. An Update Ranges option is available for the Range field, in case you perform any changes in the selected workbook ranges metadata (such as Range names, Sheets names, or Table names). This feature impacts the following activities: For Each Row in Workbook, Read range, Write range, Write cell, Read Cell.

O365DriveRemoteItem variables now expose a ParentUri property, representing an item's parent folder. The ParentUri property can be used downstream in other activities to add items to a specific parent folder. This feature is not currently supported for personal account users.

A Job Data output property is available in all the trigger activities. It contains the job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution.

Several Files activities now include a If file/folder already exists property.

The Get File List activity was renamed to Get File/Folder List.

New activities

A Get Event List activity is now available.

SharePoint List activities

A new category of activities is now available: SharePoint List. It includes the following activities: Get List Items, Add List Item, Delete List Items, Get Single List Item, Update Single List Item.

New trigger activities

Three new trigger activities are available: Calendar Event Replied, Calendar Event Updated, File Updated.

Bug Fixes

Fixed a bug in the For Each Event activity, which didn't expose the output list of events.

Fixed a bug which caused the Read Cell and Write Cell activities to throw an error when a NamedRange was used. The Cell property was interpreted as being required instead of optional.

Fixed an issue which caused the ApplicationIDandSecret authentication to fail because permissions and scopes were requested for https://graph.micosoft.com/.default instead of https://graph.micosoft.us/.default.

v2.1.1

Release Date: 27 March 2023

New Features and Improvements

A Number of items processed output property is now available in the cross-platform For Each activities.

The Filter by file names (e.g. .xlsx or .xlsx|*.docx) input property in the Download email attachments activity has been renamed to Filter by filename.

The For Each Event activity now includes filtering capabilities.

The How to write property in the Write Range activity includes a new Append option: Append Right.

For the Read Range and For Each Row in Workbook activities, we now expose columns as headers when named headers are not available.

We also implemented a new behavior in activities to reduce validation errors. Switching the input type doesn't clear the value from the previous input mode. The information is instead stored in a back-up slot and restored if the input mode changes. This way, no validation errors appear when switching between input modes.

New activities

Two new activities are included in this release:

• Get Email List

• For Each Sheet in Workbook

Trigger activities

The trigger activities were renamed for this release, as follows:

• Calendar:
  • When a New Calendar Event is Created is now called Calendar Event Created
  • When an Event Invitation is Received is now called Calendar Event Received
• Email:
  • When an Email is Sent is now called Email Sent
  • When New Email Arrives is now called Email Received
• OneDrive:
  • When a New File is Created is now called File Created

Improvements for Excel activities

We've improved performance for the Write Cell activity. When used inside a For Each Row in Workbook activity, Write Cell writes in-memory, to improve speed and prevent API quota limits.

The For Each Row in Workbook activity also has a new error handling mechanism, for writing the data already stored in-memory when an error is thrown.

v2.0.3

Release Date: 2 March 2023

Bug Fixes

This release includes minor bug fixes.

v2.0.2

Release date: 28 February 2023

Improvements

We've reorganized the activities in Studio. The classic activities (which are Windows-Legacy and Windows compatible) are available under the Integrations > Microsoft > Office 365 - Classic category.

The newer activities (which are Windows and Cross-platform compatible) are available under Integrations > Microsoft > Office 365. These activities have improved UX and functionalities and they require using Integration Service for establishing connections. For non-Integration Service connections, use the Classic activities.

v2.0.1

Release date: 25 January 2023

New Features and Improvements

New activities

This release brings many new activities for Cross-platform and Windows projects. They include a renewed Designer panel, which provides an improved experience compared to the existing activities that are available in Windows and Windows — Legacy projects.

These activities are available for the following Microsoft 365 categories:

• Calendar
• Excel Online
• Files
• Outlook

These new activities use Integration Service connections. For a full list of activities and an overview on how to use them, see the Activities page.

Trigger activities

The following trigger activities are now available:

• Calendar: When a New Event is Created, When an Event Invitation is Received
• Files: When A New File is Created
• Outlook: When an Email is Sent, When a New Email Arrives.

For more information, see Trigger activities.

Improvements

The Move File/Folder activity was enhanced to call three Graph APIs, to support different permissions for moving items across drives.

We've exposed a new method — GetSizeInBytes() — that allows you to retrieve file size for locally downloaded files.

Known Issues

• Microsoft is deprecating Basic Auth for Exchange online. Some of our activities are impacted by this change, such as Microsoft Office365 Scope. We recommend using the OAuth protocol in the activities that support it.

Bug Fixes

• The Send Mail activity was throwing an error when more than 30 files were being attached to the email.
• An authentication error was thrown when using the Send Mail even when the Account property was configured.

v1.14.1

Release date: 9 May 2022

New Features and Improvements

Improvements

• The Office365 activities pack has been updated to use Microsoft Graph API version 4.11.0.
• A new contextual menu is available for InArgument<String> properties used within the For Each File/Folder activity. For example, you can use the Write Line activity inside the For Each File/Folder activity to be able to access the following properties: Name, Web Url, Creation date, and Last modified date.
• A new parameter is available for the For Each File/Folder activity, named Include Subfolders, allowing you to specify whether to expand the search to include all subfolders of the selected cloud location.
• The For Each File/Folder activity can now be used with personal Microsoft accounts and with ApplicationIdAndSecret and ApplicationIdAndCertificate authentication types (when used inside Microsoft Office 365 Scope activity) if the Use simple search option is checked.
• A new activity is now available under the name of Delete Sheet.
• The Search Events activity received a new parameter, called Event ID.
• The Get Mail activity received a new parameter, called Email ID.
• The Use OneDrive & SharePoint activity now allows you to use multiple connections by accessing the UiPath Orchestrator through Integration Services. The Default option has been replaced by the connection name.

• The Download as file field label has been changed to Download location in the Download File activity.

  Note: Studio v21.10 or later is required for this version of the Microsoft Office 365 Activities Packages to work correctly.

Bug Fixes

• A performance issue was resolved for IntegratedWindowsAuthentication and UsernameAndPassword authentication types, and now the authentication calls are not duplicated anymore.
• Fixed a bug that was causing an error when trying to access mail from a folder in a shared mailbox. Now, everything works as expected.

v1.11.1

Release date: 27 October 2021

v1.9.0

Release Date: 28 June 2021

New Activites

Files

Added a new activity, For Each File/Folder, that allows you to iterate through files and folders, specifying, for example, the maximum number of items to return. This activity offers more filtering capabilities (KQL) than the Find Files and Folders activity, so to define different filtering expressions it is recommended to use this activity rather than Find Files and Folders.

Another newly added activity, Share Item, allows you to share a file or a folder with colleagues, within the organization or outside the organization.

Excel

Extended the existing Excel Online activities list with Tables activities (Create Table, Get Table Range, Insert Column, Delete Column, Insert Rows, Delete Rows).

A few new Range activities were introduced (Clear Range, Copy Range, Set Range Color, VLookup Range), allowing you to clear a range, copy a range, set a range color and process a VLookup range that calls the VLookup function.

SharePoint Lists

Starting with version 1.9.0, a completely new category of activities can be found in the Microsoft Office 365 Activities Package, namely SharePoint Lists, which contains two types of activities:

Lists (For Each List, Get List Info) which allows you to return all the lists in a specific SharePoint site or to return detailed information about a specific list

List Items (For Each List Item, Add List Item, Delete List Item, Update List Item) which allow you to return the list items in a list with filtering capabilities, to add and delete list items and to update a list item

New Features and Improvements

Microsoft Office 365 Scope

National clouds support. So far, we supported only global tenants but now you can have tenants running on USGoverment, Germany, or China national clouds.

We introduced an additional type of authentication, Application Id & Certificate (Unattended), which allows you to authenticate for unattended scenarios.

Outlook

We improved the Send Mail activity with the possibility to specify a list of email addresses to reply to and also to set the importance of an email.

For the Get Mail activity, the InternetMessageID field, which is a unique identifier of the mail message, is now being returned.

Files

Support for SharePoint sites that contain /teams/ in the URL. So far, we supported only SharePoint sites that contained /sites/ in the URL.

The Upload File activity allows you, in addition to just uploading the file, to specify metadata or properties for that file. Also, when uploading a file and there is already a file with the same name in the location you selected, you have three possibilities to choose from: either to replace the file, to generate a unique name so it gets uploaded, or you have the option to fail the operation.

The same conflict behavior capability as for the Upload File activity was introduced for the Create Workbook activity as well.

Speed improvement for the Get Group activity for tenants that have a large number of groups.

Bug Fixes

• Fixed a timeout error for the Get Mail activity that occurred when returning a large number of emails.
• Fixed a bug for the RSVP activity that triggered a workflow validation error when the Comment property is empty and the Email Organizer property is unchecked.
• Fixed a bug for the Read Column activity in which Cell Address appeared in the activity designer instead of Starting Cell.
• Localized F1 links in Studio for all Microsoft Office 365 activities.

v1.6.0

Release Date: 21 December 2020

New Features and Improvements

New activities were added: Delete Mail and Set Mail Categories.

Calendar activities got a new parameter, Account. Now they can be used with ApplicationIdAndSecret authentication type.

Added support in Send Mail and Add Attachment activities for attachments larger than 4 MB.

Tenant parameter of Microsoft Office 365 Scope activity is mandatory for ApplicationIdAndSecret authentication type.

RVSP activity warns the user to select the option Email Organizer if a value for Comment field was provided.

Bug Fixes

• Fixed an issue in Microsoft Office 365 Scope activity that prevented the usage of IntegratedWindowsAuthentication authentication type.
• Fixed issue Access token has expired in Microsoft Office 365 Scope activity, occurring for long-running processes.
• Fixed an Object reference not set to an instance of an object. error in Copy Item activity.

v1.5.0

Release Date: 26 October 2020

New Features and Improvements

Added support for SecureString type input to Microsoft Office 365 Scope activity. The new parameters accepting SecureString type input are SecurePassword and SecureApplicationSecret.

Added UiPath Application for InteractiveToken authentication. When this option is selected, no Application ID shall be set.

Bug Fixes

• Fixed an Object reference not set to the instance of an object error occurring in Read Cell, Write Range and Write Cell Excel activities when the Excel file is being shared with a user.
• Fixed an issue in Get Mail activity when the email body contains inline images. Now inline images can be saved using Save Attachments activity even if the email has no attachments.

v1.4.0

Release Date: 21 September 2020

New Features and Improvements

Added support for Application (client) ID and Application (client) Secret authentication in Microsoft Office 365 Scope activity.

Set UiPath.MicrosoftOffice365/version value for User Agent String which is required to setup Enforce Allow List. Current value is UiPath.MicrosoftOffice365/1.0.0.0.

Bug Fixes

• Fixed an issue occurring when reading an Excel file that is shared with a user.
• Fixed an exception in Get Mail activity occurring when an email address in CC list is no longer active. The activity does not fail anymore in such cases, but it logs the details about the problematic email addresses.
• Fixed a bug in Get Mail activity which could not retrieve *.msg attachments.
• Fixed a Microsoft Graph dependency conflict between UiPath.MicrosoftOffice365.Activities and UiPath.AzureActiveDirectory.Activities activities packs.

v1.3.1

Release Date: 17 August 2020

Bug Fixes

• Fixes a package conflict caused by different Microsoft.Identity.Client versions.

v1.2.1

Release Date: 19 May 2020

New Features and Improvements

Added Microsoft Planner and Groups activities.

Added support for subfolders in the Get Mail activity.

v1.1.1

Release Date: 7 Nov 2019

New Features and Improvements

Added support for shared mailboxes in all Outlook activities.

Bug Fixes

• Fixed a bug that broke the binding on Event fields in the Calendar activities .

v1.1.0

Release Date: 28 Oct 2019

New Features and Improvements

With this release, the Microsoft Office 365 Activities Package now has official enterprise support.

This release also introduces a new From property in the Send Mail activity so that you can now send mail from other email addresses or aliases.

v1.0.0

Release Date: 22 July 2019

New Features and Improvements

The first official release of the Microsoft Office 365 Activities Package, this package introduces Calendar support, full localization, and adds three new Excel activities:

• Append Range
• Delete Range
• Get Cell Color

With the Calendar activities, you can now manage your calendar events, including create new events, retrieve events from a specific calendar, and update existing events.

v0.2.0

Release Date: 21 June 2019

New Features and Improvements

This release introduces support for all types of Sharepoint sites (including private and shared), as well as, sites that include spaces in their name.

Breaking Change

• The SiteName property in the Find Files and Folders and Get Item activities was changed to SiteURL. Because this is a breaking change, you must update any existing projects to this version.

v0.1.1

Release Date: 25 April 2019

New Features and Improvements

The first beta integration with Microsoft Office 365. This release includes Files (OneDrive), Excel, and Outlook activities.