Dynamic File Naming Based on Dashboard Selection

Dhruthi_g_y
New Contributor

Hello All,

 

I have created a dashboard that includes the following features:

 

1. A combo box for selecting the year.

2. A button to initiate a backend process.

3. A button to retrieve an Excel file (using web content component).

 

Dhruthi_g_y_0-1721995507449.png

 

This dashboard has been integrated into a workflow. I am working on a requirement where the generated Excel file should be named as "scenarioName_YearChosenInDashboard". For instance, if the years 2022 and 2023 are selected in the dashboard and the "Plan" scenario is chosen in the workflow, the file should be named "Plan_2022_2023".

 

I have managed to fetch the scenario from the workflow, but I am currently facing challenges in retrieving the selected year(s) from the dashboard.

 

Could you please assist me in resolving this issue?

 

Thank you.

2 REPLIES 2

Michel_Sabourin
Contributor II

Best way is to assign the combo box value to a literal parameter on selection, and call the parameter in the naming 

TheJonG
Contributor II

Hi - could you provide a bit more context? Where are you calling the parameters exactly? I am assuming its within the 'URL or Item Name' property of the Web Content component. Are you getting an error or is the file just not generating?

You should be able to reference the parameter using |!ParameterName!|. Since your component is multiselect, make sure you put square brackets around the parameter.