Column indexing

SharePoint lists and document libraries allow for the indexing of properties (columns). Column indexing can have a big positive impact on performance of your canvas apps because data is returned faster when retrieving data using the “Filter” or “Lookup” function and the columns used are indexed.

You must have sufficient rights on a list/document library to configure column indexing. The following default permission levels allow this:

  • Design
  • Edit
  • Full Control

Below, the steps are given on how to index a column.

  1. Go to settings page of the list/document library.
  2. Scroll down until you see the link Indexed columns in the section Columns.
  3. Click on this link.
  4. Click on Create a new index.
  5. Select the primary column.
    • Some property types also allow for a secondary column for the index.
  6. Click on the button Create.

The overview below shows for which column types indexing is available and for which not.

Column typeAvailableNot available
Choice (Single select)X
Choice (Multiple select)X
Date and TimeX
Hyperlink or PictureX
Multiple lines of textX
Person or Group (Single select)X
Person or Group (Multiple select)X
Single line of textX

The following column types allow for a secondary column index:

  • Currency
  • Lookup
  • Number
  • Person or Group (Single select)
  • Yes/No


This video demonstrates how to add an index to a column in a SharePoint list and a SharePoint document library:


Add an index to a list or library column:


Please enable JavaScript in your browser to complete this form.

You can use the form below to submit feedback if you think that content on this page:

  • is wrong. Please then also provide what is wrong and why.
  • could be more comprehensive. Please then also provide which content should be added/updated.

Thank you!