Answered

Extracting email address field from Person object

(1) Share

Report

Posted on by Kjell

I'm working on a flow that sends emails to multiple people. I'm extracting Person fields from a SharePoint list field that can contain a number of Persons using the Apply to each function. I then send the data to the Send an email function.

The problem that I'm having is that CurrentItem contains the comple Person struct and I need to extract just the Email field from this struct in order for the Send an email function to accept the parameter in the To field.

How can I extract this field?

Screen Shot.jpg

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Kjell

I may not be understanding your goal totally, but I believe that you are storing the email addresses in the array. If that is the case, you may want to remove the array. You can simply loop through each person or group entry - you'll be able to select the email address. If I am off base, please let me know.

In my example, PG is a person or group column that allows mutliple entries.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
if you hover over the current item you will see the JSON representation of the object. YOu can take that string, enter it in the formula bar in dynamic content and then add ?['email'] to the end of it. Insert that into the To blank and you'll have the email. It will look something like this

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

Was this reply helpful? Yes No
Linda777 178 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Pstork1,
I have the same issue. can I ask how to "hover over the current item you will see the JSON representation of the object"? I tried this below:
got:
items(('Apply_to_each')?['Requestor']?['Email'])
Put on it on "Required attendees" field:

got error message:
Please advice.
Thank you very much.
Linda

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

You can't use a value from inside the Loop after the Loop has closed. That's why I suggested appending the Email to a string variable. The values in the variable will remain after the loop completes.

If you hover over an item in the flow a tooltip will appear that shows the JSON for that item. see screenshot. This is the loop structure I am suggesting. When you are done the variable will have a list of emails from the people column. NOTE: its not in the screenshot but you need to add a semicolon after the email when appending to the string to use it as an address.

Was this reply helpful? Yes No
Linda777 178 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Pstork1,

It works very well. Thank you very much!!!🙂

Was this reply helpful? Yes No