Forum Discussion
SharePoint List - Count People Column
I'm wondering if it's possible to have one column display a running count of the number of people in a people column?
Use-case: I'm creating a Professional Development SharePoint site and a List to track what trainings are available. I have a column called Maximum Attendees, and I need a column to count from the Registered Attendees so I can make another column to count how many seats are left. I've tried a Calculated Value, but People columns aren't available to use.
1 Reply
You can do this with a flow in Power Automate to get the number of items in the people picker column and then update another column. In my example it's called Count and is a number column. I've used a manual trigger but you might want to change that to only run when the people picker column is changed.
The Compose action has the expression length(items('apply_to_each')['MemberofStaff']
This sis the result, you can then use this with a calculated column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform and SharePoint, WSP Global (and classic 1967 Morris Traveller driver)
