Normally I try hard to figure out a solution before posting here, but I've been working 12+ hour days for three straight weeks, and I just need some help.
I have a flow that takes inputs from a MS Form, and inserts some of those inputs into an email. I also have two SP Lists, one is a list of people and their email addresses, and the other is a list of "teams" that have two lookup columns for "team lead" and "assistant team lead". For the two lookups, I've included each individual's email address. So the "Team" list has five columns: Team Name, Team Lead Name, Team Lead Email, Team Asst Lead Name, Team Asst Lead Email.
I need the action that when the form comes in will assess a choice field input (i.e. "Team Name") against the SP List of Team Names, and then grab the Team Lead Email and Team Asst Lead Email and plug those into the email. I feel like this should be pretty easy... but I just don't have the brain power right now.
Any help is appreciated.

Report
All responses (
Answers (