Forum Discussion

johnjohn-Peter's avatar
johnjohn-Peter
Iron Contributor
Aug 24, 2024

search large lists using calculated columns, even that we cannot add calculated columns as index

Inside SharePoint online we cannot index calculated columns at the list level, so we cannot filter large lists based on the calculated columns inside list views. but what about Search? can we search large lists using calculated columns and sort the search results based on the calculated columns? In other words, is there a relation between index at list level and the ability to search calculated columns?

As I have large lists which might contain 100,000 items in the future for each, and i am using PnP Modern search web part to show data from those lists. i want to be able to filter the PnP Search result using the calculated column, so is this achievable? or since we cannot add calculated columns inside list indexes then this mean that we will not be able to filter and sort Search Results using this calculated column? or this is not the case?

Thanks

No RepliesBe the first to reply