Power Platform Community Forum Thread Details

I need to custom sort by combobox. This is what I have in my onvisible for the combobox ollect(
coll,
Sort(
Distinct(
GUAT2,
Scenario
),
Result
)
). This isn't working because one it gets to Scenario 10 it puts it at the top but it needs to be in order or ascending numbers. I was trying something like this but couldn't get it to work. SortByColumns(GUAT2, Scenario, [ Scenario 1, Scenario 2, Scenario 3]). I have 14 scenarios.