Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Sharepoint Input Tool for List in Cloud changed service principal authentication

hroderick-thr
11 - Bolide

The Sharepoint input tool from Gallery recently changed configuration for app-only connection. The "Client Secret" is gone and the "Thumbprint" and "Private Key" are now required. The documentation doesn't seem to help documentation  doesn't seem to have kept up. As I read it, 

hroderickthr_0-1674674718861.png

still refers to the old way and I need to know how to get "Thumbprint" and "Private Key"

 

Where do I get these values? Sharepoint Admin? Azure Admin? Other?

We need to configure to run in an unattended background process.

 

Old ConfigurationNew Configuration
hroderickthr_2-1674674905755.png

 

hroderickthr_3-1674674985330.png

 

  

 

 

 

 

3 REPLIES 3
Felipe_Ribeir0
15 - Aurora

Hi @hroderick-thr 

 

Yes, the Sharepoint admin can create one for you, but if you are one of the owners of the specific site that contains the list, you can create it by yourself.

 

I got the instructions with the IT of a previous company and put it here, but you can find youtube videos to do that to:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Sharepoint-365/td-p/999204

 

hroderick-thr
11 - Bolide

Thanks Felipe! I expect this is right but it will take time to work out. When I do I'll give you the green checkmark

hroderick-thr
11 - Bolide

I'm going to accept Felipe's solution because it will work and I've learned of an alternative we will pursue.

These links from Microsoft describe the SharePoint method and the Azure method that someone may find useful.

We have Azure hosting our Microsoft 365 products and are trying to centralize administration there instead of in various products like SharePoint, Outlook, etc.

 

Overview :  

https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly

 

Azure Details : 

https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azuread

 

SharePoint Details: 

https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly 

 

Labels