Answered

MS Forms automatic Send an Email with If condition

(0) Share

Report

Posted on by benidoink

Hello Community Experts,

I want to create an automatic reply where, once the MS forms have been submitted, an email address will be sent.
Here's the basic flow I created when the forms submitted there will be a condition if that field is equal to "Camella Butuan" it will automatically send to the "Camella Butuan" Email address. The issue is the email address to which I will be added is 195 Email address and it is therefore a long process if I create another condition per email address. I need your suggestion. Thank you

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @benidoink

I would create a SharePoint list of your 195 users and emails. You can then use get items action where name eq 'users name' and then return the email of the user that should receive the email.

I have an example video here https://www.youtube.com/watch?v=BgUqhbBmlmQ

Please make sure you like and subscribe 🙂

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here
benidoink 73 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @DamoBird365,

Thank you for your suggestion, I already subscribed to your YouTube channel.
I encounter an error which I have already tried to create another list, but the error still prompts it say that the 'Name' column does not exist. Do you experience this kind of error?
DamoBird365 8,942 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @benidoink

Cheers. I would guess your column is not named as you have called it - hence the error. Can you share your filter on get items and/or check the expression yourself.

Damien