Skip to main content
P
purvajab0002
November 9, 2021
Solved

Configure Cascading Dropdowns from tables.

  • November 9, 2021
  • 3 replies
  • 0 views

Hi,

I have a requirement where I have to create two dropdown fields but second dropdown will depend upon first. Suppose user selects one option from the first dropdown then according to that option second dropdown show options. 

The values of the dropdown are from two columns of same table. 

Can anyone please tell how can I get values to the dropdown from the table.

Please share any resources which will be helpful.

https://docs.appian.com/suite/help/21.3/recipe-configure-cascading-dropdowns.html

I'm looking similar to the above one but from the table not hard-coded one.

Thank you.

Best answer by pavang5769

Ok, lets assume you are fetching the data from database and storing into a local variable. For the first dropdown we use columnOne for displaying the values and store the corresponding columnOne value into variable1. Now we try to filter the data based on value in variable1 and get the list from columnTwo. We can achieve this by indexing(index-function) the data. And we pass the filtered list to second dropdown as choicelabels and choicevalues.

3 replies

pavang5769
pavang5769
November 9, 2021

Hi, Can you please attach the error and code which you are facing in configuration. Ideally, you should filter the data in the first dropdown saveinto and pass them to the second dropdown.

P
purvajab0002Author
November 9, 2021

Hi, I wanted to know how can we do using expression rule. So that I can implement. I've done the same using decision rule by hard-coding all the values.

pavang5769
pavang5769Answer
November 9, 2021

Ok, lets assume you are fetching the data from database and storing into a local variable. For the first dropdown we use columnOne for displaying the values and store the corresponding columnOne value into variable1. Now we try to filter the data based on value in variable1 and get the list from columnTwo. We can achieve this by indexing(index-function) the data. And we pass the filtered list to second dropdown as choicelabels and choicevalues.

    Terms & ConditionsAccessibility statement