SPO Modern: Searching how to filter on column values?

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

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.
2,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,628 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 41,786 Reputation points Microsoft Vendor
    2021-11-15T10:16:52.367+00:00

    @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.