The SharePoint List Online connector uses service principal authentication to connect to SharePoint. Follow these steps to set it up:

Register an application entity in Azure Active Directory (Azure AD) by following Register your application with an Azure AD tenant. Make note of the following values, which you use to define the linked service:

  • Application ID
  • Application key
  • Tenant ID

Grant SharePoint Online site permission to your registered application:

This operation requires SharePoint Online site owner permission. You can find the owner by going to the site home page -> click the "X members" in the right corner -> check who has the "Owner" role.

Open SharePoint Online site link e.g. https://[your_site_url]/_layouts/15/appinv.aspx (replace the site URL).

Search the application ID you registered, fill the empty fields, and click "Create".

  • App Domain: localhost.com
  • Redirect URL: https://www.localhost.com
  • Permission Request XML:
XML
<AppPermissionRequests AllowAppOnlyPolicy="true">
    <AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="Read"/>
</AppPermissionRequests>

Click "Trust It" for this app.

  • No labels