Cascading Dropdowns

Hello all,

I have 2 dropdowns that are filtering an aggregate. The 1st dropdown filters by a column, and the 2nd dropdown filters by another column.

For example, I selected a location but now I have 3 processes available and I want to have only process 1603.

My dropdowns are getting their options from a list which is the output of a DataAction.

More specifically, this DataAction queries the aggregate and it gets the distinct values of each column.

1st dropdown - location

2nd dropdown - process

How can I achieve this? Thank you :-)


Hi CB,

Wouldn't it be enough to add an "AND" to the WHERE clause with the second filter?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.