cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kensley
Resolver I
Resolver I

How to find the email address of user via Power Automate

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!

 

    

1 ACCEPTED SOLUTION

Accepted Solutions
manuelstgomes
Super User
Super User

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

View solution in original post

4 REPLIES 4
manuelstgomes
Super User
Super User

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

View solution in original post

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?

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

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.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,681)