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

[Phavaldar]

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:

<AppPermissionRequests AllowAppOnlyPolicy="true">
<AppPermissionRequest Scope="https://site-collection-url" Right="FullControl" />
</AppPermissionRequests

Permission is granted and listed in /Site Settings/Site App Permissions list of SPT site. However, I am still unable to see any records after running workflow. Its shows only columns in result window but now records in it. 

[mceleavey]

@Phavaldar ,

can you share the configuration of the SP tool?

Also, check that you are pointing to the correct level. Can you select the list from the dropdown? Are there items on the list?

M.

[Phavaldar]

Yes, there is an item showing in list - I have selected List in configuration window and post that in View section, It was by default "All Items".  but still after running workflow, I see there is no records in result window except column names

[BenFr]

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?

[Ashroof]

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

[Phavaldar]

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.