Solved: Extract email several people in a person type column sharepoint

Extract email several people in a person type column sharepoint

Hello guys!

I need to build an approval process flow from a sharepoint list that contains a "person" type column that allows multiple selection, this means, several people needs to approve the respective request. The flow needs to work like this: When a certain column is modified it needs to trigger the approval process and send the approval to the people that are in the Approvers column which is the type person column that I mentioned before. I have tried to extract the emails using Select and Join actions but the results are not de desired ones. This is what I have at the moment (Person is the Approvers column):

the outputs for each step are these:

Select:

[

{

"person1@email.com": "email"

{

"person1@email.com": "email"

}

]

Join:

{"person1@email.com":"email"},{"person1@email.com":"email"}

Append to string variable:
{"person1@email.com":"email"},{"person1@email.com":"email"}{"person2@email.com":"email"},{"person2@email.com":"email"}

As you can see, it duplicates the values and in the end the variable values are also duplicated by each person that it finds in the column, in my case there are 2 people in there so the variable in the end have 4 values. Also it is including the column name of the select action. I really don't know how to fix this and I appreciate any help with this issue.

Quick Links

Leaderboard > Power Automate - Building Flows