You’re offline. This is a read only version of the page.
I have built a Microsoft Form that asks for a user's location. Based on that location, I need to build a table that has each location assigned to a Region. Each Region is assigned to a different approver. I have built a workflow in Power Automate that allows the Form to create an item and store responses to the form. I then need to send the approval based on the region that is assigned. Is there a way to assign a different approver in Microsoft flow based on a response to a Form?
Can you please show me? I don't understand how to assign the locations to a Region and then the Region to an e-mail address. I have 75 locations broken into 5 regions, Each region has one e-mail address and that e-mail address is the one I need the approval to go to.
I have another form where each of the 75 locations has a different email address it would have to use (a general manager)
I am assuming I need to create a lookup somewhere and then tie it to the question number on the form?
Hi @Anonymous ,
You can follow these steps below:
1- Create an action called "Initialize a variable" with the type String
2- After to get the Forms response, you can create an action called "Switch" and validate manually all regions that you allowed your users to use
3- Inside for each switch condition, you can use the action called "Set a variable", you can define the approvers for these regions separated by semi comma ";"
4- Inside your Approvals action, you can use your variable
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (