cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Get user email from only his name

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

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.
Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

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.

Highlighted
Frequent Visitor

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,

Highlighted
Super User
Super User

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.
Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

View solution in original post

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (5,778)