Unanswered

Send an email to the PERSON column

(0) Share

Report

Posted on by Barking_Mad1

Hi,

So I have a Sharepoint List and it it is a 'PERSON' column that can be used to select the name of someone in our organisation.

I also have a flow which checks the date in the list and sends an email to the person who submitted the form. That part works ok.

However I'd like to also CC in the person named in the 'PERSON' column, but I get an error when just dropping this name into the 'SEND AN EMAIL V2' cc box.

Can anyone advise on thecorrect way to do this?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Barking_Mad1,

If I get your question correctly referencing the Email property of that column will do the trick.

In my setup I have a table with trainings where the column "Trainer" is a "person or group" type. The structure looks like below.

So, to use it in E-mail CC field you can:

1. Scenario - you want only the first user in the Person field - you nest everything in 1 Apply to each and use the first() method

Value in "Apply to each" is:

outputs('Get_items')?['body/value']

Value in "Send e-mail" CC is:

first(item()?['Trainer'])?['Email']

2. Scenario - you want to send e-mail to all the users in the person column, CC-ed in a single e-mail.

Using Select to extract the e-mails as below:

Select From:

items('Apply_to_each')?['Trainer']

Select Map:

item()?['Email']

CC field:

join(body('Select'),';')

Hope this helps!

If I was able to answer your question, please consider marking it with "Accept solution" so other platform users can benefit from it. Thanks!

Was this reply helpful? Yes No
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the reply, appreciated. I should have mentioned the email sits at the end of a single condition, not that it should make much difference. Anyhow...

Im having an issues getting:
outputs('Get_items')?['body/value']

to display properly, see below.

Am I doing something wrong? The Flow Checker returns:

Correct to include a valid reference to 'Get_Items' for the input parameter(s) of action 'Apply_to_each'.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again,

You are on the right track.

In my code I have a "List items" connector named "Get Items" and that's what I'm referencing in outputs(). Try switching the name to the one used in your flow. (it should be the connector where you fetch the rows from the Share Point list.)

The above error - "Correct to include a valid reference to..." is usually when you write a code that references something that doesn't exist in your flow.

P.S. Here is the complete flow setup. Outputs('Get_items') references the list that is returned on the second step.

Was this reply helpful? Yes No
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, so I have:

I didn't type:

outputs('Get_items')?['body/value']

because 'Value' (List of Items) appeared in the dynamic content. And when I do type it, it still appears as an Output...

Thanks for the help....

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Using the dynamic select is fine.

Can you just hover on the "value" icon to confirm that it's indeed from "Get Items" connector?

From what I see we have identical setup, so it's strange that it works only on mine. : /

One trick that I use to get the proper "value" reference is to have a blank "Send e-mail" connector & select in the CC field directly a property from the dynamic selector. This is the way I got the setup I showed.

Was this reply helpful? Yes No