Sharepoint 365 (Cloud) Input Files not working Alteryx Server

Hello, since upgrading to 2024.1 our DCM connection to Sharepoint 365 (Cloud) has stopped working. It still works as expected on designer and allows us to synchronize to the gallery however when we go to the gallery we get an error as attached.

I think prior to upgrading our server to 2024.1 we used to have a technology option called Sharepoint 365 (Cloud) Input Files. We still have this available on designer when dragging the sharepoint input tool onto the canvas, however this doesnt appear to be an option on the gallery.

We have installed the Sharepoint add-on on our server in addition to our local machines.

Any ideas what could be causing this issue?

Thanks

Alteryx Server Error.png

Connection on Designer.png

Alteryx Server Technology.png

Alteryx Server Sharepoint.png

Server

Sharepoint

Accepted answers

All comments

TimothyH

Hi @Connor_Baines - With the upgrade to 24.1 there was a python upgrade to 3.10. This required a new version of all python based tools including SharePoint. Please ensure that both the Designer and the Server have this new version of the tool installed. The latest and greatest 2.7.0 connector was just released last week https://marketplace.alteryx.com/account/apps/125cad2d-f523-45fa-bb2d-af4081d9192d/download_files?249578148

Connor_Baines

Hi @TimothyH I have checked and both Designer and server are on version 24.1 which uses Python 3.10.

I have updated the Sharepoint tool to 2.7.0 on both designer and server, however we are still getting the same issue where it works correctly on designer but the DCM connection wont sync to the gallery.

Thanks

TimothyH

Hi @Connor_Baines Is it possible that the Server wasn't configured to allow synchronization after the install?

DCM Server Config.png

Connor_Baines

Hi @TimothyH Double checked that but looks to be setup the same as yours

DCM Server settings.png

TimothyH

Hi @Connor_Baines Sounds like you have everything configured properly and if it all worked before the upgrade I would assume your SharePoint admin has permissions granted correctly as well. I would open a ticket in Mission Control

Connor_Baines

Thanks @TimothyH I will raise it there.

cpatterson03

@Connor_Baines did you resolve this? I am experiencing the same!

Connor_Baines

Hi @cpatterson03 yes in the end I uninstalled the non admin version we had installed on the server and reinstalled using the Admin version. This seemed to resolve the issue

cpatterson03

Neffarious23 Save the SharePoint tool download from the Alteryx marketplace to the server desktop or some easily accessible location. Right click on the designer app in the server, you'll see "run/open as administrator", click it. It will open the designer as an administrator. Go to "file" -> "open" and find/click on the SharePoint tool you saved and it will ask you to apply to all, which you want to do. and Voila! It should now work!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703