Fix SharePoint Yes/No Column Default Keeps Changing to Yes
Question details
The user is trying to set the default value of a SharePoint Yes/No column to 'No', but the setting fails to save properly.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Configuring list settings and updating default column values in a SharePoint list.
- Observed behavior
- After changing the Yes/No column default value to 'No' and saving the list, the default value automatically changes back to 'Yes'.
Ensure you have Site Owner or Full Control permissions for the SharePoint site, and verify that no active Power Automate flows or custom site scripts are overriding your list settings.
Isolate the Scope of the Issue and Contact Support
Determine if the reverting column behavior is isolated to a specific list or affects the entire SharePoint environment before escalating the issue.
Backend synchronization issues or environment-wide bugs can occasionally cause SharePoint list settings to revert. By testing different variables, you can help Microsoft Support pinpoint the exact cause faster.
Create a brand-new list in the same SharePoint site. Add a Yes/No column, set the default to 'No', and save it to see if the issue persists.
Navigate to a completely different site within your organization's tenant and repeat the column configuration process to check for site-specific corruption.
Ask a colleague with appropriate site permissions to log in and attempt to change the Yes/No column default value to 'No'.
If the problem occurs in every list, on new lists, across different sites, and for multiple users, contact your Microsoft 365 Administrator to open a support ticket for environment-level investigation.
Looking for a Smooth Office Experience? Try WPS Office
While you wait for backend SharePoint issues to be resolved by Microsoft support, experience a hassle-free, lightweight, and highly compatible productivity suite with WPS Office. It provides powerful word processing, spreadsheets, and presentation tools completely free of charge.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen prompts to set up the software on your computer.
- 3. Open Your Documents: Launch WPS Office and directly open any existing Microsoft Word, Excel, or PowerPoint files without losing formatting.

Frequently Asked Questions
Why does my SharePoint list column default value keep reverting?
This can be caused by backend synchronization delays, browser cache issues, conflicting site scripts, or active Power Automate flows that overwrite your manual list configurations upon saving.
Can a Power Automate flow change my default column values?
Yes. If a Power Automate flow is triggered when an item is created or modified, it can forcefully update the item's fields, effectively bypassing or overwriting the default values set in the SharePoint list settings.
How do I open a support ticket for an environment-wide SharePoint issue?
You must reach out to your organization's Microsoft 365 Administrator. They have the required access to log into the Microsoft 365 Admin Center, navigate to the 'Support' section, and create a new service request for Microsoft engineers to investigate.




