Share via

Filter values for SharePoint search result set

anantha rengan kannan 0 Reputation points
2024-03-06T00:36:52.31+00:00

If I have a search result set obtained from SharePoint online search query like below

Continent Country City
Asia India Chennai
Asia India Chennai
Asia India Delhi
Asia Sri Lanka Colombo
Europe France Paris
Europe France Lyon
Europe UK London

Is there a way in SharePoint search where we can get filter options like below (Like facets in Azure search https://learn.microsoft.com/en-us/azure/search/search-faceted-navigation)

Continent filter (distinct values of 'Continent' column from the result set)

Asia

Europe

Country filter (distinct values of 'Country' column from the result set)

India

Sri Lanka

France

UK

The option to achieve this should also work for even bigger result set obtained from SharePoint Search.

Can you enlighten on any options available in SharePoint search to achieve this?. Thanks

 

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,027 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,113 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,737 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ryan Hill 28,286 Reputation points Microsoft Employee
    2024-03-06T04:31:21.67+00:00

    Hi @anantha rengan kannan I am by no means a SharePoint expert, but hopefully a more knowledgeable individual can share some insights. I did, however, come across SharePoint Framework (SPFx) Extensions that may help. There is a Search Extension, https://learn.microsoft.com/en-us/sharepoint/dev/spfx/building-search-extensions, however it doesn't stipulate how to configure an Azure Search like index. There is also Tutorials and training for SharePoint Development | Microsoft Learn which may be helpful.

    I think the best bet is creating a search index from a SharePoint list. You look into using SharePoint indexer (preview) - Azure AI Search | Microsoft Learn which is an indexer that connects to your SharePoint document libraries; however, it may not support facets like what you're looking for.

    EDIT 7 Mar 2024 I've followed up with the product team. Filtering and faceting are independent of how and from where data is being pulled/pushed into the index. Once you've indexed the SharePoint data, you can apply the faceting yourself and filter the way you want.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.