SharePoint Input File

[bkgators]

I am attempting to access files in SharePoint Online via a workflow, but can't seem to figure out what information should be provided in each input box. I first tried to use the "Sign in via Internet Browser", but that just seems to dead end after I input the email credentials. So now trying to "Provide authentication information".

Client ID - email that has access to SharePoint?

Client Secret - password for that email address

Tenant ID - ????

[Qiu]

@bkgators 
This post should help.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SharePoint-Input-Tool-SharePoint-Onlin...

[bkgators]

That post seems to be talking about the setup for using the SharePoint Input List and I am wanting to access files using SharePoint Files Input...and again the main question is what is a Tenant ID?

[VojtechT]

Hi @bkgators , the dead end issue you were facing has been resolved. Please upgrade to Designer 21.3.3 and Sharepoint Files 1.1.0. These two should let you get through the authentication and work with your sharepoint files. 

[bkgators]

@VojtechT Do you know if this version of Designer and Sharepoint tool will require that the server also be upgraded?

[VojtechT]

The tools itself probably will not, but afaik you cannot publish from newer Designer to older Server, so only due to that reason the Server upgrade will be necessary, I believe.

[VojtechT]

thinking about it, you will have to upgrade Server also due to the connector, because it is relying on some new mechanisms, which were not there before. sorry for misleading. Server upgrade is definitely needed.

[bkgators]

@VojtechT  So that answers the question of how...for the future. Problem is now that we cannot upgrade our server to the new version since it no longer supports 32 bit Oracle Driver and we still have some of those within the company. However, this still bring me back to the original questions of where do I find the following:

Client ID - email that has access to SharePoint?

Client Secret - password for that email address

Tenant ID - ????

[VojtechT]

If you use Sign in via Internet Browser method, you don't have to provide any of those. I was assuming you are using 21.3.2, because that's the version which leads to a dead end. The previous versions did not have this issue, but the connector also requires Designer 21.2 at least. If you are using any older Designer, I am afraid you cannot use this connector at all. 

And to answer your question - those IDs can be obtained via portal.azure.com by creating an App according to the Help page. 

[mattagnello]

Hi @VojtechT, I'm trying to launch an app on server 2021.4 using 'sharepoint files input.' After following Azure set-up steps on (https://help.alteryx.com/20214/designer/sharepoint-files-output-tool) while testing in designer using 'provide client ID, secret, and Tenant ID' with app-only authentication there is still a browser pop-up prompt for authentication. App fails on authentication on server due to this. Any idea on how to resolve?