cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neill_long
Helper V
Helper V

ComboBox filter

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

1 ACCEPTED SOLUTION

Accepted Solutions
neill_long
Helper V
Helper V

fixed it, changed the items formula to this:

 

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

View solution in original post

4 REPLIES 4
neill_long
Helper V
Helper V

fixed it, changed the items formula to this:

 

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

View solution in original post

WarrenBelz
Super User
Super User

Hi @neill_long ,

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

WarrenBelz_0-1622454515462.png

WarrenBelz_1-1622454538187.png

What is the error you are getting?

@WarrenBelz 

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

@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.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,895)