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

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,585)