How to Display SharePoint Choice Values in Column Order
Question details
Users need selected multiple-choice values in a SharePoint list to display in the order predefined in the column settings, rather than the chronological order in which they were selected.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Viewing, organizing, or presenting multiple-choice list data in SharePoint.
- Observed behavior
- Selected choice values currently appear in the exact order users click them, completely ignoring the predetermined master order configured in the column settings.
Verify your SharePoint permission levels, as implementing custom workflows or altering list functionality requires Site Owner or List Administrator privileges.
Use Power Automate to Sort Choice Values
Since SharePoint lacks a built-in feature to sort selections by default, you can create a Power Automate flow to intercept and reorder the selected choices based on your predefined criteria.
SharePoint currently does not provide a native setting to force selected choices to respect the column's master order. A custom Power Automate flow is the most reliable way to achieve this automation in the background.
Navigate to the Power Automate portal and create an automated cloud flow that triggers whenever an item is created or modified in your specific SharePoint list.
Add an action to initialize an array variable. Input the correct, predefined order of your choice values into this array so the flow has a master list to reference.
Use data operations (such as 'Filter array' or 'Apply to each') to compare the user's selections against the master array, reorder them accordingly, and use the 'Update item' action to save the sorted values back to SharePoint.

Submit Feedback or Request Custom Scripts
If using Power Automate is not viable, you can explore custom code solutions from the developer community or request a native feature update from Microsoft.
Experience Seamless Document Management with WPS Office
While SharePoint and Microsoft 365 offer extensive enterprise list features, they can sometimes overcomplicate simple document management and editing tasks. WPS Office provides a free, lightweight, and highly compatible alternative for your team's word processing, spreadsheet, and presentation needs without the steep learning curve or complex configurations.
- 1. Download and Install: Get the free WPS Office installer from the official website and install it on your PC, Mac, or mobile device.
- 2. Open Your Documents: Launch WPS Office and directly open any existing Microsoft Office files (.docx, .xlsx, .pptx) without needing complex conversions.
- 3. Edit and Save Seamlessly: Make your edits using the familiar interface and save your work instantly, ensuring perfect formatting retention across platforms.

Frequently Asked Questions
Why do SharePoint choice columns sort by selection order?
By default, SharePoint stores multiple-choice selections in an array based on the exact chronological sequence in which the user clicked the options. It does not automatically reference or cross-check the master column list for display sorting.
Can I fix the choice value order using SharePoint column validation?
No, column validation formulas are strictly used to ensure data integrity (e.g., verifying a specific condition is met before saving) and cannot dynamically reorganize or sort the display order of the selected items.
Will Microsoft add a native feature to sort choice selections?
Microsoft frequently updates SharePoint based on user feedback. While no official release date exists for a native choice-sorting feature, submitting a request through the Microsoft Feedback portal increases its visibility to the product development team.
Does formatting the column with JSON help reorder the choices?
Column formatting with JSON can change how values look (like adding background colors, borders, or icons) but it cannot alter the underlying sequential order of the array elements. Reordering data requires a workflow like Power Automate or SPFx extensions.




