Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

sending emails to different addresses based on a value

(0) ShareShare
ReportReport
Posted on by 28

There is a list of drop-down buttons in my MS Form:

 

Drilling

Module

Tracking

....

 

There are about 6 departments. 

 

If a user chooses Drilling, an e-mail is sent to the e-mail address of that person email who does drilling (so no multiple addresses)

If a user chooses Module, an e-mail is sent to the e-mail address of that person email who does module task.

 

Etc...

  • gunti Profile Picture
    gunti 28 on at
    Re: sending emails to different addresses based on a value

    The code is not working. 

  • gunti Profile Picture
    gunti 28 on at
    Re: sending emails to different addresses based on a value

    I was not sure where to enter email id's. can you guide me where to enter and send me the screen shots

  • Re: sending emails to different addresses based on a value

    Hi @gunti ï¼Œ

    If that's the case, where is the email address of your drilling department?

    If you have manually entered the e-mail address of the drilling department, please refer to @v-bofeng-msft  reply.

     

    Best Regards,

    Sunshine Gu

  • gunti Profile Picture
    gunti 28 on at
    Re: sending emails to different addresses based on a value

    what if I am submitting the form. If I choose drilling in MS Form. then the email should be sent to that particular drilling department.

  • gunti Profile Picture
    gunti 28 on at
    Re: sending emails to different addresses based on a value

    The email address is automatically getting updated in excel sheet to whoever I am sending the link to submit the MS form response

  • Re: sending emails to different addresses based on a value

    Hi @gunti ,

    If your email column is auto-populated, you can simply use Responders' Email to send emails to specific submitters

    Please check this test:

    vyetonggumsft_0-1715142466293.png

    Best Regards,

    Sunshine Gu

  • gunti Profile Picture
    gunti 28 on at
    Re: sending emails to different addresses based on a value

    yes it is automatically generating the time when filled

     

  • gunti Profile Picture
    gunti 28 on at
    Re: sending emails to different addresses based on a value

    yes it was automatically get filled when someone fills a form

  • Re: sending emails to different addresses based on a value

    Hi @gunti ,

    Is your Email column in excel table filled in by Responders' Email?

    Like this:

    vyetonggumsft_0-1715139701589.png

    Best Regards,

    Sunshine Gu

  • Re: sending emails to different addresses based on a value

    Hi @gunti ï¼Œ

    Is your Completion time column in excel table filled in as MS Form Submission time?

     

    Best Regards,

    Sunshine Gu

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics