Microsoft OneDrive & SharePoint authentication

Prerequisites

Depending on the authentication type you select, you need one of the following:

Your Microsoft account email address and password.
Your application's Client ID and Client secret, Scopes and Tenant ID.

Additionally, you must grant permissions to third party apps to access your information. For any error, contact your Microsoft OneDrive & SharePoint administrator.

Note:

Integration Service impersonates the user that creates the connection. The user’s credentials offer access to all of the same resources that they have in the given application. If you share the connection, every change made to Microsoft SharePoint or OneDrive with that connection is made on behalf of that user.

Environment

When you first access the Authentication screen, you can select an Environment. The available options are:

Office 365 (default)
US Government L4 - Public Sector domain
US Government L5 - Public Sector domain
China

Grant permissions to third-party apps

Before establishing the connection, make sure permissions are granted for integrated apps, as explained in the Microsoft official documentation: Configure user consent settings.

Scopes

The following scopes are requested by the connector: offline_access, Files.Read, Files.Read.All, Files.ReadWrite, Files.ReadWrite.All, Sites.Read.All, Sites.ReadWrite.All, Group.Read.All, Group.ReadWrite.All, profile, openid, email, User.Read.All.

This represents the full list of required scopes.

Note: Please work with your IT team to allow these privileges for your user and application.

Add the Microsoft OneDrive & SharePoint connection

To create a connection to your Microsoft OneDrive & SharePoint instance, you need to perform the following steps:

Select Integration Service from Automation Cloud^TM Public Sector.
From the Connectors list, select Microsoft OneDrive & SharePoint. You can also use the search bar to narrow down the connector.
Select the Connect to Microsoft OneDrive & SharePoint button.
You are now redirected to the connection page. You can choose between two authentication types: OAuth 2.0 Authorization code or Bring your own OAuth 2.0 app.
- If you select OAuth 2.0 Authorization code, click Connect, then authenticate using your Microsoft email address and password.
- If you select Bring your own OAuth 2.0 app, you must provide a Client ID and Client secret, the Tenant ID, and the Scopes you may need to interact with different activities. Check out the activities' documentation to see what scopes they require.
  Note: If you are using a multitenant application, keep the default value for the Tenant ID (common). If you are using a single tenant application, retrieve the Tenant ID from Azure. Refer to How to find your Microsoft Entra tenant ID.
Your connection has been added.

Bring your own OAuth 2.0 app

In Integration Service, when creating a connection to one of our Microsoft Graph-based connectors, you can choose between two authentication options:

OAuth 2.0 Authorization code – which connects to the UiPath public application.
Bring your own OAuth 2.0 app – which connects to a private application you create.

To learn how to create an application, go to Microsoft's official documentation and follow the described steps: Register an application with the Microsoft identity platform.

Note: This is an advanced functionality and requires admin privileges in the target application. Work with your IT administrator to set up your application successfully.

Requirements

When creating your own application to use with Integration Service, you must consider the following requirements:

You must configure the application as a Multitenant or Single tenant application.
You must configure a Web Redirect URI. The Redirect URI (or callback URL) for your OAuth 2.0 application is provided in the authentication screen when creating a connection: https://govcloud.uipath.us/provisioning_/callback.
You must set up delegated permissions. For more information, see Permissions in the Microsoft official documentation.
Note: The advantage of using your private OAuth application is that you can customize permissions depending on your actual needs. To learn which scopes are required for each activity in the Microsoft 365 package, go to the activities documentation.
The connector uses Microsoft Graph API. See the Microsoft Graph permissions reference page for details on all permissions.

After you create your application, use its Client ID and Client Secret to create a connection with the Microsoft connectors.

Refresh tokens for OAuth applications

Refresh tokens for OAuth applications can be invalidated or revoked at any time by Microsoft. This can happen for different reasons, such as timeouts and revocations. For details, see Microsoft's official documentation regarding token expiration.

Warning: Token invalidation results in failed connections and automations are unable to run without fixing connections.

Make sure you follow the best practices from Microsoft when creating your OAuth applications. For details on how to create an OAuth 2.0 application, check out Microsoft's documentation.

Note: This issue affects all Microsoft Graph-based connectors.

On this page