SOLVED

Group By People/Group of SharePoint List

Copper Contributor

Hello,

 

I have a SharePoint List that has the People and/Group Column but its not giving me the option to Group By that column I'm assuming its because we have it set to enter multiple people/groups in that column.

 

Does anyone have a suggestion on how I can group the SharePoint list

1 Reply
best response confirmed by Shelley_B (Copper Contributor)
Solution
That is correct, a column that allows multiple choices is not supported to be Grouped By.

https://support.microsoft.com/en-us/office/use-grouping-to-modify-a-list-or-library-view-18548b63-a8....

An option would be a flow that updates a single line of text column with the People details every time its edited. This would allow you to group by it if it's a critical requirement
1 best response

Accepted Solutions
best response confirmed by Shelley_B (Copper Contributor)
Solution
That is correct, a column that allows multiple choices is not supported to be Grouped By.

https://support.microsoft.com/en-us/office/use-grouping-to-modify-a-list-or-library-view-18548b63-a8....

An option would be a flow that updates a single line of text column with the People details every time its edited. This would allow you to group by it if it's a critical requirement

View solution in original post