User Workflow Constant Update

[knnwndlm]

Hi SME,

I have a complicated workflow that has an user workflow constant (Year) permeated throughout.  I have to update this constant for multiple times for each run.  For example, if I have to run the workflow for 5 years, I would have to update the constant five times for each run. 

I have built an iterative macro to give me a dynamic input for a list of years, but I'm unclear on how to use it to change the user workflow constant so that I don't have to do it manually one at a time for multiple years.

Could you please provide some insights on how I can approach this problem?

Thanks,

kwl

[geraldo]

@knnwndlm 

could this entry be reading an excel file for example?

[knnwndlm]

Hi @geraldo 

Unfortunately, the workflow is huge and complicated so it would not make sense to rebuild it.  Also, we don't want to hook up all the changes to the specific locations where the user workflow constant is being used.  We want to see if there's a way to use the iterative macro as a replacement of the user workflow constant so that we can run the workflow through the number of years indicated via the user workflow constant.

Thanks,

kwl

[geraldo]

@knnwndlm 

I would need to have an example of how the workflow that makes the first activation is, without this it is difficult to identify which is the best solution for your problem

[knnwndlm]

@geraldo 

Here's a sample example. While this is just a simple example, you can tell that it can get quick intricate to replace everything manually if you already have a workflow setup to depend on the user workflow constant.  

We just want to figure out a way to update the user workflow constant in the Workflow configuration from the canvas so that we don't have to update the value at every single location.

Appreciate your help.

Thanks,

kwl

[geraldo]

@knnwndlm 

Could this sample stream instead of yxmd become batch macro yxmc?

and this iterative macro that you created could not pass a parameter to this workflow, but it would become a batch macro.

[geraldo]

@knnwndlm 

I made a change in the workflow parameters and in the filter tool

\Just an idea to generate several years

[flying008]

Hi, @knnwndlm 

IMHO, The user workflow constant only must be modify by manual input. so maybe you need to use a batch macro or append parameters.

[knnwndlm]

@geraldo - While the workflow does what I want, it doesn't change the user workflow constant - something that needs to be updated. 

@flying008 - From my research, it looks like this is the only way to do it.  Perhaps, I can set a user workflow to one year and create another variable to enable the Batch Macro to do this.

Thank you Both!

[geraldo]

@knnwndlm 

How is this flow executed?
Does it run on the server?
Depending on how it is executed, you can make this first flow an app and pass a parameter to it.