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.
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.
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:
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.
Hi @v-jefferni Please find some screenshots
Get Items:
Initialize Variable:
Compose:
Append Array Variables:
Send an email :
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.
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
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.
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'.
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.
Can you please share a screenshot of the flow .You can hide sensitive info.
Michael E. Gernaey
9
Super User 2025 Season 1
rzaneti
7
Super User 2025 Season 1
lbendlin
4
Super User 2025 Season 1