Skip to main content
D
Dhruthi_g_y
July 26, 2024

Dynamic File Naming Based on Dashboard Selection

  • July 26, 2024
  • 2 replies
  • 0 views

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

M
Mike_Sabourin
July 27, 2024

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

T
TheJonG
July 29, 2024

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. 

Terms & ConditionsAccessibility statement