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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,177)