2
Currently, when sorting a view based on an Option Set column, the view will sort based on the alphabetical order of the Label of the Option Set Values.
However, there are occasions when the values of an Option Set represent a sequence that have a meaningful order, independent of their alphabetical order. It would be nice to be able to sort a View based on the sort order defined for the option set values themselves, rather than alphabetically based on the label.
The only way to accomplish this today, is to prepend ordering information into the label itself "A - First Item", "B - Second Item", etc. or "01 - First Item", "02 - Second Item", etc. which is not desirable.
However, there are occasions when the values of an Option Set represent a sequence that have a meaningful order, independent of their alphabetical order. It would be nice to be able to sort a View based on the sort order defined for the option set values themselves, rather than alphabetically based on the label.
The only way to accomplish this today, is to prepend ordering information into the label itself "A - First Item", "B - Second Item", etc. or "01 - First Item", "02 - Second Item", etc. which is not desirable.
STATUS DETAILS
Needs Votes
Comments
Given that there's a display order for a choice column that controls the UI on forms and for filtering a view, it seems strange that ordering in views/FetchXML for choices is alphabetical only.If this needs to be limited to only one way of doing it, alphabetical seems to me to be the wrong way of doing it.
Category: Unified Experience: Search, navigation and performance
Administrator on 8/19/2020 5:24:22 PM
Thank you for your feedback. Currently this is not in our roadmap; however, we will track it ,if we get more feedback and votes, we may consider it in the future.
Sincerely,
Meenakshi
PM, Microsoft.