Fix SharePoint Yes/No Column Ignoring Default No Value
Question details
Users are experiencing an issue where a SharePoint Yes/No column configured with a default value of 'No' automatically saves as 'Yes' when new items are created.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Creating new items in a SharePoint list or modern team site using the modern interface.
- Observed behavior
- The system ignores the default 'No' value and assigns 'Yes' to newly created items, which unexpectedly triggers automated emails and workflows.
Ensure you have Site Owner or List Administrator permissions to access and modify the backend List Settings in your SharePoint site.
Reconfigure the Column Default via Classic List Settings
Bypass the modern interface bug by resetting and saving the default value directly in the backend SharePoint List Settings.
The modern SharePoint interface occasionally fails to properly commit default values for boolean (Yes/No) columns. By navigating to the classic List Settings page, you can force the system to register the correct default value.
Navigate to your SharePoint list, click the gear icon (Settings) in the top right corner, and select 'List settings' from the dropdown menu.
Scroll down to the 'Columns' section and click on the specific Yes/No column that is ignoring the default value.
Under the 'Default value' section, even if 'No' is selected, toggle it to 'Yes', then immediately toggle it back to 'No'. Click the 'OK' button at the bottom of the page to force a save.
Return to your modern list view and create a new item to verify if the default 'No' is now correctly applied without triggering automated emails.

Document and Report the Bug to Microsoft Support
If the backend list settings workaround fails, the issue is an unresolved bug in the SharePoint modern experience that requires escalation.
Try WPS Office for Seamless Document Management
While you troubleshoot SharePoint list bugs, ensure your team's document creation remains uninterrupted. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for creating, editing, and sharing documents across all platforms.
- 1. Download the installer: Visit the official WPS Office website and click the 'Download WPS Office Free' button.
- 2. Install the application: Run the downloaded installation file and follow the on-screen instructions to set up the software on your device.
- 3. Open your files: Launch WPS Office and open your existing Microsoft Office documents directly to experience seamless format compatibility.

Frequently Asked Questions
Why is my SharePoint column triggering automated emails by mistake?
If you have an automated workflow (like Power Automate) tied to a Yes/No column, a known bug in the modern SharePoint interface may force the column to default to 'Yes' upon item creation, which falsely triggers the logic designed to send the email.
Does this default value bug occur in classic SharePoint sites?
Users primarily report this issue occurring in the modern interface and modern team sites. Switching to classic list settings to configure the column often serves as an effective workaround because the classic backend properly registers the default boolean value.
Can I use a different column type to avoid this SharePoint bug?
Yes. As a temporary but highly reliable fix, you can replace the failing Yes/No column with a standard 'Choice' column. Set the available choices to 'Yes' and 'No', configure a dropdown menu, and set 'No' as the default value.




