Sent email base on multiple selected in Microsoft form

[Anonymous]

HI,

I'm try to create flow that sent calendar file via email base on selected multiple choice.

in form user can select multiple training date and I want to sent .ics file  to them (or have way to automatically add calendar for them would be great)

for example if their choose

A. 16 Friday 10 PM and B. 20 Monday 9 PM and we can sent 2 .ics files to them in 1 email.  

I have try condition by it's not work, it's keep sent only 1 .ics file.

Thank you

[v-LilyW-msft · Accepted solution]

Hi @Anonymous 

Do you want to filter files based on multiple-choice answers in the Form, and then send emails with multiple attachments?

I set up a flow, you can refer to below screenshots to see if it helps.

This is my test Form:

This is my Folder for storing ics files.

Flow in details:

Complete flow:

When a new response is submitted like below:

The recipient will receive the following email:

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

HI @v-LilyW-msft 

Thank you for your solution! I'll try today.

may I ask more question? this flow including case when user select only 1 date training? 

I have try by extract choice by compose but it fail when user choose only 1 date training.

Thank you!

[v-LilyW-msft]

Hi @Anonymous 

I have made a test on my side, when an option is selected, an email with an attachment will be sent.

Best Regards,

[Anonymous]

Hi @v-LilyW-msft 

Thanks a lot again you're amazing! 

I will try tonight 😍

Regards.

[Anonymous]

Hi @v-LilyW-msft 

sorry me again. may I ask about power automate is support get data from attendance report?

Regards.

[Anonymous]

Hi @v-LilyW-msft 

In sending email, it's not show Attachments Variable.

and in Initialize variable step, what shout be an value?

Regards,

[v-LilyW-msft]

Hi @Anonymous 

Please switch to input entire array, then input the variable in Attachments field.

Best Regards.

[Anonymous]

Hi @v-LilyW-msft 

not sure what wrong with my flow I selected 2 choices but got only 1 .ics file.

this is my flow.

 

Regards,

[Anonymous]

@v-LilyW-msft  I test again it's not sent any attach .ics file. 

[v-LilyW-msft]

Hi @Anonymous 

Flow looks fine, please check that each of your options and the filename without extension match exactly.

Best Regards.

[Anonymous]

HI @v-LilyW-msft ,

I've edited .ics file in the same name as choice in form, but not sure why Attachments still empty.

[v-LilyW-msft]

Hi @Anonymous 

You can add another Compose and put the filename in it. After the Flow runs, check the running results to see if the results in Compose3 are the same as those in Compose2.

If the first one doesn't match, click Next to see the next result.

Best Regards.

[Anonymous]

Hi @v-LilyW-msft 

not sure it's about path of sharepoint to location I stored .ics files or not.

but when I select path from drop down it's doesn't show full path to my real location that stored .ics file

like it's end in BI-Data support but my real location is in Document --> Test_send_email

Regard,

[Anonymous]

Hi @v-LilyW-msft 

the 1st one doesn't math.

[v-LilyW-msft]

Hi @Anonymous 

Is the second result of the condition in Apply to each 2 true?

If it is true, please check if the Get file content action runs successfully and if there is a value in the Append to array variable.

Best Regards

[Anonymous]

Hi @v-LilyW-msft 

it's False

but Get file content action got an error 

not sure it's about path of sharepoint to location I stored .ics files or not.

but when I select path from drop down it's doesn't show full path to my real location that stored .ics file

[Anonymous]

More information

[Anonymous]

sorry, wrong file

 

[Anonymous]

HI @v-LilyW-msft 

it's has been solved! 

my fault, I edited but forgot to use new form 😂 
sorry for bothers you. 

BTW you're awesome!!!