Skip to main content
Community site session details

Community site session details

Session Id : ppSrbauine2cgQeNYnOpEO
Power Automate - Using Connectors
Answered

Finding an e-mail adresse based on the name

Like (0) ShareShare
ReportReport
Posted on 16 May 2022 10:35:39 by 131

Hello,

I'm working on a flow in order to send an e-mail notification to contacts if their name is selected in a Form (Choice options question)

No problem with the Forms connectors and triggers.

 

For the moment, the process I'm using is :

 

1st Condition : the specified field in the Form contains the name "A"

       Yes => send an e-mail to "A's e-mail address"

       No =>go to 2nd Condition : the specified field in the Form contains the name "B"

                               Yes => send an e-mail to "B's e-mail address"

                               No => 3rd Condition ... 

And so on.

It works fine, but the problem is that I have more than a dozen Names / E-mails to program, it's going to take a while...

 

Is there an easier way to proceed ?

 

Thanks

R Sygroves

(please forgive my english, I'm French)

                                     

                                      

 

  • v-jefferni Profile Picture
    on 23 May 2022 at 07:16:46
    Re: Finding an e-mail adresse based on the name

    Hi @RSygroves ,

     

    I'm not an expert of Outlook, but as I know, there could be some settings make the URL be plain text:

    vjefferni_0-1653290104325.png

     

    You may try and send the Email to a test account and check the result.

     

    Hope this helps.

     

  • RSygroves Profile Picture
    131 on 23 May 2022 at 06:59:32
    Re: Finding an e-mail adresse based on the name

    hi @v-jefferni 

    thank you for this new answer.

     

    Not sure to understand correctly, is it a seeting I can correct or does it depend on the recipient mailbox settings ?

     

    Best,

  • v-jefferni Profile Picture
    on 23 May 2022 at 01:31:58
    Re: Finding an e-mail adresse based on the name

    Hi @RSygroves ,

     

    The problem seems to be caused by Outlook settings on the receiving end.

     

  • RSygroves Profile Picture
    131 on 20 May 2022 at 14:53:03
    Re: Finding an e-mail adresse based on the name

    @v-jefferni Problem apparently resolved.

    I made some new tests, it seems now the process properly leads to the targetted recipient. Thanks a lot for your advice.

     

    I noticed another issue : my e-mail contains an html link to a file on a sharepoint shared library.

    When saving my flow, the link is OK, but when the message arrives only display texts remains (no more link)...

    Any suggestion about that ?

     

     

     

  • RSygroves Profile Picture
    131 on 20 May 2022 at 12:44:55
    Re: Finding an e-mail adresse based on the name

    Hi Jeffer,

    I changed my flow's configuration using this "search for users".

    It works fine, but strangely it  sent e-mails to users whose name doesn't appear in the MS Form answer !

    I missed the "Top : 1" setting, maybe it will help.

     

    But I also wonder :  after the "search users" connector, I use "send e-mail from a shared mailbox" (see below). Is it normal to have the Apply to each option activated ?

     

      

    RSygroves_0-1653050671344.png

     

  • RSygroves Profile Picture
    131 on 20 May 2022 at 07:01:30
    Re: Finding an e-mail adresse based on the name

    Hello Jeffer.

    I'm going to try this connector.

    Thanks for your help.

    Best regards

  • v-jefferni Profile Picture
    on 20 May 2022 at 06:57:14
    Re: Finding an e-mail adresse based on the name

    Hi @RSygroves ,

     

    As I mentioned above, the Office 365 User connector will be helpful to get the email address based on user name. No need to use Conditions. You can set the search term with the name coming from form response, and use the output from this action.

     

    Hope this helps.

     

  • RSygroves Profile Picture
    131 on 20 May 2022 at 06:41:23
    Re: Finding an e-mail adresse based on the name

    Hi thank you for your answer.

     

    Actually I work with MS Forms, not an SP list.

     

    I managed to find a solution, using conditions :

    e.g. If the answer to one of the questions in the form contains person's 1 name, then an e-mail is sent to them.

    If not, a new condition for person 2 and so on....

     

    The problem is that it seems a muche more complicated process even if it actually works.

     

     

      

     

     

     

     

  • Verified answer
    v-jefferni Profile Picture
    on 20 May 2022 at 02:51:01
    Re: Finding an e-mail adresse based on the name

    Hi @RSygroves ,

     

    Could you please share more details about your scenario? What kind of Form are you using, the MS Forms or SharePoint list customize form? If it is the SP customize form, I think the persons are in a People type column? If so, you can easily get the respective email address to the selected user in the column, no matter in PowerApps or Flow.

     

    So, for a people column, you can find the email address in dynamic contents:

    vjefferni_0-1653014803745.png

    If it is a Choice column (strongly doubt about that though), you can use Office 365 User connector and utilize the below action and get the users as well as their emails:

    vjefferni_1-1653014809802.png

     

    Hope this helps.

     

  • RSygroves Profile Picture
    131 on 17 May 2022 at 12:18:49
    Re: Finding an e-mail adresse based on the name

    Hi @vivekpande18 

    thank you for your answer.

     

    Maybe my explainations aren't clear enough.

    I tried to make a visual description of my desired process :

    Capture d’écran 2022-05-17 141654.png

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics

Loading complete