SharePoint List Input tool retrieves no items from SPT Online site via App Only Authentica

Question

Hi Alteryx Team, Alteryx Designer version 2018.4 is successfully connected to a list on a SharePoint Online site via SharePoint List Input Tool and App Only Authentication. Workflow runs without error but founds no data, while the list contains 100+ items. See SPT List Input tool configuration below. It authenticates with ClientID instead of email address. It connects without error to SPT site, and populates lists of lists and views correctly. This is the app's Permission Request XML with Full Control this time:

Phavaldar · Answer

No, I am still facing the same issue. I can able to connect to SharePoint list. However, I am not able to retrieve any information. The tool works good with any excel files saved on SharePoint.

Ashroof · Answer

Did you reach a solution for this? I am facing the same issue

BenFr · Answer

Hi @Phavaldar,

I think you are on a newer version of Designer now? I'd recommend the newer Sharepoint tools, which is for Designer 2021.2.2 and above:

- Details are here: https://help.alteryx.com/20221/designer/sharepoint-files-input-tool

- Download from here: https://community.alteryx.com/t5/Public-Community-Gallery/Sharepoint-Tools/ta-p/877903

Please check your exact Designer version through the Designer menus Help > About and download the appropriate version.

There was a big increase in functionality with this new tool and potentially this will provide a solution to the empty lists you experienced previously?