Copying multiple email addresses (person field) to text field within the same sharepoint list

[iKettle]

Hi Guys, I am trying to copy a multiple person field to a text field in the same sharepoint list. I have put in the trigger as when an item is created or modified and then variable array using 

When I test this, I only get the one email address in the AssignedTo field in Sharepoint

How can I copy all the email addresses that are in the person field into a text field

[MarconettiMarco]

Hello @iKettle ,

please outside the Apply to each loop, add a "Compose" action putting the "varAssignedTo" variable like below:

You'll see al the added emails.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[Shujaath_Khan · Accepted solution]

Hi @iKettle 

you're looking at only the first iteration of it from Apply_to_each.

Below Appluy_to_each use compose action and set the variable VarAssignedTo as input.

Now, once the flow run completes you can see the output in compose action where there should be two email id's in array as per the format defined.

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[iKettle]

Hi Shujaath, thanks for the help, yes I added the compose and it does collect multiple emails - The only thing I have an issue with now, is how to I remove the [] and "" from the output? All I want as the output is the email address without the "" and a comma as a separator, which is there already

[MarconettiMarco]

Hello @iKettle ,

please refer to this post in order to replace unwanted characters:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-concatenate-particular-column-value-from-m...

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[Shujaath_Khan]

Hi @iKettle 

below existing compose, add another compose and pass out of first compose output to below

and write this in expression tab.

join(outputs_of_compose,",")

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.