Unanswered

need help extracting email from Sharepoint PERSON field

(0) Share

Report

Posted on by StephenM

Ive got a sharepoint list that uses a Person field. I use GET ITEMS to grab all the data, and a Create a HTML table with some of the fields, and i use the output of that in an email so i'm getting a table in the email with the fields.

HOWEVER the Person field is giving me lots of bits, and i just want the DisplayName and Email bits from it.

any ideas how i can grab just those two pieces for each row in the table for my email ?

the end result is to have the table in the email AND send the email to all the names in the Person Field in any of the rows.

your guidance would be appreciated.

Many thanks

Stephen

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yuazh-msft on at

Like (0)

Report
Hi @StephenM,

I have made a test on my side to create a sharepoint list as below:

You could refer to screenshot below to create the flow:

The expression of ActionOnDisplayName in Create html table as below:

item()?['ActionOn']?['DisplayName']

The expression of ActionOnEmail in Create html table as below:

item()?['ActionOn']?['Email']

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

Hello, @StephenM!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No