Wildcard for username in file path

[mhart]

Hi - we are transitioning all our workflows and macros from the shared drive to our SharePoint. In doing so, the path has become more absolute and now includes the username of the person who created the new path. So for instance, HLehman updated the path and now I get an error when I try to use the workflow/macro. Is there a wildcard for the username that can be used or some other workaround? Thanks!

[alexnajm · Accepted solution]

I would utilize relative paths so that as long as someone has the SharePoint site synced on their machine similar to what's shown here, it'll still work. How To: Properly Use Relative Paths - Alteryx Community

This gives more detail! File Paths and Alteryx - Alteryx Community

[mhart]

OHH. I realized our paths were different, hence the username still being there. Thank you! 

[dsandmann]

If relative paths aren't working, and you are using designer across multiple users, you could attempt to use command line to pull in user information as demonstrated in the attached workflow.

From there, you could process the path using a dynamic input tool. This could also be wrapped and packaged into a macro depending on your use case.

This is also making the assumption that the target documents are stored in the same end location for each user.