Skip to main content
Planview Customer Success Center

SharePoint Online - Setting Up the Integration

This section describes how to configure the integration between SharePoint Online and AdaptiveWork. For more about the benefits and how to manage SharePoint content in AdaptiveWork, click here.

The integration with SharePoint online includes the following stages:
clipboard_e3ec16caf0dbb7165e66eeef768da93f0.png

Supported Versions and Unsupported Functionality

1. Registering the AdaptiveWork app in Azure Active Directory

The following procedure should be performed by your Microsoft 365 administrator.

To register AdaptiveWork in Azure:

  1. Log into your Azure account, and click Azure Active Directory.
    Note: If you do not see Azure Active Directory, click More services and search for Azure Active Directory.

    new1.png
  2. Select your directory, and then select App registrations, and New registration.

    new2.png

     
  3. Add a Name and Redirect URI based on your location, and click Register.
    You can update or add a Redirect URI under Authentication.
  4. Open the Overview screen.
    mceclip6.png
     
  5. To add an Application ID URI, click Add an Application ID URI.
    mceclip27.png
  6. You should now see the Expose an API screen.
    mceclip8.png
  7. In the Expose an API screen, click Set and update the URL with your SharePoint URL plus the suffix /Integration.
    Example: api://a0ed89f4-7b47-4c5b-b97d-f157af...de/Integration
    mceclip9.png

    mceclip10.png
  8. Click Add a Scope and fill in the following details:
    • Scope name: user_impersonation
    • Who can consent?: Admins and Users
    • Admin consent display name: Access AdaptiveWork-Sharepoint online integration
    • Admin consent description: Allow the application to access AdaptiveWork-Sharepoint online integration on behalf of the signed-in user
    • User consent display name: User consent display name
    • User consent description: Allow the application to access AdaptiveWork-Sharepoint online integration on your behalf
      mceclip28.png
  9. Under Certificates & Secrets, add a new client secret.
    Copy the value of the key, as you will need the value to register the integration in AdaptiveWork.
    mceclip12.png

    mceclip13.png
  10. Under API Permissions, add permissions.
    mceclip14.png

    For Azure Active Directory Graph
    gr1.png



    For SharePoint

    gr2.png

     

  11. Roles and administrators (Preview)
    mceclip19.png

2. Registering SharePoint in AdaptiveWork

 

As a AdaptiveWork administrator, register SharePoint Online in AdaptiveWork.

  1. Go to Settings > Extensions.
  2. In the SharePoint section, click Setup.
    mceclip20.png
  3. From the drop-down list, select Online.
    SharePoint_Setup_wHubSites.png
  4. In the Configuration screen, enter values for the following parameters:
    1. Site URL: URL of your Share Point site
    2. Client ID: The “Application (client) ID” value that you saved when registering the AdaptiveWork application with Azure ActiveDirectory.
    3. Secret ID: The key value that you saved when registering the AdaptiveWork application with Azure Active Directory.
    4. Enter one of the following the URLs:
      • Site Collection URL: The URL of the SharePoint Site Collection.
      • Hub Site URL: The URL of the Hub Site that contains Site Collections.
  5. Click Update.

Authenticate User’s AdaptiveWork Account with SharePoint

There are two ways to authenticate AdaptiveWork users in SharePoint:

  • By editing the Integration Settings in the user's details. Once the integration settings are configured, users are not prompted to authenticate with SharePoint when attempting to open SharePoint content from AdaptiveWork.
    Note: You can also automate the process using a workflow rule.
  • At the run-time, when a user clicks SharePoint content in AdaptiveWork, the user is prompted to enter their SharePoint credentials. Users are required to authenticate only when they access SharePoint content from AdaptiveWork for the first time.

Editing integration settings for users
To edit integration settings for yourself:

  1. Click your name in the top menu > My Details.
  2. In the Personal Details section > click Edit for the Integration Settings property.
  3. In the Integration Setting pop-up window, click Associate with SharePoint Account button.
    mceclip23.png
  4. A new tab opens where you can log into your Microsoft account, which authenticates your AdaptiveWork account with SharePoint.