Sorting a gallery by a choice data type

[morall]

Sort(Filter('Source', Candidate.'ID'=Gallery1.Selected.'ID'), InterviewStatus, Descending)

InterviewStatus is a Choice data type in a Common Data Source.

I am getting this error: Cannot sort on expression type.

Is there a way to sort a gallery based on a Choice selection?

[RandyHayes]

@morall 

Please consider changing your Formula to the following:

Sort(
    AddColumns(
        Filter('Source', Candidate.'ID'=Gallery1.Selected.'ID'), 
        "_interviewStatus", InterviewStatus.Value
    ),
    _interviewStatus,
    Descending
)

I hope this is helpful for you.

[morall]

When I try InterviewStatus, it doesn't give me the ".Value"
When I try:

Sort(
AddColumns(
Filter(
Source',Candidate.'ID' = Gallery1.Selected.'ID'
),
"displayOrder", 'Created On'
),
"displayOrder",
Descending
)

Its not changing the order even though no errors are showing

[RandyHayes · Accepted solution]

@morall 

Sorry, I missed that you are using Dataverse. This is a known issue that you cannot sort optionsets. (at least as far as I know)

[morall]

does Dataverse mean common data source? 

[RandyHayes]

@morall 

Yes, it was renamed several months ago.

Here is an Idea in the Idea forum that refers to sorting option sets.