Count people and group field values

ameneh maleki 46 Reputation points
2020-11-17T10:28:47.967+00:00

I have a SharePoint list customized with Infopth. This list contains a people and group column that users can set multiple value for it. How can I have the number of values(count) entered by the user in this field?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,341 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Jerry Xu-MSFT 7,956 Reputation points
    2020-11-18T02:30:52.343+00:00

    Hi, @ameneh maleki ,

    Per my test, we can use the count() function in InfoPath to count the entries in the people picker field.

    I created a demo list form below to demonstrate:
    40545-countpeople.gif

    The rule of the button is set like below. Notice, you need to switch to advanced view to find the Display Name field.

    For some reason, I found that before inputting anything , this rule will return 1. However after inputting an entry, it works properly. The function will return 0 when I deleted all entries. You can do some more tests about it.

    40561-image.png


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. ameneh maleki 46 Reputation points
    2020-11-22T08:34:32.73+00:00

    Hi JerryXu

    yes, i try it in another sharepoint list with new people and group field, it shows the same error!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.