In sharepoint list, I have two separate person columns. I want to send email (v2) to the person(s) in only one of the columns. Power Aut is not able to separate the two.

[okknudse]

The solution i am creating is the following: When the status of an item (task) in a sharepoint list changes to "done" I want to send an email for the responsible person(s) for that task. I have a person-column in the SP list for the responsible, called "tilordnet". I also have a separate person-column with the person that has given the task, called "oppdragsgiver" I don't want them to receive the same email. The problem is that power automate does not seem to be able to separate the email from the person in the two different columns. In the code they are both called: @item()?['Email']". Is it a way to point to the email of the person(s) in the specific column?

My flow is setup like this:

In the To-field i have called the dynamic content "tilordnet Email" and in the body of the email i have called the "oppdragsgiver Email". But in the code they are both called 

@item()?['Email']".

 

 

 

[hantsjoel · Accepted solution]

Hi @okknudse,

I suspect from the way that your flow is set up that your your person columns are configured to allow multiple selection? If this is the case, the column returns an array of people and this is why you are seeing your email action get placed inside the For Each actions. The For Each cycle through the array of people (even though there may only be one person in the array) and you are using the Email value. This is why you are seeing item()?['Email']...it's the Email value of the current item in the For Each.

A good way to resolve this is to use the Select action to extract just the email addresses into an array. Then we can join those email addresses back into a string. Here is an example:

First create two Select actions.

Pass in the array of People into the From parameter. In my example it is triggerOutputs()?['body/Person1']. 

Next you want to map just the email value. Switch Map to text mode and specify just the email values using 

item()['Email']. Do the same in the second Select, using the other person column.

Now you can use the outputs of the actions to string together the email addresses

The expression you need is join(body('Select_Person_1_Emails'), ';'). This will join the emails in a string with a semicolon separator (you can specify whichever separator you like, and if you only have one email address in the array the separator won't appear at all). Do the same for the Person 2 Select action.

Obviously you need to substitute in your specific person column names into the formulas above.

Hope that helps, let me know if you have any further questions.

Joel

[okknudse]

Hello Joel! This worked flawlessly, thank you so much. I am sure the Select action will come in handy on several occasions. 

[hantsjoel]

Glad to hear it, @okknudse! The Select action is brilliant, there is so much cool stuff you can do with it to streamline flows.

Happy building!