Set Input File Name and Workflow Constants via File

[terrence10]

Hello,

I currently have a workflow that prompts the user for two file inputs and a date via text box and action tools:

  

The two filename prompts update the file that is imported, and the date prompt is used in the formula tool through a reference shortcut "%Question.Date%".

Ideally, I would like the user to load in a file with these inputs instead of entering it in manually via prompts. A user would load in a file like this:

And the workflow will know to

1. Update Input Data tool 1 to use Inputfile1

2. Update Input Data tool 2 to use Inputfile2

3. Save the "Date" value into a workflow constant "%Question.Date%" that I can refer to using a reference shortcut in the workflow

Is it possible to load in "Prompt inputs" or workflow constants via a file input? My Sample workflow is attached with the inputfiles.

Thanks

[binuacs · Accepted solution]

@terrence10 if you dont want the user to interact with the drop down then use the batch macro to read the path from input file and do the processing, sample workflow attached

[terrence10]

Thank you @binuacs  ! Makes sense to load values and then pass as a macro to input - will have to see what the best way to incorporate this into my workflow.

I see you also pass the date via the macro and update value-- guess there isn't an easy way to load this from file to workflow constant?

Thanks again!