Answered

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

(0) Share

Report

Posted on by ShivaniB

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.

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

ThamiMtombeni 71 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
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:

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.

Was this reply helpful? Yes No
ShivaniB 8 on at

Like (0)

Report

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.
Error Details :

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

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ShivaniB 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ShivaniB 8 on at

Like (0)

Report

Hi @v-jefferni Please find some screenshots

Get Items:

Initialize Variable:

Compose:

Append Array Variables:

Send an email :

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @ShivaniB ,

I created the flow based on your scenario:

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.

Was this reply helpful? Yes No
ShivaniB 8 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

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.

It looks as below:

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.

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.

Was this reply helpful? Yes No