Microsoft SharePoint

Version:
2022.3
Last modified: November 29, 2022
Connection Type

Alteryx Tool. The latest version is available from the Alteryx Analytics Gallery.

Driver Details

For more information, see Microsoft portal.

Type of Support

Read & Write

Validated On

SharePoint Files tools: Online
SharePoint List tools: 2007, 2010, 2013, 2016, Online

Alteryx Tools Used to Connect

We renamed SharePoint Files to SharePoint in version 2.2.0.

In SharePoint version 2.2.0, we temporarily removed support for SharePoint On-Premise (version 2013 and 2016).

As of SharePoint Files Output version 2.1.0, we included the list reading functionality in SharePoint Files Output.

As of SharePoint Files Input version 2.0.1, we included the list reading functionality in SharePoint Files Input.

Standard Workflow Processing

Link
SharepointFiles

SharePoint Input Tool

Link
SharepointFiles

SharePoint Output Tool

Link
SharePoint List Input Tool Icon

SharePoint List Input Tool

Link
SharePoint List Output Tool Icon

SharePoint List Output Tool

Data Connection Manager

The SharePoint tools support Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to SharePoint and easily reuse the stored credentials in workflows that include the SharePoint tools. Alteryx Server requires stored credentials to successfully run the published workflows.

Enable AMP Engine

Make sure you have the AMP engine enabled for the workflows which contain the SharePoint tools to leverage the full potential of Designer capabilities.

Custom API Application Setup

Before using the SharePoint Online tools, you need to register an application endpoint for external clients:

For more information on how to build and manage an application using the Microsoft Azure cloud services, refer to the Azure documentation

  1. Navigate to  Microsoft Azure

  2. Sign in with your Microsoft Azure Active Directory account.  

  3. On the Home screen use Search, or go to the upper left corner menu to open the Azure Active Directory service. 

  4. Open App registrations in the left menu. 

  5. Select + New registration.

  6. Specify the Name of the app.  

  7. Choose desired account type – both Single tenant and Multitenant are allowed.  

  8. In the Redirect URI part:

    1. For Sharepoint Files version 1.1.1 and earlier: Select Single-page application (SPA) from the dropdown menu and set the two URLs

    2. For SharePoint Files Input version 2.0.1, Sharepoint Files Output version 2.1.0, and later: Select Web-page application (WPA) from the dropdown menu and set the URL:

  9. Select Register.   
    The Application (client) ID is your Client ID
    The Directory (tenant) ID is your Tenant ID

  10. Go to Client credentials and add New client secret.
    Copy the Value as it won't be accessible again once you leave the page - this is your Client Secret.

  11. Go to API permissions to add these Delegated permissions - Microsoft Graph

    1. Files.ReadWrite.All

    2. offline_access

    3. openid

    4. User.Read

    5. Sites.Read.All

    6. email

    7. profile

  12. For Sharepoint Files Input version 2.0.1 and later, add also these Delegated permissions - SharePoint:

    1. AllSites.Manage

    2. AllSites.Read

    3. AllSites.Write

    4. Files.Read.All

    5. Sites.Search.All

  13. If you want to use service principal (app-only authentication) proceed to Certificates & secrets and add New client secret. Copy the Value as it won't be accessible again once you leave the page – this is your Client Secret.

    1. For Sharepoint version 2.2.0 and later: In API permissions, add these Application permissions - Microsoft Graph:

      1. Sites.Selected (See How to set up SharePoint Sites.Selected for more information.)

    2. For Sharepoint Files version 2.0.1 and earlier: In API permissions, add these Application permissions - Microsoft Graph:

      1. Files.Read.All

      2. Files.ReadWrite.All

      3. Sites.Read.All

Now you can use this app in your Alteryx SharePoint Files connector. To authenticate login, you will need your User NamePasswordClient ID, and Client Secret ID and Tenant ID provided with application registration.

For more information, visit Microsoft portal.

Additional Details

SharePoint stores all DateTime values as UTC. To correctly convert your system's DateTime values to and from UTC, do the following:

  • When writing to SharePoint, convert your system's timezone to UTC with the DateTimeToUTC() function.
  • When reading from SharePoint, convert from UTC to your system's timezone with the DateTimeToLocal() function.

Otherwise, use another DateTime Function to perform the calculation. For additional information, see Functions.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.