Permissions for SharePoint 'People or Group' Field Types

By:   |   Comments   |   Related: > SharePoint


Even with complete read and write access to a SharePoint list or library with a 'People or Group' field type, the user gets the message "The control is not available because you do not have the correct permissions". This puzzled me for a few minutes, but soon I had the solution...

time off request

I remembered that the People or Group field was using a SharePoint Group to limit the choices and display a pick list for the user.

hr approvers

When I checked the HR Approvers group setup...

(Click "Settings", then "Group Settings.)

...I noticed that only Group Members "can view the membership of the group".

group members

This is the option chosen by default when creating new groups. In most cases, this is certainly a fine choice. But in this case, when the group is being used as a lookup for a SharePoint field, some thought needs to occur in setting this up correctly.

After changing this to "Everyone"...


...the user was able to use the field normally.

new item

When using a SharePoint group as a source to the People and Groups field type in SharePoint, check to make sure all users that might be using the list or library have access to the specified SharePoint group.

Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms