SharePoint list column added to list index to improve the column performance when filter content as it improves the performance of query operations which can include filters, sorting and joins on index columns. You can add single column index or two column indices for a list. Index column are similar to index column in database, but these are stored in SharePoint as they are Name value pair instead of SQL Server. You can not add an index column if no. of items in a list exceeds 20000 list items, so you need to add them before it crosses the 20K limit. You can add up to 20 indices for a list. Not all list

SharePoint list ID column is by default an index column. You can add single line text, number, date, Boolean and metadata fields as list item index. Whereas, you can add multiline text, Hyperlink/Picture and calculated fields to list index. Choice and Person or Group can be added to the list index if they are single value.

Below table shows the list of supported and unsupported field for list indexing

Supported Field Types Unsupported Field Types
Text (Single Line) Text (Multiline Line)
Choice (Single value) Choice (Multi value)
Person or Group (Single value) Person or Group (Multi value)
Number Hyperlink/Picture
Date & Time Calculated
Currency External Data
Lookup Custom Column
Managed Metadata  
Boolean (Yes/no)  

list index column supported and unsupported types

Adnan, a distinguished professional, boasts an impressive track record as a Microsoft MVP, having achieved this prestigious recognition for the eighth consecutive year since 2015. With an extensive career spanning over 18 years, Adnan has honed his expertise in various domains, notably excelling in SharePoint, Microsoft 365, Microsoft Teams, the .Net Platform, and Microsoft BI. Presently, he holds the esteemed position of Senior Microsoft Consultant at Olive + Goose. Notably, Adnan served as the MCT Regional Lead for the Pakistan Chapter from 2012 to 2017, showcasing his leadership and commitment to fostering growth within the tech community. His journey in the realm of SharePoint spans 14 years, during which he has undertaken diverse projects involving both intranet and internet solutions for both private and government sectors. His impact has transcended geographical boundaries, leaving a mark on projects in the United States and the Gulf region, often collaborating with Fortune 500 companies. Beyond his roles, Adnan is a dedicated educator, sharing his insights and knowledge as a trainer. He also passionately advocates for technology, frequently engaging with the community through speaking engagements in various forums. His multifaceted contributions exemplify his dedication to the tech field and his role in driving its evolution.

Leave a Reply