How to manage a Managed Metadata site column which allow multiple selection for large document library (since we can not index it)

Question

We have created a document library inside our SharePoint online site to manage our customer documents >> and we added a site Column of type Managed Metadata to tag the documents with the related customer/s.

Each document will be tagged to either specific customer/s or to All (we currently have 250 customers), as follow:-

now the problem is that the document library will contain millions of documents and we need to index the Managed Metadata site column, but since this Managed Metadata site column allow multiple sections so it can not be indexed. so in this case how we can link a document with multiple customers ?

One solution but not sure if it will work, is to create for example 10 site columns which are linked to the customer term store >> and each site column allow single selection (so we can index them) >> so we will have 10 crawl properties >> then we can create one managed property which contains the 10 crawl properties >> so users can filer the document library using the manged property inside the PnP Modern search web part >> and the managed property will cover the 10 crawl properties.. will this work? or there is a better solution to our issue?

Thanks

Answer 1

Hi @john john ,

How about let users search directly in the document library? From my point of view, this is a more easy and acceptable method for users. Like this:

---

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.