Forum Discussion
Solved
Group By People/Group of SharePoint List
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
- 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-a869-4fcf-89b1-ba3d04784df7#:~:text=Quick%20grouping%20in%20your%20SharePoint,differences%20in%20that%20column%27s%20data.
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 Reply
- 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-a869-4fcf-89b1-ba3d04784df7#:~:text=Quick%20grouping%20in%20your%20SharePoint,differences%20in%20that%20column%27s%20data.
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