06-30-2020 09:39 AM - edited 08-30-2021 11:06 AM
This KB is an extract of the Inspire 2019 Tips + Tricks and although this tip is not officially supported by Alteryx, we’ve seen it work for a lot of users.
PrerequisitesProcedure
Reading and writing to document libraries in Sharepoint consists in creating a OneDrive sync to your local machine:Common Issues
Great article! I shared this today with some of my students!
Hi,
thanks for the useful article @JohnGD
in my organisation Sharepoint is synced on alteryx server.
i am trying to write out to an excel on Sharepoint.
The file in my Output tool matches the file in the synced folder, the event log shows this tool executed without errors and that it output the 2 records i need but when i check the excel on Sharepoint its empty.
So everything seems successful, no errors and i can't debug...
I am able to read Sharepoint files into the worklow but i can't write / overwrite them, any ideas why is appreacied 🙂
Hi @Mmisiji60,
Were you able to get the workflow to work on Alteryx Server? Did the output tool write the data to the file?
Hi, i no longer work with this tool and organisation,
but as far as i remember it was Sharepoint permission setting that our IT support team was in charge of.
They let me create new files ( timestamped) but not update old ones.
So i ended up just creating new files for every run with unique name.
Hope it helps.