cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StephenM
Advocate II
Advocate II

need help extracting email from Sharepoint PERSON field

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.

array.JPG

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

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @StephenM,

 

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

Capture.PNG

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

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:

Capture.PNG

 

Best regards,

Alice

GabrielStJohn
Community Champion
Community Champion

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

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,958)