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?
Solved! Go to Solution.
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:
Expression:length(outputs('Get_item')?['body/People'])
This is my List
After flow runs, will get the number.
Hope the content above may help you.
Best regards,
Lily
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:
Expression:length(outputs('Get_item')?['body/People'])
This is my List
After flow runs, will get the number.
Hope the content above may help you.
Best regards,
Lily
Thank you Lily. This is like gold 🙂 for a newbie.
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
12 |
User | Count |
---|---|
128 | |
53 | |
38 | |
26 | |
21 |