activities
latest
false
Productivity Activities
Last updated Nov 6, 2024

How to use Microsoft 365 activities without Integration Service connections

About

You can now use the newer Microsoft 365 activities even if you don't have Integration Service, through Microsoft 365 Scope.

The Microsoft 365 activities designed specifically for Integration Service feature a Connection field, which enables you to choose a connection created through an Integration Service connector. When used inside Microsoft 365 Scope, the activities simply inherit the connection information from the Scope.

Authentication and projects types matrix

Microsoft 365    
 CloudOn-Prem
 Microsoft Office 365 Application ScopeIntegration ServiceMicrosoft Office 365 Application ScopeIntegration Service
Cross-platform    
App ID & Certificatenot available not available not available not available
App ID & Secretnot availablenot available not available not available
OAuth - BYOA available not availablenot available
OAuth - UiPath Appnot available available not availablenot available
Username & Passwordnot available not availablenot available not available
Integrated Windows Authenticationnot available not available not available not available
Windows    
App ID & Certificateavailable not availableavailable not available
App ID & Secretavailableavailable available not available
OAuth - BYOAavailable available available not available
OAuth - UiPath Appavailable available available not available
Username & Passwordavailablenot available available not available
Integrated Windows Authenticationavailablenot available available not available

Connection methods

There are two ways to set up a connection in the Microsoft 365 Scope activity.

Connection method DescriptionBenefitsDisadvantages
Asset
Note: Recommended.
 

Uses an Orchestrator Asset to store the connection together with the Scope configuration.

The asset is a JSON format.

Every time it's used, the activity retrieves the configuration from the asset.

Based on asset configuration, the Scope behaves differently; it identifies the authentication type and hides unnecessary fields.

If the asset JSON isn't set properly, it prompts a validation error.

The activities benefit from design time lookups and can discover files, folders, lists, ranges, and others.

The connection is easily transferable, as credentials aren't passed from one user to another in plain text.

Can be configured by an Admin.

It's more secure, because the credentials don’t reach the Studio workflow.

Requires an advanced user to configure the Asset.

Not easy to set up by a Citizen Developer.

Properties Panel 

Use the existing Properties panel to configure the connection credentials.

The configuration can be added in plain text or through variables.

Easier to use.

Keeps backward compatibility.

 
 Configuration through plain text
Note: Not recommended.
Configure the Properties panel with plain text values.The activities benefit from design time lookups and can discover files, folders, lists, ranges, and others. Less secure, because the credentials need to be passed between users in plain text.
 Configuration through variables

Configure the properties panel with variables.

More secure, because the credentials don’t reach the Studio workflow.

The activities can't discover any resources at design time.

Microsoft 365 Scope asset format

Standard asset format
{
    "CertificateAsBase64": "",
    "CertificatePassword": "",
    "ClientSecret": "",
    "Environment": "Default" | "Global" | "China" | "Germany" | "USGovernment" | "USGovernmentDOD",
    "Mode": "interactive" | "integrated" | "uap" | "appidsecret" | "appidcertificate",
    "OAuth2AppData": {
        "ApplicationId": "",
        "TenantId": ""
    }
}{
    "CertificateAsBase64": "",
    "CertificatePassword": "",
    "ClientSecret": "",
    "Environment": "Default" | "Global" | "China" | "Germany" | "USGovernment" | "USGovernmentDOD",
    "Mode": "interactive" | "integrated" | "uap" | "appidsecret" | "appidcertificate",
    "OAuth2AppData": {
        "ApplicationId": "",
        "TenantId": ""
    }
}
UiPath application asset configuration
{
    "CertificateAsBase64": "",
    "CertificatePassword": "",
    "ClientSecret": "",
    "Environment": "Default",
    "Mode": "interactive" | "integrated" | "uap" | "appidsecret" | "appidcertificate",
    "OAuth2AppData": {
        "ApplicationId": "f2f43f65-16a6-4319-91b6-d2a342a88744",
        "TenantId": ""
    }
}{
    "CertificateAsBase64": "",
    "CertificatePassword": "",
    "ClientSecret": "",
    "Environment": "Default",
    "Mode": "interactive" | "integrated" | "uap" | "appidsecret" | "appidcertificate",
    "OAuth2AppData": {
        "ApplicationId": "f2f43f65-16a6-4319-91b6-d2a342a88744",
        "TenantId": ""
    }
}
Custom application asset configuration
Note: This is just an example. Configure your own application and retrieve the required OAuth2AppData.
{
    "CertificateAsBase64": "",
    "CertificatePassword": "",
    "ClientSecret": "",
    "Environment": "Default",
    "Mode": "interactive" | "integrated" | "uap" | "appidsecret" | "appidcertificate",
    "OAuth2AppData": {
        "ApplicationId": "d47f7253-65ae-58n5-ag04-26109734e6de",
        "TenantId": "3ce4ef03-chb1-871f-94b0-345136965f10"
    }
}{
    "CertificateAsBase64": "",
    "CertificatePassword": "",
    "ClientSecret": "",
    "Environment": "Default",
    "Mode": "interactive" | "integrated" | "uap" | "appidsecret" | "appidcertificate",
    "OAuth2AppData": {
        "ApplicationId": "d47f7253-65ae-58n5-ag04-26109734e6de",
        "TenantId": "3ce4ef03-chb1-871f-94b0-345136965f10"
    }
}

Limitations

The following features are not available when using activities inside Microsoft 365 Scope: triggers, bindings, and override experience.

Token refresh

There is no service available to refresh your connection tokens, like the one available in Integration Service.

If the Authorization Token isn't refreshed for a certain number of days, it expires, and you must re-authenticate. To avoid the expiration of authorization tokens, run a robot with that specific connection. Running an automation with the Scope activity refreshes the authorization token.

docs image
Additional OAuth 2.0 resources:

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.