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?
Solved! Go to Solution.
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)
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.
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
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)
does Dataverse mean common data source?
Yes, it was renamed several months ago.
Here is an Idea in the Idea forum that refers to sorting option sets.
User | Count |
---|---|
183 | |
108 | |
88 | |
44 | |
42 |
User | Count |
---|---|
226 | |
108 | |
104 | |
68 | |
68 |