SharePoint Document Issues

Fix SharePoint Yes/No Column Ignoring Default No Value

Camila MilosovichCamila Milosovich Oct 12, 2026 869 views

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.

Fix SharePoint Yes/No Column Ignoring Default No Value
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.
Before you start

Ensure you have Site Owner or List Administrator permissions to access and modify the backend List Settings in your SharePoint site.

Solution 1Recommended

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.

1
Access list settings

Navigate to your SharePoint list, click the gear icon (Settings) in the top right corner, and select 'List settings' from the dropdown menu.

2
Locate the problematic column

Scroll down to the 'Columns' section and click on the specific Yes/No column that is ignoring the default value.

3
Toggle and save 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.

4
Test item creation

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.

Reconfigure the Column Default via Classic List Settings
Workaround Alternative: If the Yes/No column continues to fail, consider deleting it and creating a 'Choice' column instead. Provide 'Yes' and 'No' as choices, and set 'No' as the default. This often bypasses the modern boolean bug.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and click the 'Download WPS Office Free' button.
  2. 2. Install the application: Run the downloaded installation file and follow the on-screen instructions to set up the software on your device.
  3. 3. Open your files: Launch WPS Office and open your existing Microsoft Office documents directly to experience seamless format compatibility.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Familiar, intuitive user interface requiring zero learning curve for Office users.Lightweight software architecture ensuring fast document loading times.Built-in PDF editing toolkit for comprehensive document workflows.
microsoft office alternative - wps office

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.