Assign Approvers in Flow based on a Response field on a form and lookup table
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?