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 ...
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
CuriousProjectUser I don't think there is any hard coded limit for number of lookup / people columns in a SharePoint list.
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.