SharePoint Document Issues

How to Display SharePoint Choice Values in Column Order

Algirdas JasaitisAlgirdas Jasaitis Oct 20, 2026 869 views

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.

How to Display SharePoint Choice Values in Column Order
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.
Before you start

Verify your SharePoint permission levels, as implementing custom workflows or altering list functionality requires Site Owner or List Administrator privileges.

Solution 1Recommended

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.

1
Create a Power Automate Flow

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.

2
Initialize a Reference Array

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.

3
Sort and Update the Item

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.

Use Power Automate to Sort Choice Values
Advanced Configuration Required: Building this workflow requires intermediate knowledge of Power Automate data operations, loops, and array handling.
Free Microsoft Office alternative

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. 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. 2. Open Your Documents: Launch WPS Office and directly open any existing Microsoft Office files (.docx, .xlsx, .pptx) without needing complex conversions.
  3. 3. Edit and Save Seamlessly: Make your edits using the familiar interface and save your work instantly, ensuring perfect formatting retention across platforms.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formatsLightweight application that runs smoothly even on older or slower devicesFamiliar, intuitive user interface for a zero-learning-curve migrationBuilt-in PDF editing, conversion, and robust document collaboration tools
microsoft office alternative - wps office

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.