Release notes

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.

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.

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

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.

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.

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

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

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.

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

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.

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.

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

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

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.

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.

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.

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.

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.

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

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

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.

Fixed a minor issue in the Get Newest Email activity.

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.

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

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.

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.

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.

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

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

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.

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

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.

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.

A Get Event List activity is now available.

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.

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.

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.

Two new activities are included in this release:

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

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.

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.

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 new activities use Integration Service connections. For a full list of activities and an overview on how to use them, see the Activities page.

The following trigger activities are now available:

For more information, see Trigger activities.

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

Improvements

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

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

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.

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.

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

Added Microsoft Planner and Groups activities.

Added support for subfolders in the Get Mail activity.

Added support for shared mailboxes in all Outlook activities.

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.

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

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.

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

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