Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Comparing Two Lists Data and Send Relevant Emails Based on Comparison



I'm fairly new to PowerApps and Flow, but I'm trying to build a process based on a business process that has been designed.


I have a form that allows people to submit a request for a project, then shoots an email to a member of my organization to choose the teams that will need to work on the project. I have that Flow working successfully.

The next part gets tricky.


Based on the teams that this person selects, I need either PowerApp or Flow to compare those choices to a different control list which lists the specific person assigned to each team, who would need to receive an email based on relevancy. So if teams 1, 2, 3 are chosen then people A, B, and C need to receive emails (it gets a little fishier when person D is supposed to receive emails whenever 1 and/or 3 is chosen as well). If teams 1 and 3 are chosen, then people A, C, and D need to receive emails. If team 2 is chosen, only person B would receive an email.


I hope this makes sense. This is complicated and pretty confusing, but I've spent the better part of this week trying to figure it out. I am hoping someone can help me with a solution.


Thank you!

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,221)