Alteryx - sharepoint Gallery issue

[Ariharan]

Hi All,

We are attempting to connect to SharePoint with the SharePoint input tool, using the tenant and client ID. When we click 'connect', it takes us to a browser page where we need to choose our Microsoft account for a successful connection. We have no problem running the workflow locally once we select an account, but what will happen when it is published in the gallery? Is there any way to handle this.?

Installed version - SharePointFiles_v2.0.1.yxi

Regards, 

Ariharan R

[gabrielvilella]

First, please make sure you have the SharePoint tools installed in the Server for all users (as admin). https://help.alteryx.com/20201/server/install-custom-tools 

The SharePoint Files connector is a Python-based connector, so it will require the following registry key to exist in both the end users machine as well as each worker node on the server.   

• Type regedit in Windows Start Menu 
• Browse to the folder location: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx 
• Right click and select New > String Value 

Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx 
Value Name: PythonAllowHideEncryption 
Value Data: true 

 
Once this key has been added, the user would need to reauthenticate the Salesforce tool on his workflow in Designer and republish the workflow to gallery