How to Connect Microsoft SharePoint with Drupal

This document will walk you through the steps to synchronize content between Microsoft SharePoint and the Drupal website. Using the Drupal SharePoint Integration module, you can sync User details documents, files, and PDFs from Microsoft SharePoint to Drupal.

Configure Microsoft Entra ID (Azure AD):

• Log into the Azure portal with your Microsoft Entra ID credentials.
• From the Azure services section, click on App registrations.

• Then click on the New Registration.

• Enter the App name and click on the Register button.

• You will get an Application ID, Object ID, and Directory (Tenant) ID. Note the Application ID and the Tenant ID, you will need to provide these in the module configuration.

Integration between Drupal and Microsoft Entra ID:

• Copy the Application (client) ID from the Microsoft Entra ID portal.

• After Successfully installing the module, you will be redirected to the Connection tab.
• Paste the copied Application ID in the Application ID text field.

• Copy the Directory (tenant) ID from the Microsoft Entra ID portal.

• Paste the copied Directory (tenant) ID in the Tenant ID text field.

• Again, go back to the Microsoft Entra ID portal.
  • From the left side panel, navigate to the Certificates & Secrets.
  • Then click on the New Client Secret.
  • Enter Description as the Secret key and click on the Add button.

• Copy the Value and keep it handy.

• Navigate back to the Drupal site and paste the copied Client secret value into the Client Secret text field.
• Once done, click on the Save configs button.

API Permission to your Microsoft Entra ID Application:

• From the Left panel, go to the API permissions and click on the Add a permission.
• Select an API -> Microsoft APIs -> Microsoft-Graph.

• Select Application permissions and search for the Sites in the search box.
  • Select Sites.Read.All and Sites.ReadWrite.All permissions.
  • Click on the Add Permissions button.

• Click on the Grant admin consent for <tenant_name> button, then click Yes from the Grant admin consent confirmation window.

• You can check the granted status as shown in the image below.

Test Connection between Drupal Sharepoint Integration & Microsoft Entra ID:

• After successfully granting permission, go back to the Drupal -> Connection tab and click on the Test Connection button.

• You have successfully connected to the SharePoint site.

How to Download / Preview SharePoint Documents:

• Now, go to the Preview Folders / Files tab.
  • Select Sharepoint Site from the dropdown.
  • Then, select a Directory from the dropdown.
  • You can Preview and Download the documents as shown in the image below.

 Back to top