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)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @gunti ,

Are your email addresses stored in SharePoint lists?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

So whenever a user fill the MS Form, the data will power automate me into an excel sheet

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

Like (0)

Report
Copy link

Link copied!

Hi @gunti ，

Okay, so how do you get this email address?

When you choose different options?

Is there any connection between the questions in your MS Form and the columns in the excel table?

Could you please show screenshots of your MS Form and your excel table? Private information can be coded.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @gunti ,

I've made a test for your reference.

1\My MS form

2\My flow

if( equals(outputs('Compose'),'Drilling'), 'Mail1@xx.com', if( equals(outputs('Compose'),'Module'), 'Mail2@xx.com', if( equals(outputs('Compose'),'Tracking'), 'Mail3@xx.com', ...... ) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
gunti 28 on at

Like (0)

Report
Copy link

Link copied!

Hi,
basically I created an MS form with drop down option for ex
Drilling
Tracking
Module etc

Later I will send the link to the user email id. If the user fill the form using the link then my data which the user filled is directly imported into an excel sheet.

now, if someone fill the select the Drilling option in MS form then the date is imported into excel sheet. NOW Using power automate the particular person should get an email

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee 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
v-yetonggu-msft Microsoft Employee 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
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
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
v-yetonggu-msft Microsoft Employee 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