Unanswered

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

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report
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

Was this reply helpful? Yes No
cblackl2000 57 on at

Like (0)

Report

@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! 😀

Was this reply helpful? Yes No
Try_P0W3r 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
agiunta 3 on at

Like (0)

Report

edited, useless comment

Was this reply helpful? Yes No
Ceesch on at

Like (0)

Report

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

Was this reply helpful? Yes No