View cannot be displayed because the number of lookup columns exceeds the threshold

If you work with large lists there is a good chance you might have run into this threshold error message in Office 365.

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold

A Lookup column in a list view will cause a join with another table in the back-end. More lookup columns implies more joins in the back-end resulting in performance hit. That is the reason why Microsoft set a limit of number of lookup columns you can display in a view. In SharePoint online Office 365, at the time of this writing it is set to 12 by default.

In some cases like mine – you may see this error even without having a single traditional lookup column in your list or view. Reason being, SharePoint considers some other column types as lookup columns.

Column data types which are counted against SharePoint’s list view lookup and workflow column threshold:

  • Traditional lookup column
  • Single-value managed metadata column
  • Multi-value managed metadata column
  • People & group column
  • Multi-value people & group column

If you get this error try to reduce the number of lookup columns which are displayed in the view.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Navigation switcher

SharePoint Navigation has received lot of attention in the past couple of year when compared to how users had to deal with navigation in SharePoint 2010 & 2013 On-prem days. Here is the latest of the improvements, SharePoint navigation switcher. This feature was made Generally available in Dec 2021. By the time of this writing […]

Read More

Missing a column in SharePoint list/library filter pane

Missing a column in SharePoint list/library filter pane? It is normal. Not all columns are available in the filter pane by default. What is filter pane? Filter pane is available in the top right hand corner in list or library page. It is available by clicking on the funnel icon. Filters available are based on […]

Read More

Missing Office upload center

Couldn’t find annoying Microsoft upload center anymore in your Windows machine? Good news! It is gone forever. Microsoft replaced the upload center with ‘Files Needing Attention’ experience in Office applications. What is Microsoft upload center It is the application that deals with office file uploads to cloud services like SharePoint online, OneDrive for Business and […]

Read More