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.
Discussion posts and replies are publicly visible
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.
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.
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.