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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,923)