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 ...
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)