Answered

How to find the email address of user via Power Automate

(1) Share

Report

Posted on by CU09091757-0

299

If I only know the first and last name of a user in my organization, is it possible to use that information in Power Automate today, to then find their email address?

Here's an scenario - A project manager uses Microsoft Form that is available for the whole organization to fill out. On that form, is a dropdown list of people that play key roles (listing their names). Once a selection is made from this choice list, the user will submit the form, and Power Automate will pick it up through a trigger.

It's at this point that I am curious how Power Automate can find the user that was selected on the MS Form, so that I can add a connector to email this selected individual in the flow process.

I'm new to this. How would you solve this scenario?

Many thanks!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

manuelstgomes 6,625 on at

Like (2)

Report

HI @kensley

Yes, it's possible by using "Get user profile (V2)" and then searching by the person's characteristics (surname, given name, etc).

Here's the doc to guide you:

https://docs.microsoft.com/en-us/connectors/office365users/#get-user-profile-(v2)

Hope this helps you.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
CU09091757-0 299 on at

Like (1)

Report

Thank you so much for the quick feedback. As I mentioned earlier, all I have is the first name and last name of the staff member who was selected from the Microsoft Form process. Once inside my Power Automate flow, how can I find "that persons" email address?

Was this reply helpful? Yes No
CU09091757-0 299 on at

Like (1)

Report

I stand corrected. There are options to "Search for Users" In Power Automate. Many thanks!!!

Was this reply helpful? Yes No
Joe3 44 on at

Like (1)

Report

If "Search for Users" is used, the results come back in multiple and every time you use the values from that connector, an "Apply to each" is tacked onto the connector. For example, you only have the first and last name of an employee. You use the create a variable and set it to concatenate the "first" and "last" name followed by @And then your company domain. You use "search for users" based on the set variable email created. Every time you bring up the user id from the "search for users" connector, it will automatically apply a "for each" because it thinks there are multiple values and it needs to cycle through each. Bottom line: can't get and use profile info when you only start with a first and last name.

Was this reply helpful? Yes No
gerrysr6omfg 37 on at

Like (1)

Report

Can you be more specific than a documentation link to a huge page that possibly somewhere shows how to get the email? How do I get the email?

1 people found this reply helpful.

Was this reply helpful? Yes No