Forum Discussion
Limit of people picker columns in SharePoint Online list
Dear all, we're planning to create a list in SharePoint Online with around 40 columns of type "Person or Group" and some of type "Choice" and "Managed Metadata". On the web I found contradicting ...
CuriousProjectUser I think there is limit of 12 columns per list view (person or group, lookup columns, etc.)
Displaying 12 or more columns of the following types can cause a list view threshold error: people, lookup, and managed metadata. Displaying columns of other types will not.
Documentation: Manage large lists and libraries
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Dear Ganesh,
i can confirm the view limit by observation within a test scenario: created a list with 20 people picker columns. Only 12 of those can be included within one view. However, in another view i can include a different subset of those 20 pp columns without any issues.
We can adapt to the view limit with use case specific views. However, is there some information/documentation on alist limit? (i.e. number of columns within a list)? Or can a view be considered as a database query which is limited for performance reasons, whereas the database itself (here the list) has a much higher threshold?
Kind regards
Philipp
i can confirm the view limit by observation within a test scenario: created a list with 20 people picker columns. Only 12 of those can be included within one view. However, in another view i can include a different subset of those 20 pp columns without any issues.
We can adapt to the view limit with use case specific views. However, is there some information/documentation on alist limit? (i.e. number of columns within a list)? Or can a view be considered as a database query which is limited for performance reasons, whereas the database itself (here the list) has a much higher threshold?
Kind regards
Philipp