Search a SharePoint Document list by terms in 3 columns

[Cozzirm]

We are creating a document library and will be tagging each document based on 3 columns (Type, Industry, Service). Goal is to create a search function that will use those 3 columns to find relevant documents. Today we use MS Access to do that and want to eliminate Access. Thanks. 

[#2 · Accepted solution]

Hello @Cozzirm 

i recommend to use the PnP Modern Search WebParts with filters. You can filter with this 3 columns with AND or OR.

Build a page with filters:

https://microsoft-search.github.io/pnp-modern-search/scenarios/page-with-filters/

Regards, Dave

[#3]

@David Mehr  Thanks for the input. Looks like a solution to my problem.