1.

What is the default lookup column limit in Microsoft SharePoint lists? How can you increase the lookup column limit in Microsoft SharePoint?

Answer»

The default lookup column limit in Microsoft SHAREPOINT is 12.

Workflow status columns, classic lookup columns to other lists, and person/group columns are all examples of lookup columns. The two default people FIELDS "Created by" and "Modified by" are included in this. If you have more than 12 of them in your list, you may get the following ERROR:

"The number of search and workflow status columns in this view exceeds the administrator-imposed threshold (12) and cannot be displayed."

Following steps should be FOLLOWED to increase the threshold limit of the lookup column in SharePoint lists :

  • Navigate to Central Admin.
  • Select Manage Web Apps from the drop-down menu.
  • Select the web app for which the lookup limit is being increased.
  • Under "General Settings," select "Resource Throttling" from the drop-down arrow.
  • Change the lookup limit in the list view and SAVE the changes.


Discussion

No Comment Found

Related InterviewSolutions