ComboBox filter

[neill_long]

Hello,

I have 2 comboboxes: 

1 which lists course names and the other lists the course codes associated to the selected course name.

On the first, ComboBox, i have in the items - 

Sort(Distinct(Cohorts,Group),Result)

On the 2nd ComboBox, i want the results to only show the course codes that are associated with the selected course name.  I have the following formula:

Sort(Distinct(Filter(Cohorts,Group=ComboBox1.SelectedItems.Result),Title),Result)

But this is giving me an error.   Is this possible to achieve on a ComboBox and if so, can someone help please?

thanks

[neill_long · Accepted solution]

fixed it, changed the items formula to this:

Sort(Distinct(Filter(Cohorts,Group = ComboBox1.Selected.Result),Title),Result)

[WarrenBelz]

Hi @neill_long ,

I just ran the syntax here as below and it delivered the expected result

What is the error you are getting?

[neill_long]

@WarrenBelz 

I managed to fix this, I had put ComboBox.SelectedItems.Result, but changed that to ComboBox.Selected.Result

[WarrenBelz]

@neill_long ,

That is interesting as SelectedItems are deprecated (I use .Selected), but that is the first time I have heard of an actual error, so they must now be redundant.