SharePoint tool not working on Gallery. "Failed to authenticate"

CCarroll-

Hi all,

I'm currently trying to run a workflow on the gallery which appends to a file sitting on SharePoint for business folder. I am able to do so locally by using the "sign in with browser option", I get prompted to put in my 2FA code from the Microsoft authenticator app (see below)

 However when I go to run on the gallery there is no prompt to authenticate and I get the following error

I have not been able to get it working locally with the last two options and I would rather not have to get a client/tenant ID set up from my IT department. Has anyone found a workaround/fix for this?

Many thanks in advance!

Conor

fmvizcaino

Hey @CCarroll- ,

I have not found a knowledge base article with the tutorial to correct this one, but here are the steps:

You need to do these steps both on the designer and server machine.

Instructions from Alteryx Support:

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.

Best,

Fernando Vizcaino