Get the Count of People in a People Picker (Person or Group Multiple Entry) SharePoint List Column

[cblackl2000]

I have a SharePoint list with a multiple entry people picker (person or group) list column where I need to get the count of people entered and then update that number in another column for easy viewing.  I have a reference in this blog (3) I want to get the number of multi user in a Person... - Power Platform Community (microsoft.com) but it did not work for me.

The example is, you have a list of classes for which users will enroll in the Enrollee column.  This number will change over time and the flow will trigger upon new and modified items.  I would like get this count of Enrollee and then place it into EnrolleeCount column (integer) that I have.  Any help would be appreciated as I have searched for this and cannot find a solution that works.

[fchopo · Accepted solution]

Hi @cblackl2000 

You could do something like this:

 In this sample I have a list called "Tasks" with a multi people picker column called "Assigned To". For each row I get the number of people stored in the column:

length(items('apply_to_each')['AssignedTo'])

Then you would only need to call the SharePoint Update action.

Hope it helps!

Ferran

[cblackl2000]

@fchopo I cannot thank you enough!  This was, for some reason, such a struggle and your screen shots made all the difference.  I will say I had to take several times through the expression setup to get it right as I had a little trouble selecting the correct parts - but once I did, voila!  😀

[Try_P0W3r]

How did you do it? please share full powerautomation as I can't seem to replicate.

[agiunta]

edited, useless comment

[Ceesch]

Thanks for your solution. One question, could you please elaborate on: Then you would only need to call the SharePoint Update action.