The SharePoint Connection feature allows Leapwork administrators to configure and authenticate a connection to a SharePoint site. This integration allows you to automatically read from and write to Excel files stored in SharePoint, directly within your automation workflows.
Note: This feature will be available starting from Release 2025.1.
Add Connection
To add a connection:
-
Click the Add button and the following pop-up appears:
In the Add Connection pop-up window:
-
Enter the title in the Title field. It should be unique.
-
Enter the description in the Description field.
-
From the Type drop-down, select the Microsoft Graph (SharePoint) option:
The following new fields appear:
-
Enter the tenant in the Tenant field.
-
Enter the client ID in the Client ID field.
Note: To obtain the Client ID, you must register the SharePoint application in Azure Active Directory (AAD). Refer to our Knowledge Base guide on app registration for step-by-step instructions. -
Enter the client secret in the Password field.
Note: To obtain the Password, you must register the SharePoint application in Azure Active Directory (AAD). Refer to our Knowledge Base guide on app registration for step-by-step instructions.
-
Click the Test Connection button to validate the credentials.
Leapwork will generate a temporary authentication token (valid for one hour).
To modify or remove the connection, you can use the Edit or Delete buttons next to the Add button.
Once configured, this connection lets Leapwork automation read and write Excel files on the SharePoint site.