Any workflows with Sharepoint Input tool fail to publish to gallery successfully.

Question

We have a workflow that uses the Sharepoint Input tool. We have tried authentication using Browser and using ClientId, Secret and Tenant ID. With both ways, the workflow works successfully in Alteryx Designer on Alteryx Server and locally but as soon as we publish to gallery, it fails during validation. We have already checked the regedit entry 'PythonAllowHideEncryption' set to True.

We have confirmed by publishing another workflow that it is indeed the Sharepoint Input tool that is causing the problem (that workflow just had sharepoint input tool and it still fails)

Any thoughts?

KPOLU · Answer

Starting from 2.2.0 version of SharePoint Connector tool, you are required to use DCM for running the workflow with SP tool on server.

https://knowledge.alteryx.com/index/s/article/How-to-Set-up-DCM-for-Designer-and-Server

Hope this helps!

DanM · Answer

@avanibhatnagar I think it would be worth opening a ticket with Support on this one. If it's working on both your desktop and server environments with Designer but not on the Gallery, then there's some issue with the connection timing out and without looking at the workflow and your server environment I'm not sure how else I can help.

avanibhatnagar · Answer

@DanM I have 2.4.1 version of the Sharepoint tool. I checked and reverified all the steps from that article and still get the same error. I can confirm that everything is synchronized and can see the DCM Data Sources on gallery but still fails on gallery but works on alteryx designer on alteryx server.