Connecting to a sharepoint list in a SSO environment

Hello.

I am trying to connect to a sharepoint list that is hosted on a remote server. I am using the sharepoint list tool for that.

It asks for an url, email address and password. Our corporate environment works with SSO, so, typically I dont have to sign in when I access the list. I have tried a number of times with my email and password, but, I always get the same error (attached).

I am not sure if the SSO environment is what is causing the problem, but, I wonder if anyone that has the same setup had to overcome similar issues. I am very interested in how you resolved this.

Thanks in advance.

Francis

Sharepoint

Accepted answers

BrandonB

Hi @franc1s

This article addresses your issue and offers a few solutions: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Designer-Sharepoint-List-Input-Tool-Error-connecting-to/ta-p/547321

All comments

BrandonB

Hi @franc1s

franc1s

Thank you @BrandonB. I will follow up with our IT team. They should be able to provide the parameters for solution A. I do have access to the lists when reading them from excel or access.

franc1s

I ended up having to go through an extra step. I can link to the sharepoint site from Access, and use the the database as input to my Alteryx workflow.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703