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
Solved! Go to Solution.
fixed it, changed the items formula to this:
Sort(Distinct(Filter(Cohorts,Group = ComboBox1.Selected.Result),Title),Result)
fixed it, changed the items formula to this:
Sort(Distinct(Filter(Cohorts,Group = ComboBox1.Selected.Result),Title),Result)
Hi @neill_long ,
I just ran the syntax here as below and it delivered the expected result
What is the error you are getting?
I managed to fix this, I had put ComboBox.SelectedItems.Result, but changed that to ComboBox.Selected.Result
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.
User | Count |
---|---|
160 | |
84 | |
68 | |
63 | |
61 |
User | Count |
---|---|
209 | |
146 | |
95 | |
82 | |
67 |