I'd like to be able to filter and sort my combo box values. I've been able to filter and sort a dropdown list using this method;
Sort(Filter(Employees,IsBlank(TermDate)),FullName)
but for some reason it doesn't work for a combobox. Am I missing something or is this just not supported? I found someone else trying to limit their choices
https://powerusers.microsoft.com/t5/General-Discussion/Filter-Choices-for-Combo-Box/m-p/90894#M34274
and used a filtered collection to do this but that seems a bit cumbersome when a simple filter and sort should work.
User | Count |
---|---|
156 | |
97 | |
87 | |
78 | |
58 |
User | Count |
---|---|
190 | |
180 | |
107 | |
95 | |
91 |