Alteryx read only column names not the values from my sharepoint list...

Question

Hi everyone, Recently I got my azure token expired from my sharepoint list, I create a new app in the portal and write down my ClientID and SecretKey, give the access in sharepoint (https://azureford.sharepoint.com/sites/{yoursite}/_layouts/15/AppInv.aspx) with the following XML code: But when I try to read the data from my alteryx flow using a Sharepoint Input Tool I get only the columns but any data: When configuring my Sharepoint Input Tool everything looks fine, I even get all the lists and views from the connected sharepoint: But still getting nothing but the column names. Already try to delete and create a new token and the problem still... Any help with this will be very appreciated!

leefarrell · Answer

Permissions: Ensure that the app permissions are correctly set in SharePoint. Double-check that your AppPermissionRequests XML code has the correct scope and rights. The space in "http://sharepoint/content/sitecollection " might be causing an issue; it should be "http://sharepoint/content/sitecollection".

SharePoint List Data: Verify that the SharePoint list actually contains data and is not empty.

Alteryx Configuration: Make sure that the SharePoint Input Tool is configured correctly. Confirm that you're selecting the correct list and view and that there are no filters or conditions that might be excluding the data.

Token Expiry: Even though you've recreated the token, ensure that it’s correctly applied and that there are no issues with token expiration.

Data Types: Check if there are any specific data types or columns in SharePoint that might be causing issues with data retrieval.

If everything looks good but the problem persists, consider reaching out to Alteryx support or reviewing any specific documentation related to SharePoint Input Tool configurations.