Sharing Workflow to Another User with a License But results in directory error

@Nithinpanicker,

I've attached both workflows and instructions if you cant get them to open. I would highly recommend looking at the macro videos on the community if you want to understand how they work.

Step two, save as a macro file:

Step 3 add macro to new workflow:

Step three, add a formula tool which just adds your file path constant to a record then use the regex tool configured like below:

Step 4, use the outputted regex to update the workflow each time:

Workflow 1.yxmd

Dynamic Username Input.yxmc

@Nithinpanicker If you save the workflow in the teams (sharepoint) folder, relative paths should work for you. I've done a similar thing with shared box drive paths and my coworkers have no issue.

Hi @Nithinpanicker

Where is the workflow itself saved? Looks like somewhere outside of the folder. If you keep the workflow in the same folder the relative option should result in it being able to be ran by anyone. It also avoids issues with versioning between team members

All comments

Looking at it the issue is that the file path references your user name so that will change based on who is using it it. I would try using a setup like this to grab the users file path then adding on where the OneDrive directory is to it. Then pass that to the input tool:

Get user name.yxmd

Hi IraWatt,

Thank you for your response. Yes you are right, the input is indeed referencing my username. I took a look at the workflow you attached to extract the username of the person running the session.

What should I do next? How do I make it replace it in the directory input? Or is there another tool I need to use. Because currently my workflow is designed to take up the latest file (by creation date) from my teams channel using dynamic input.

Sorry if its a silly question, I am new to Alteryx and still learning.

Thanks

Once you've created the path you want with the user name and OneDrive I would put the rest of your workflow into a macro:

From there you can pass the information to your directory tool:

If your not used macros there's some great videos on the community for them Interactive Lessons - Alteryx Community. Ive attached the example workflow.

Any questions or issues please ask
HTH!
Ira

Example.yxzp

https://www.theinformationlab.co.uk/2018/07/12/downgrading-alteryx-workflows/

Hi,

Unfortunately my company system works on a older version of Alteryx and I am unable to open the file you have attached. Could you please post a few screenshots of the workflow and the configuration? I am sorry

Thanks

Qiu

@Nithinpanicker
You can try to downgrade the workflow.

Thanks Qiu. Followed the instructions on the site. Just a clarification, when I rezip the all the files back to .yxzp format and open it, I get a dialogue box asking me to import the files which I clicked Yes to but after that, nothing opens on Alteryx. I see the files have been extracted to my desktop and I can see the yxmc and yxmd file. Do I have to open them manually after that?

Is it possible to use workflow dependencies to solve this issue?

@Nithinpanicker,

I've attached both workflows and instructions if you cant get them to open. I would highly recommend looking at the macro videos on the community if you want to understand how they work.

Step two, save as a macro file:

Step 3 add macro to new workflow:

Step three, add a formula tool which just adds your file path constant to a record then use the regex tool configured like below:

Step 4, use the outputted regex to update the workflow each time:

Workflow 1.yxmd

Dynamic Username Input.yxmc

Hi @IraWatt ,

Thanks for your quick response. Yes I have started the lessons on macros to help me understand how to utilize them and breakdown the workflow you have provided.

Does the output also need to configured the same way the input was in order to have it in the same teams channel?

@Nithinpanicker If you save the workflow in the teams (sharepoint) folder, relative paths should work for you. I've done a similar thing with shared box drive paths and my coworkers have no issue.

I agree with @Luke_C SharePoint is a much cleaner option. If the outputs are to One Drive and your using the data output tool then yes though I would have a look at checking out the OneDrive tools see if they can provide a better solution: https://community.alteryx.com/t5/Public-Community-Gallery/OneDrive-Tools/ta-p/877893?utm_content=en&utm_source=designer_2022.1.1.25127_trial-False&utm_medium=global_search

Hi @Luke_C,

Thank you for your reply, Could you please explain how to set this up. I have tried going to options > advanced options > workflow dependencies. Selected the edit option and then selected relative. I can see that the filepath still has my username on it. I have attached a screenshot below for reference.

What should I do in order to make the username in the filepath also relative?

Thanks.

Worflow Dependencies.PNG

Hi @Nithinpanicker