We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sharepoint list input HELP

TheaAbella000
7 - Meteor

Good day

 

I am new to using sharepoint list input tool

 

GOAL: I want to get the data from my excel file from our sharepoint group using sharepoint list input tool. However I am only getting list of names, created date and their content type. I want to get and process the whole dta within the alteryx. Is there a way to do this?

 

TheaAbella000_0-1661188376308.png

 

Thanks for the help

 

4 REPLIES 4
MattBenj
10 - Fireball

To open individual files from SharePoint I would use the SharePoint Files Input Tool. If you need to dynamically open multiple files you can wrap the tool in a batch macro.

 

SharePoint Files Input Tool | Alteryx Help

TheaAbella000
7 - Meteor

Oh thank you

 

I have tried this tool but i have a problem

 

-I couldnt connect to our group although  i know my url is valid as well as my user name and password. Any idea why?

 

TheaAbella000_0-1661276633555.pngTheaAbella000_1-1661276687420.png

 

MattBenj
10 - Fireball

My company uses the "Sign in via internet Browser" and "Provide Client ID and Secret, and Tenant ID" options so I'm not familiar with this method. I don't see any error messages on your screen. Is it giving you a specific error?

TheaAbella000
7 - Meteor

Hello Matt no worries my tool is already registered so im not getting an error anymore

Labels
Top Solution Authors