Send email to multiple recipients based on multiple choice question in MS forms

Like (0) Share

Report

Posted on 30 May 2022 22:19:02 by crmart1n_mx

Hello!

I'm working on a flow and am trying to wrap my mind around how I would achieve the following. On my MS form, I have a question that asks "Please select the team(s) to notify" with three options. Users can then select one, two or all of these options.

Each team however, has a unique email address.

I'm just wondering how I would build this into my flow where, let's say someone selects two of the teams, it can automatically send an email to the addresses for just those which were selected.

I was about to build it 100% manually using conditions, but there must be a simpler way I'm thinking.

I appreciate any help/advice!

All responses (1)

Answers (1)

Verified answer

v-liwei-msft on 02 Jun 2022 at 08:23:12

Like (0)

Report

Re: Send email to multiple recipients based on multiple choice question in MS forms

Hi @crmart1n_mx ,

Could you please tell me if you use the "Choice" to create the question?

When you use "Get response details", the output of "Please select the team(s) to notify" is like this:
[\"email address1\",\"email address2\"]
You can use the replace function to remove extra symbols other than email addresses and replace commas with semicolons:
replace(replace(replace(replace(replace(outputs('Get_response_details')?['body/r97eaf86ec58645fc90e6f74b29b63e42'],'[',''),'\',''),'"',''),']',''),',',';')
outputs('Get_response_details')?['body/r97eaf86ec58645fc90e6f74b29b63e42'] is the dynamic content: "Please select the team(s) to notify".

I have made a test for your reference:

Best Regards,
Levi