Index Columns in SharePoint Online - How to create indexed column in SharePoint

The Power of Index Columns in SharePoint Online: Simplify Your Data Management – create step by step

One comment

Loading

In this “Index columns in SharePoint Online” article, we will learn how to create the indexed column in SharePoint both in SharePoint Online and on-premise, step by step. When we talk about the slowness of SharePoint list view loading, we go with indexing the column.

Introduction – Index columns in SharePoint Online

If you are not clear about what indexing actually is – I would recommend reading my previous article how does the database column indexing work in SharePoint. In this example, I will show how to create an indexed column in the SharePoint List.

SUPPORTED COLUMN TYPES in indexing

  • Single line of text
  • Choice field (but not multi-choice)
  • Number
  • Currency
  • Date/ Time
  • Lookup (but not multi-value)
  • Person or Group (but not multi-value)
  • Title (but not in a document library)

UNSUPPORTED COLUMN TYPES

  • Multiple lines of text
  • Hyperlink/Picture
  • Custom Field Types
  • Calculated Field
  • Boolean (yes/no)
  • UI version
  • Checked out to
  • Content type ID

How to create an indexed column in the SharePoint list step by step (Index columns in SharePoint Online)?

Go to the list settings page in which list you want to create an index and click on the “Indexed Columns” link as below:

How to create index column in SharePoint Online list

Then, we will land on the below page – here click on the “Create a new index” link like below:

Indexed columns - create index column in SharePoint

Then, select the column (referring to the supported columns section) which you want to index from the “Primary column for this index:” drop-down list. As an example I have selected the “Item Name” column and clicked on the “Create” button as below:

Create index column in SharePoint - Indexed columns

Then, come to the “Indexed Columns” page, we can see the “Item Name” indexed column is displayed here – this section was empty just before.

Create index column in SharePoint online list step by step

How to create the indexed column automatically thru the list view filter (Index columns in SharePoint)?

If we add any indexed allowed columns(mentioned in the above section) in the SharePoint list view filter that particular column is indexed automatically. Let’s see how this can be done.

Go to the edit mode of the “All Items” view.

Create index column in SharePoint Online list - Edit view

Then, from the “Filter” section – apply the filter like below. As an example I have selected the “Quantity” column and applied a filter on it, then click on the “OK” button.

Now, the “Quantity” column will be displayed on the “Indexed Column” page because it is automatically indexed when we have applied a filter to it.

Create index column in SharePoint - filter view

 

Notes:

Indexes are created automatically in the following two situations:

  • When saved views have columns used for sorting or filtering
  • When sorting in the modern experience

Here are notes to remember:

Automatic index creation when sorting in the modern experience is limited to lists and libraries with less than 20,000 items.

Keynotes to remember

  • In a list maximum, we can create 20 indexed columns.
  • In a list maximum, we can create an 8 Lookup type indexed column.

Summary: Index columns in SharePoint Online (Create indexed column in SharePoint)

Hence, in this article, we have learned how to create an indexed column in the SharePoint list.

References: Index columns in SharePoint Online

https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59

See Also: SharePoint Online tutorial

You may also like the below SharePoint Online tutorials:

Download SharePoint Online PDF Book

Download SharePoint Online & Office 365 Administration eBook

Buy the premium version of SharePoint Online & Office 365 administration eBook from here:



Buy SharePoint Online & Office 365 Administration eBook


 

Get the free demo PDF eBook from here:

FREE DOWNLOAD

Send download link to:

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

About Post Author

1 comments on “The Power of Index Columns in SharePoint Online: Simplify Your Data Management – create step by step”

Do you have a better solution or question on this topic? Please leave a comment