SharePoint Document Issues

How to Use Multiple AND and OR Conditions in a SharePoint View

Natalie Taylor Oct 1, 2026 868 views

Question details

The user needs to configure a SharePoint Online library view using multiple AND/OR filter conditions, but the current setup returns no items.

How to Use Multiple AND and OR Conditions in a SharePoint View

Product: SharePoint Online
Device & OS: not provided
Scenario: Filtering a document library view to show specific items (Contracts) based on a business pillar and multiple GRC statuses.
Observed behavior: The configured filters return no items instead of the expected filtered document list.

Before you start

Ensure you have the necessary permission level (such as Edit or Full Control) to modify or create views in the SharePoint document library, and verify that the columns you are filtering by contain the exact expected data.

Solution 1Recommended

Configure Grouped Logic for Multiple Filter Conditions

Set up the correct sequence of AND/OR operators to ensure the view evaluates the conditions together accurately without canceling each other out.

SharePoint evaluates filter logic strictly from top to bottom. When combining multiple conditions, you must sequence them so the broad OR conditions group correctly with the restricting AND conditions.

Access View Settings

Navigate to your SharePoint document library, click the 'View options' dropdown menu (typically at the top right of the library), and select 'Edit current view'.

Locate the Filter Section

Scroll down the settings page to the 'Filter' section and select the radio button for 'Show items only when the following is true'.

Set Primary OR Conditions

Set the first condition: Select 'GRC Status', choose 'is equal to', and type 'Current'. In the next row, select 'OR' from the dropdown, select 'GRC Status', choose 'is equal to', and type 'Under Review'.

Add Restricting AND Conditions

In the following rows, select 'AND', set 'Business Pillar' to 'is equal to' CCC. Add another 'AND' to set 'Item Category' to 'is equal to' Contracts. Click 'OK' to save and apply the grouped logic.

Configure Grouped Logic for Multiple Filter Conditions

Column Type Verification: Ensure your choice columns are correctly formatted and that exact text matches are used, as SharePoint filters are highly sensitive to spelling, spacing, and letter casing.

Solution 2

Create a New View to Reset Filters

If an existing view becomes corrupted or fails to apply new filters correctly, creating a new view from scratch often resolves the issue.

Solution 3

Test the View in an Incognito or InPrivate Window

Browser caching issues can sometimes prevent newly applied SharePoint view filters from displaying updated results.

Free Microsoft Office alternative

Enhance Your Document Workflow with WPS Office

While SharePoint handles cloud library management and online views, WPS Office serves as the perfect lightweight desktop alternative for opening, editing, and managing your downloaded Office documents locally. Enjoy a highly compatible and feature-rich suite for all your document needs.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
2. Install and Launch: Run the installer and open the application to instantly access Writer, Spreadsheet, Presentation, and PDF tools.
3. Edit Your Documents: Open your downloaded SharePoint files directly in WPS Office to experience seamless editing, formatting, and offline data filtering.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx), ensuring seamless edits to files downloaded from SharePoint.Advanced local filtering and sorting features in WPS Spreadsheet for managing complex datasets without relying on web views.Lightweight design with blazing-fast startup speeds, saving system resources.Free, familiar, tabbed user interface allowing you to handle Word, Excel, and PDF files in a single window without a steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint view show no items after adding an OR condition?

This usually happens when the logical order is incorrect. In SharePoint, AND/OR logic is evaluated strictly from top to bottom. If an OR condition conflicts with or disrupts a preceding AND condition, it may filter out all items. Ensure related OR conditions are grouped properly before adding restrictive AND statements.

Is there a limit to how many conditions I can add to a SharePoint view?

Yes, SharePoint allows you to add up to 10 filter conditions in a single view using the standard web interface. If your filtering logic exceeds this limit, you may need to use calculated columns to consolidate data points first.

Can I apply filters to Choice columns that allow multiple selections?

Yes, you can filter by multiple-selection Choice columns. However, you should use the 'contains' operator instead of 'is equal to'. This ensures the filter accurately captures items where your target value is just one of several selected choices.

Document & File Issues