cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cheezy
Helper III
Helper III

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Krishna_R
Responsive Resident
Responsive Resident

Hi @cheezy 

I believe u can achieve this by using switch 

Krishna_R_0-1630155068320.png

 

View solution in original post

6 REPLIES 6
Ramole
Super User
Super User

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... 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

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
Responsive Resident
Responsive Resident

Hi @cheezy 

I believe u can achieve this by using switch 

Krishna_R_0-1630155068320.png

 

StalinPonnusamy
Super User
Super User

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

StalinPonnusamy_1-1630159025124.png

 

 

 

thanks that did the trick

thanks will also use the variable as email address

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,000)