Forum Discussion
Sharepoint O365: People or Group Column
I have added a task list app to my site. By default the "Choose from" was set to "All Users", however I only wanted to show people within a specific sharepoint group. I went ahead, updated the Choose from to the sharepoint group, and now it shows NO results are found on the form.
Has anyone had a similar issue and or can give me some insight of what's going on?
- Robin NilssonBronze Contributor
This is what I see on my sites:
On a standard site collection created from Teams, an office group is created with all the members in it.
The standard SharePoint Members group that is also created contains that Office group name, not the individual members.
I think what is happening is if you are using the SharePoint members group, that control can’t dive inside the Office group to pick out the legitimate users.
If I use a SharePoint group that has actual members in it, then it works.
- JdlevCopper Contributor
Robin,
Thanks for the reply, but maybe you can clarify a bit more. I'm confused on the difference between SharePoint members group and Sharepoint Groups. In the choose from, I chose "Sharepoint Group as shown below. Shouldn't this work based on your last statement, "If I use a SharePoint group that has actual members in it, then it works."? You can see that there are 3 members also shown below.
- Robin NilssonBronze Contributor
This is the way I understand it.
What you are seeing with the '3 members' is the actual Office365 group that was created with the site - the site is 'group enabled'. People in there are either owners or members.
Office groups control lots of things - they are the groups you can see in Exchange Online, they're created when you create a new Plan.. they're the underpinning of many Office 365 functions.
For example, I've got a site "Microsoft Agreement" with 18 members
But those are in the Office365 group called "Microsoft Agreement"
If I go to the gear icon and choose 'Site permissions"
I'll see that group referenced under the owners and members - you can tell it's the office group because if you hover over it, you'll see the email address of microsoftagreement@<tenant>.onmicrosoft.com
So we're still looking at the Office group definitions. If you click on the 'Advanced permissions settings' link I have circled (yours might look different - but it should say 'Advanced permissions', you'll finally see the normal 3 SharePoint permission groups - <site> Owners, <site> Members, and <site> Visitors
These are SharePoint Groups
And if you click the <site> Members SharePoint Group to see what's inside, all you will see is the Office Group
And if you look inside that Microsoft Agreement:
I think that's what the people field is seeing. You tell it you want to see the Members group, which is the SharePoint group, but the only thing inside that is an Office group, not actual people.
At least this is my theory. But I tried it on my site and got the same result you did - if I limited my people field to the members group, I couldn't select anyone.
It's confusing because if you look in the owners group and see it empty. And you know your site has owners. It does, but they're 'inside' the Office Group, for want of a better term.
Does that sorta make sense?