I have a combobox with the following code for items:
Combobox_CTC_4.Items=
Filter( Sort(_ChargeTypes, ChargeTypeCode), ChargeGroupCode = First(ComboBox_CGC.SelectedItems).Result )
_ChargeTypes is a collection that looks something like this:
The items in Combobox_CTC_4 are filtered so their ChargeGroupCode matches the ChargeGroupCode picked in another combobox (Combobox_CGC).
I get 2 errors on Combobox_CTC_4:
The weird thing is, the combobox functions properly. I still get the little red error icon next to the combobox, but I go into the code and there are no red underlines anywhere.
I've tried saving and restarting the studio but it still remains...
Solved! Go to Solution.
There are few things I am not placing but one thing I know right off is your order is off. Sort goes before Filter and also I don't see where you are telling it what to sort by and Ascending or Descending either.
It goes like this:
Sort(Filter(DataSoure, Column1="FilterInfo"),"ColumnSortedBy",Ascending)
There are few things I am not placing but one thing I know right off is your order is off. Sort goes before Filter and also I don't see where you are telling it what to sort by and Ascending or Descending either.
It goes like this:
Sort(Filter(DataSoure, Column1="FilterInfo"),"ColumnSortedBy",Ascending)
What is the formula for the Items property of ComboBox_CGC?
Thank you @rebeccas, switching the order of Sort and Filter fixed it.
P.S.
I was sorting the collection _ChargeTypes by the column ChargeTypeCode. Also, I left out Ascending/Descending because it defaults to Ascending.
New Code:
Sort( Filter(_ChargeTypes, ChargeGroupCode = First(ComboBox_CGC.SelectedItems).Result), ChargeTypeCode )
User | Count |
---|---|
232 | |
109 | |
94 | |
58 | |
29 |
User | Count |
---|---|
292 | |
126 | |
106 | |
62 | |
57 |