
Announcements
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.
Hello @Anonymous
I understand that you are looking to have a type of "Sort order", have you tried to add the SortOrder.Ascending function to your formula?
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sort#syntax
If I misunderstood, could you please elaborate more in your question? How does the list is displaying if you enter the 14 scenarios? Could you post an screenshot?
Thanks.