SPO Modern: Searching how to filter on column values?

asked 2021-11-12T16:07:36.96+00:00
AConfusedUser 61 Reputation points

In the Modern Page experience it does not support filtering on column values the way the classic search experience did.

If I have documents with column values specified such as "Customer Name, Sales Division, Contract Team, Region" and I want to search for text matches in all the documents in my library BUT restrict where "Sales Division = Automotive" and "Region = NorthWest" it does not seem possible to do with modern search?

I can search for the text string "safety restraint defect" and get back all the documents that contain that string of text, but I need to be able to filter those to only see documents where "Sales Division = Automotive" and "Region = NorthWest". (Or whatever random filters the user wants to specify when searching).

Is there anyway to accomplish this?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,436 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
5,976 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-11-15T10:16:52.367+00:00
    Emily Du-MSFT 24,291 Reputation points Microsoft Employee

    @AConfusedUser

    Have you added list column into document library or site column into document library?

    For list column, you should go to SharePoint admin center -> More features -> Search -> Search Schema -> New Managed Property -> Click Queryable、Searchable and Retrievable, add the crawled property of the column as mapping.

    For site column, you should go to SharePoint admin center -> More features -> Search -> Search Schema -> Check whether the managed property of the column is Queryable、Searchable and Retrievable.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.