Flow to email based on multiple selection values powerapp to sharepoint list

[cheezy]

trying to set up a flow based on one or more selections from a powerapp combobox writing back to a sharepoint list.

So the combobox (Animal) contains 10 distinct values a user can multiselect( for example Cat, Dog, Horse etc)

Based on the selection/s email would be sent (each value has a different email)

In the flow i have a condition where if Animal contains Cat then email person1

This works fine if only Cat selected.

If multiple selections ie Cat, Dog and Horse, This is where i get a bit stuck.

How can i continue the logic to process other selections to relevant email?

[Ramole]

Hi @cheezy 

This is exactly what you need please check this video will help step by step step by step tutorial of how to create HTML table send emails with dynamic content in Microsoft Powe... 

[cheezy]

I am not so much interested in HTML table content - just want to work out how to send an email to certain individuals based on the values of a multi select combo box.

if Animal contains Cat then email person1

If Animal contains Dog then email person 2

If Animal contains Horse then email person3  etc

[Krishna_R · Accepted solution]

Hi @cheezy 

I believe u can achieve this by using switch 

[StalinPonnusamy]

Hi @cheezy 

As @Krishna_R mentioned, we can use "Apply to each" and Switch" controls in the flow to loop through all items and send emails.

If the only email address is varied then set the email address and "Send an email" finally. So that we don't need to repeat the same email content multiple times.

Steps

• Initialize Variable
• Apply to each
  • Switch
  • Set the Variable
  • Send email using To as Variable

Sample

[cheezy]

thanks that did the trick

[cheezy]

thanks will also use the variable as email address