Skip to main content

Notifications

Community site session details
Power Automate - General Discussion
Answered

How to find the email address of user via Power Automate

Like (1) ShareShare
ReportReport
Posted on 23 Jul 2020 19:06:39 by 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!

 

    

  • gerrysr6omfg Profile Picture
    37 on 20 Dec 2022 at 19:14:08
    Re: How to find the email address of user via Power Automate

    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?

  • Joe3 Profile Picture
    44 on 31 Aug 2021 at 18:34:38
    Re: How to find the email address of user via Power Automate

    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.

  • CU09091757-0 Profile Picture
    299 on 23 Jul 2020 at 19:39:58
    Re: How to find the email address of user via Power Automate
    I stand corrected. There are options to "Search for Users" In Power Automate. Many thanks!!!
  • CU09091757-0 Profile Picture
    299 on 23 Jul 2020 at 19:36:59
    Re: How to find the email address of user via Power Automate
    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?
  • Verified answer
    manuelstgomes Profile Picture
    6,625 on 23 Jul 2020 at 19:24:24
    Re: How to find the email address of user via Power Automate

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started
Loading started