cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanderson62089
Frequent Visitor

Forms to Approval email question

We have a Form for project proposals that I'm trying to connect to Approvals. The first question asks which category the project fall into, and the answer determines which manager would need to review the proposal. Is there a way I can set up the Flow so that the Approval request is sent to a specific manager depending on the answer to that first question?

1 ACCEPTED SOLUTION

Accepted Solutions
pstork
Frequent Visitor

You can either put a switch action early in the flow to set a variable equal to the email of the manager based on the answer or if there quite a few you could use a two column list in SharePoint or Excel where one column is the answer and the other is the email to send the approval to.  Then just retrieve the row and filter it with the question answer.  Then use that email.

View solution in original post

1 REPLY 1
pstork
Frequent Visitor

You can either put a switch action early in the flow to set a variable equal to the email of the manager based on the answer or if there quite a few you could use a two column list in SharePoint or Excel where one column is the answer and the other is the email to send the approval to.  Then just retrieve the row and filter it with the question answer.  Then use that email.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (3,405)