Skip to main content

Notifications

Community site session details

Community site session details

Session Id : q9PlrLooEjUlzrFRYbIvTt
Power Automate - Using Flows
Answered

1. How to read multiple people picker field in power automate?

Like (0) ShareShare
ReportReport
Posted on 6 May 2022 12:24:05 by 8

Creating a automated flow when item in sharepoint list gets changed and then the email will be triggered to respective person mentioned against that particular row. The field/column from where we are picking up the emails are of type ‘Person and Group’ and it is allowing multiple selection . Designed the flow but email field returning a blank value. Looking forward for your help on this.

 

  • Verified answer
    v-jefferni Profile Picture
    on 12 May 2022 at 07:28:43
    Re: 1. How to read multiple people picker field in power automate?

    Hi @ShivaniB ,

     

    It may caused by the internal column name of PP, please check the "real" internal name in the raw outputs of the List items action.

    vjefferni_0-1652339977168.png

     

    It looks as below:

    vjefferni_2-1652340425909.png

     

    You can restrict the number of list items to 2 to shorten the outputs as the test scenario, after getting the internal name remember to remove the top count is fine.

    vjefferni_1-1652340070645.png

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • ShivaniB Profile Picture
    8 on 12 May 2022 at 07:13:09
    Re: 1. How to read multiple people picker field in power automate?

    Hi @v-jefferni 

     

    Thank you for the reply.

    I tried the above solution  but I am still getting error.

    Here is the screenshot of the same:

     

    Failed.JPG

  • v-jefferni Profile Picture
    on 12 May 2022 at 06:49:38
    Re: 1. How to read multiple people picker field in power automate?

    Hi @ShivaniB ,

     

    I created the flow based on your scenario:

    vjefferni_0-1652337872479.png

    vjefferni_1-1652337986913.png

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

     

  • ShivaniB Profile Picture
    8 on 11 May 2022 at 09:57:20
    Re: 1. How to read multiple people picker field in power automate?

     

    Hi @v-jefferni  Please find some screenshots

     

    Get Items:

    Get Items.JPG

     

    Initialize Variable:

     

    initialize.JPG

     

    Compose:

    email.JPG

     

    Append Array Variables:

    array.JPG

     

    Send an email :

     

    outlook.JPG

  • v-jefferni Profile Picture
    on 11 May 2022 at 09:32:31
    Re: 1. How to read multiple people picker field in power automate?

    Hi @ShivaniB ,

     

    You need to post some screenshots of the flow and parameters that used in the flow, so that I can understand all the actions and find out the reason.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • ShivaniB Profile Picture
    8 on 11 May 2022 at 09:14:48
    Re: 1. How to read multiple people picker field in power automate?

    Hi @v-jefferni ,

     

    I have used SP List just with one data entry and GroupEmail column has emails in it .

    I tried the Compose action and tried to print the emails but it is showing blank value.

     

    And 

  • v-jefferni Profile Picture
    on 11 May 2022 at 08:36:08
    Re: 1. How to read multiple people picker field in power automate?

    Hi @ShivaniB ,

     

    You are using the outputs of list items from the SP list. So it seems there are blank fields for some records? If you have selected the correct value from the dynamic contents. You can add condition control and use length expression to check the amount of persons that have been selected in the person column is 0 or not.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • ShivaniB Profile Picture
    8 on 11 May 2022 at 08:21:36
    Re: 1. How to read multiple people picker field in power automate?

    Hi @v-jefferni 

     

    Thank you for the reply.

    I have tried the same solution but I am getting below error. Looking forward to hear from you.

    ShivaniB_0-1652257190011.png

     Error Details :

     

    The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

  • v-jefferni Profile Picture
    on 10 May 2022 at 09:13:36
    Re: 1. How to read multiple people picker field in power automate?

    Hi @ShivaniB ,

     

    Would you like to send an email to multiple recipients based on a multiple selection person column?

     

    If so, please see the flow I created:

    vjefferni_0-1652173816637.png

     

    Details:

    1. Initialize an array variable, append all the person Emails to the variable to create an array of Emails .

    2. Use join function to concatenate emails with the ";" symbol and use the Emails string as the recipients of send an Email action.

    join(variables('emails'),';')

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

     

  • ThamiMtombeni Profile Picture
    71 on 06 May 2022 at 13:14:35
    Re: 1. How to read multiple people picker field in power automate?

    Can you please share a screenshot of the flow .You can hide sensitive info. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 9 Super User 2025 Season 1

#2
rzaneti Profile Picture

rzaneti 7 Super User 2025 Season 1

#3
lbendlin Profile Picture

lbendlin 4 Super User 2025 Season 1

Overall leaderboard

Featured topics

Restore a deleted flow