Answered

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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
iKettle 91 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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-multiple-rows-if/m-p/1702641#M188787

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

Was this reply helpful? Yes No
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (1)

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

Was this reply helpful? Yes No