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!
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! 🙂
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,
@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.