Wildcard for username in file path

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!

Workflow

Input

Sharepoint

Accepted answers

alexnajm

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

All comments

alexnajm

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.

Get Username From Env.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703