cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KTNN0
Frequent Visitor

Length of People column in SharePoint

I have a SharePoint People column with multiple choices. Do you know if it's possible to use the Length function to get the number of people in the field?

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @KTNN0 

Thank you for your posting.

According to your description, you want to get the number of column with multiple choices.

I have set up a Flow When an item is created will get the number of  People.

You can refer to as below:

v-LilyW-msft_0-1623203317378.png

Expression:length(outputs('Get_item')?['body/People'])

v-LilyW-msft_1-1623203317381.png

This is my List

v-LilyW-msft_2-1623203317383.png

After flow runs, will get the number.

v-LilyW-msft_3-1623203317385.png

Hope the content above may help you.
Best regards,

Lily

View solution in original post

2 REPLIES 2
v-LilyW-msft
Community Support
Community Support

Hi @KTNN0 

Thank you for your posting.

According to your description, you want to get the number of column with multiple choices.

I have set up a Flow When an item is created will get the number of  People.

You can refer to as below:

v-LilyW-msft_0-1623203317378.png

Expression:length(outputs('Get_item')?['body/People'])

v-LilyW-msft_1-1623203317381.png

This is my List

v-LilyW-msft_2-1623203317383.png

After flow runs, will get the number.

v-LilyW-msft_3-1623203317385.png

Hope the content above may help you.
Best regards,

Lily

KTNN0
Frequent Visitor

Thank you Lily. This is like gold 🙂 for a newbie.

Helpful resources

Top Solution Authors
Users online (4,194)