Skip to main content

Notifications

Power Automate - General Discussion
Answered

Get user email from only his name

(0) ShareShare
ReportReport
Posted on by 28

Hello!

 

I'm trying to get the mail of a user and I only got his name ("Thierry Anderson" for example).

 

I can't seem to be able to do it with either Azure AD or Office, as they require mail to get a user?

 

The name of the user come from a PowerApps.

 

Does someone have a solution?

 

Have a good day!

  • Arunan08 Profile Picture
    Arunan08 39 on at
    Re: Get user email from only his name

    Hello! Thanks for sharing your solution. My scenario is slightly different where I have created a SharePoint list with all employee names as a column. My second column is a person field titled e-mail. I hope to automate a flow to extract the e-mail addresses of the respective names added to the list and update it under the e-mail column. How would I go about that? Thank you in advance for your help! 🙂

  • Verified answer
    sudharsan1985 Profile Picture
    sudharsan1985 1,325 on at
    Re: Get user email from only his name
    Hi, if you are using the SharePoint Person field, there are few properties like 'Email', 'Claims' that are unique to the user. You can use any of these values. Actually, you can get the email directly from the Person field.
  • AntoineT Profile Picture
    AntoineT 28 on at
    Re: Get user email from only his name

    Thanks for the answer!

    Indeed I didn't thought of that, probably because we have 40 customer in that database! 😄 but that's a good point.

     

    In the PowerApps, the name come from a person column in a Sharepoint list, I have access to that list, would that be a way to do it? because the person is picked in that list, it's not just the name?

     

    Best regards,

  • RobElliott Profile Picture
    RobElliott 10,012 on at
    Re: Get user email from only his name

    @AntoineT I don't think there can be a solution for this as you can't guarantee the name is unique: what happens if there are 2 Thierry Anderson's in your company? In mine (OK there are 65,000 of us so there's more chance of it happening) there are 2 Rob Elliott's so my email address is rob.elliott2@.... But if a flow was just looking at the name in that case then it would fail. As well as email addresses we also use company IDs quite frequently which are always unique and you can get the email from that.

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard