Power Platform Community Forum Thread Details

Hello,

I have a flow built that looks like this:

Once someone completes the event registration form, it adds the registration information to my Microsoft List and sends the registrant a confirmation email.

I'd like to take it a step further and auto-assign an employee to each item based on a choice response in the form. For example, if the registrant selects "Texas" as their home state, I want it to automatically assign it to Bob who is our account manager for the state of Texas. I think of it as a vlookup, but I'm very new to everything Power Automate and not sure how to achieve this...

Any help would greatly be appreciated!

Categories:

Building flows

Hi there. What I would do is one of the following:

1) Scenario 1:

Add a step where you initialize a variable of type string

Add condition steps where you say if: response field is equal to Texas then set variable from previous step to responder's email else if else if......

And after all these conditions update your created item with the responder's email and send 2 emails one to the customer and one to the responder.

2) Scenario 2:

Create a new SP list which will be for your configuration. In this SP list you may have Location column and Responders column.

So when you create the item you get the location response from the form and then do a Get Items from the new SP list with filter: where Location -eq 'field response from form'

After this you will get the Responders column you create a Select task (Data - Select). THen click on the little icon at the bottom right of this step. In this step inside from. use this:

first(body('Name of New SP List')?['Value'])?['Responders Column Name']

and inside Map use the Email from the dynamic options of Powerflow from the Get Items of the new SP List.

Then you create a new Join task (Data - Join). Inside from you use Output from the previous step (Select step) and inside the join use this ;

Then you will create a task to update your Created SP item to get the output from the previous step and use the same output to send email to responder.

Let me know if this helps