Connection to SharePoint - Multiple Users - 2023

[Castelo]

Hello there,

I have a workflow connected to SharePoint where I am the user (the red circle is my employee ID). However, other people run the workflow as well. So every time someone else runs the workflow they update the employee ID so that they can access the data. Is there a way to have a connection to SharePoint, and not have to manually update the employee ID (SharePoint path) every time another user uses the workflow? This also happens with all the formulas we have, which makes it impossible to change them all the time. Creating a workflow for each user isn't possible either, we're still creating it and it's constantly changing.

[cjaneczko]

Sync the Sharepoint file location to One Drive and update the path so its a relative path, not an absolute path. Check out the below link to how Relative paths work.

https://knowledge.alteryx.com/index/s/article/Paths-and-Alteryx

https://knowledge.alteryx.com/index/s/article/How-To-Use-Relative-Paths-1583459124006

[Castelo]

Thank you, I was able to solve the input and output part.

However, I still don't understand how to change the formula to relative path.

"C:\Users\MyUser\ConmpanyName\RTR Markets GBS - UK\06. VAT\Alteryx\1006 Test\V3\Output\OITC imput V1 " + DateTimeToday() + ".csv"