Filtering Options in a ComboBox

[Granzo]

Good morning.

I am attempting to filter a ComboBox based on the selection of another ComboBox.

In my current situation, I have two ComboBoxes

Division
Team

I am trying to filter the list of Teams available based on the Division selected. So for example, I have two of the Divison options i have are.

-Metro Foster Care

-Metro Inact-EFS

If I were to select one of these selections, the Teams ComboBox would be filtered to display only the options that begin with the word "Metro". In this case, it should display 20 selections to choose from. 

How would I go about doing this? Any help would be greatly appreciated.

[Drrickryp · Accepted solution]

Hi @Granzo 

Have a TextInput box control (say TextInput1) and a Dropdown control (say Dropdown1)

Have the Dropdown control Items property as Filter(yourteamlist, StartsWith(Division,TextInput.Text))

Alternatively you could have two dropdown controls 

In the first one (say Dropdown1) make the Items property Distinct(yourteamlist,Division)

In the second one make the Items property Filter(yourteamlist,Division=Dropdown1.Selected.Result)

(Distinct produces a unique one column table with the field name "Result")