Get user email from only his name

(0) Share

Report

Posted on by AntoineT

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!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RobElliott 10,460 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
AntoineT 28 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Verified answer

sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Arunan08 39 on at

Like (0)

Report
Copy link

Link copied!

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! 🙂

Was this reply helpful? Yes No