sending emails to different addresses based on a value

(0) Share

Report

Posted on by gunti

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...

Categories:

Using connectors

I have the same question (0)

All responses (15)

Answers (0)

gunti 28 on at

Like (0)

Report
Copy link

Link copied!

The code is not working.

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Copy link

Link copied!

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:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

yes it is automatically generating the time when filled

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

yes it was automatically get filled when someone fills a form

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @gunti ,

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

Like this:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @gunti ，

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No