How to Filter SharePoint Modern News Web Part by Multiple Conditions
Question details
The user needs to apply AND logic when filtering the SharePoint Modern News Web Part with multiple conditions and wants to resolve issues with calculated columns not showing as managed properties.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Configuring a Modern News Web Part to display specific news posts based on multiple custom column criteria.
- Observed behavior
- The web part uses OR logic instead of AND logic for multiple filters. Additionally, calculated columns create crawled properties, but manually mapped managed properties are not immediately recognized by the web part.
Ensure you have Site Owner or Full Control permissions to modify the site's Search Schema and configure web parts on the page.
Work Around OR Logic and Synchronize Managed Properties
Understand the default filtering behavior of the News Web Part and properly map properties to enable custom filtering.
By design, the SharePoint Modern News Web Part applies OR logic when you add multiple different column filters. Unfortunately, switching to AND logic for separate properties is not natively supported in the web part's UI.
Furthermore, calculated columns only automatically generate crawled properties, not managed properties. To filter by these values, manual mapping and a waiting period for search indexing are required.
Accept that combining multiple distinct column filters (e.g., NewsType and NewsScope) will natively result in OR logic (displaying posts matching either condition). If strict AND logic is required, consider using the Highlighted Content Web Part instead, which offers more advanced query options.
Navigate to Site Information > View all site settings > Search Schema. Search for the crawled property generated by your calculated column.
Create a new managed property (or use an existing Refinable property like RefinableString00). Map your crawled property to this managed property, ensuring you check the boxes for 'Queryable' and 'Retrievable'.
Allow at least 24 hours (sometimes up to 48 hours) for SharePoint's background search crawler to index the new managed property. It will not appear in the News Web Part filter dropdown until this synchronization is complete.
Enhance Your Document Workflow with WPS Office
While SharePoint handles your team's intranet and news, you still need a reliable, efficient office suite to create the documents you share. WPS Office provides a lightweight, fully compatible alternative to Microsoft Office for all your document needs.
- 1. Download the Installer: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install WPS Office: Run the setup file and follow the brief on-screen instructions to install the suite on your computer.
- 3. Open Your Documents: Launch WPS Office to seamlessly open, edit, and save your existing Office documents with perfect format retention.
Frequently Asked Questions
Why does the SharePoint News Web Part use OR logic instead of AND logic?
By design, when you select multiple different properties to filter by in the Modern News Web Part, SharePoint applies OR logic to show posts that match any of the selected conditions. AND logic is currently not supported for combining different column filters in this specific web part.
Why can't I see my calculated column in the News Web Part filter list?
Calculated columns automatically generate crawled properties but do not create the managed properties required for web part filtering. You must manually map the calculated column's crawled property to a queryable managed property in the Search Schema.
How long does it take for a newly mapped managed property to become available?
In SharePoint Online, it typically takes between 24 and 48 hours for the search index to fully crawl and synchronize a new or modified managed property. It will not appear in the web part filters until this background process finishes.
Is there an alternative web part that supports AND logic for multiple filters?
Yes. If you require strict AND logic, consider using the Highlighted Content Web Part (HCWP). The HCWP allows you to build custom KQL (Keyword Query Language) queries, giving you granular control over AND/OR logic when pulling in site content.
