SharePoint Document Issues

Fix Microsoft Lists Choice Values Missing in Conditional Formatting

WPS Content Manager Oct 9, 2026 869 views

Question details

Users are unable to see configured choice values in the value selector when creating conditional formatting rules for an empty Choice column.

How to Fix Microsoft Lists Choice Values Missing from Conditional Formatting Rules

Product: Microsoft Lists / SharePoint Online
Device & OS: not provided
Scenario: Setting up a conditional-formatting rule for a Choice column before any list items have been created.
Observed behavior: Configured choices do not appear in the formatting value selector. After a list item uses one choice, only that specific choice becomes available for rule creation.

Before you start

Ensure you have Site Owner or Administrator permissions in your SharePoint Online environment, as you will need to create test lists and potentially capture diagnostic logs for Microsoft Support.

Solution 1Recommended

Test with a New SharePoint List and Recreate the Column

Isolate the problem by verifying if the conditional formatting bug is specific to your current list or corrupted column data.

Sometimes SharePoint list columns experience backend corruption where metadata fails to sync with the conditional formatting UI. Recreating the list or column is the fastest way to determine if this is a localized glitch.

Create a new test list

Navigate to your SharePoint site homepage, click the 'New' button, select 'List', and choose 'Blank list'.

Add a new Choice column

In your newly created list, click 'Add column', select 'Choice', and enter several test choice values.

Test conditional formatting

Click the column header, navigate to 'Column settings' > 'Format this column', and try to set up a conditional formatting rule to see if all values appear in the selector.

Apply to the original list

If the choices appear correctly in the test list, return to your problematic list, create a brand-new Choice column, and configure your formatting rules there.

Test with a New SharePoint List and Recreate the Column

Diagnostic Tip: If recreating the column in the original list resolves the missing values, you can safely migrate your data to the new column and delete the corrupted one.

Solution 2

Collect HAR Logs and Open a Microsoft 365 Support Ticket

If the missing choices issue persists across all new lists, it indicates a tenant-wide bug requiring investigation by the Microsoft development team.

Free Microsoft Office alternative

Experience Seamless Productivity with WPS Office

While dealing with web-based SharePoint and Microsoft Lists bugs can be frustrating, your core document and spreadsheet work shouldn't be interrupted. WPS Office offers a free, lightweight, and highly compatible desktop alternative to Microsoft Office. Manage tabular data, apply robust conditional formatting, and seamlessly transition your Word, Excel, and PowerPoint files without formatting issues.

1. Download the Installer: Visit the official WPS Office website and click the Free Download button to get the setup file.
2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions to install the software.
3. Open Your Documents: Launch WPS Office and instantly open your existing Microsoft Excel, Word, or PowerPoint files with perfect formatting and offline reliability.

Manage tabular data and apply robust conditional formatting locally with WPS Spreadsheet, avoiding web-app sync bugs.Fully compatible with Microsoft Office file formats, including .docx, .xlsx, and .pptx.Lightweight desktop application that runs smoothly on almost any device without internet dependency.Familiar tabbed user interface, ensuring a zero-learning-curve migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Microsoft Lists conditional formatting choices disappear?

This is often caused by a web-sync glitch or UI bug in SharePoint Online where the conditional formatting menu fails to fetch the configured choice metadata until those values are actively stored and indexed in a list item.

Does this missing choice issue affect all users in SharePoint Online?

Not always. Testing shows that creating a new list often resolves the issue, indicating it might be a localized data corruption in a specific list or column rather than a universal Microsoft 365 service outage.

What are HAR logs and why does Microsoft Support need them?

HAR (HTTP Archive) logs record the network requests and responses between your browser and the SharePoint server. Microsoft Support uses them to pinpoint exactly where the background data retrieval for the Choice column is failing.

Document & File Issues