To connect Salesforce with SharePoint, an authentication provider must first be set up in SharePoint. AdvoLogix supports two modes of authentication for SharePoint to connect:
- SharePoint Add-in - A web application registered within SharePoint online/Office 365 panel.
- Azure Active Directory (AD) - An Azure AD based web application registered within Azure Management Console.
Which one you use depends on how your organization has set up your SharePoint access. This article will walk you through registering a web application using Azure AD. To perform the steps needed, you must be an administrator who manages SharePoint and employee access. If you cannot access the Azure Management Console, proceed with registering the application using the SharePoint Add-in. Otherwise, you can register your web application using Azure AD.
Step 1
Log in to your Azure portal as an administrator. Then, under Azure Services, select Microsoft Entra ID.
On the Active Directory page, select App registrations from the navigation menu on the left. Then, click New Registration in the header menu.
Step 2
Input your information into the following form.
- Name - Enter a name for your application.
- Supported Account Types - Select the accounts in this organizational directory only (Single tenant).
- Redirect URI - Skip this step.
- Select Register when you are ready to move to the next step.
Step 3
After the app is created, select Overview from the navigation menu on the left. Copy the Application (client) ID and Directory (tenant) ID to a text file. You will need these to complete the authentication configuration later in Salesforce.
Step 4
From the navigation menu on the left, select Certificates & secrets, then choose New Client Secret.
Next, input the information needed for the client secret.
- Enter a description
- Select a duration
- Select Add to save your changes
Step 5
Copy and save the Value to a text file for later use. This is the only time you will be able to copy/paste this particular text. If you do miss this step, you will have to repeat Step 4.
The Value text will be needed to complete the SharePoint configuration in Salesforce. (See Step 2)
Step 6
From the navigation menu on the left, select Authentication. Then, under Platform configurations, select + Add a platform.
Step 7
1) Select Web.
2) Enter the Redirect URL needed by AdvoLogix to authenticate with SharePoint and copy the value to a text file. This URL will contain your organization's My Domain (see screenshot directly below).
The URL structure will look like this:
With Enhanced Domains enabled:
- Production -
https://[your salesforce my domain]--shpoint.vf.force.com/apex/ConnectSharePoint - Sandbox -
https://[your salesforce my domain]--[your sandbox name]--shpoint.sandbox.vf.force.com/apex/ConnectSharePoint
Without Enhanced Domains:
- Production -
https://[your salesforce my domain]--shpoint.visualforce.com/apex/ConnectSharePoint - Sandbox -
https://[your salesforce my domain]--[your sandbox name]--shpoint.visualforce.com/apex/ConnectSharePoint
3) Select Configure to move to the next step
Step 8
Under the Implicit grant and hybrid flows, enable Access tokens and ID tokens checkboxes. Then, in the header menu, click Save.
Step 9
From the left panel, click API Permissions, the select + Add a permission.
Step 10
- Select SharePoint
- Choose Delegated permissions
- Expand the AllSites grouping and enable the following permissions:
- AllSites.Read
- AllSites.Write
- Select the Add Permissions button
Step 11
Click Grant admin consent for [your company name].
Confirm by selecting Yes.
