web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Person field - to only...
Power Automate
Suggested Answer

Person field - to only show name and email

(0) ShareShare
ReportReport
Posted on by 16
hi
 
i have the following flow -
 
 
the flow produces exactly what i want in terms of format and content, but it is displaying the field 'assigned to' as below - 
 
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|joe.bloggs@g.com.co.uk#ext#@????.onmicrosoft.com","DisplayName":"joe.bloggs","Email":"jo.bloggs@g.com","Picture":"https://?????.sharepoint.com/sites/????/_layouts/15/UserPhoto.aspx?Size=L&AccountName=joe.bloggs@g.com","Department":null,"JobTitle":null}]
 
what i want is the above to show is clean text - email and display name, so = Joe Bloggs - joe.bloggs@g.com
 
it is driving me insane, i tried parsing the person object (assigned to) but it introduces a 'for each' and it breaks the flow completely
 
 
Categories:
I have the same question (0)
  • Suggested answer
    rzaneti Profile Picture
    4,491 Super User 2026 Season 1 on at
    Hi,
     
    So far, you are returning the whole Assigned to field, which is an array of objects containing a single item, which is a reference to the user Joe Bloggs. Since we don't have any images from your inputs, I'm assuming that you accessed it by using an expression similar to first(body('Get_items'))?['AssignedTo'].
     
    To access Joe's name and email, you will need two expressions very similar to your existing one, which will simply add the object reference for display name and email. The expressions are the following, where the only difference from your existing one is the content highlighted in red:
    first(body('Get_items'))?['AssignedTo'][0]['DisplayName']
    first(body('Get_items'))?['AssignedTo'][0]['Email']
     
    If the steps above are not clear enough, please share an image of your inputs that are generating the Assigned to field array, so I can make any fixes in the provided expressions.
     
    If you or anyone who finds this thread in the future wants to read further about the topics discussed here, I'm sharing articles that I wrote about Expressions in Power Automate, Objects in Power Automate and How to access array elements in Power Automate.
     
    Let me know if it works for you or if you need any additional help!
    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.
  • DS-17101513-0 Profile Picture
    16 on at
    hi 
     
    i tried the code and got this -
     
  • DS-17101513-0 Profile Picture
    16 on at
    fixed it with this - 
    item()?['AssignedTo']?[0]?['DisplayName']
  • rzaneti Profile Picture
    4,491 Super User 2026 Season 1 on at
    Hi,
     
    Try to use the same expression that you used to return the Assigned to array, but just adding the text in red (from my previous reply) to the end. If you don't know exactly how to do it, please share an image of the inputs that you used to generate the Assigned to array. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 957

#2
Valantis Profile Picture

Valantis 847

#3
Haque Profile Picture

Haque 609

Last 30 days Overall leaderboard