We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

SharePoint Lists Not Displaying in SharePoint Files Input Tool

Suskil
Alteryx
Alteryx
Created

Issue


Using Sharepoint Files Input Tool 2.1.0 to access Sharepoint Lists. After connecting successfully to Sharepoint URL with Client ID, Secret & Tenant ID, and selecting the Lists option, no lists are displayed. There is a blue spinning wheel, but nothing in the dropdown. Searching for specific lists also results in empty dropdown
 

image.pngimage.png

image.pngimage.png
 

Environment Details

  • Alteryx Designer
    • 2022.1
  • Sharepoint Files Input Tool
    • 2.1.0
  • Custom API App
 

 




 
 


Cause A

Necessary permissions have not been set up in Azure for the custom API App
 

Cause B

'/Lists' has been added to the end of the URL, when not required.
 

Resolution


Solution A 

Apply the following permissions as described in the SharePoint Files Input Tool Help Documentation

Delegated permissions - SharePoint:

  • AllSites.Manage
  • AllSited.Read
  • AllSites.Write
  • Sites.Search.All
 

Solution B

Remove '/Lists' from the URL string when configuring the connection

image.pngimage.png

Additional Resources