SharePoint Lists Not Displaying in SharePoint Files Input Tool

[Suskil]

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.png

image.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.png

Additional Resources

• SharePoint Files Input Tool Help Documentation