This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1. I use many Sharepoint folders to input excel, csv, txt files via Directory Input & Dynamic Input tools and write to Sharepoint folders as well.
2. I have yet to successfully figure out a way to read/write directly from Sharepoint portals. To get around this, I manually sync the Sharepoint folders to my computer and access the Sharepoint folders via Windows Explorer.
3. My colleagues have the same read/write access to the same Sharepoint folders that I have and will be running the Sharepoint dependent workflows that I develop on Alteryx. We do not have access to Alteryx Server.
Not being able to connect directly to Sharepoint has some issues because the address of the folders has your user name embedded in the folder directory.
For example, my Sharepoint folder would say 'C:/JH0123/SharepointFolderName' whereas my colleague's Sharepoint folder would say 'C:/ColleagueUsername/SharepointFolderName'.
When I am building Alteryx workflows, my Sharepoint folder directories are being hard coded into Dynamic Input, Directory Input & Output tools, which can't be run by my colleagues.
To get around this, I added Interactive Tools so that the user asked to select their Sharepoint Username from a list of possibilities & this username then dynamically updates Sharepoint folder locations but this has taken a lot of work to build in.
Any suggestions on how I can easily dynamically input/download files & output files to/from Sharepoint without having to develop workaround for Sharepoint username dependencies in the workflow?