Flow - pulling correlated value from a list to assign as a variable

Highlighted
Deleted
Not applicable

I have a list with our 3 offices listed and we have an HR Approver and a Finance approver for new hires. I would like to plug in the approvers into my approval workflow as a variable based on which location which is a value "Location" in the form.

TableExample.PNG

My equation looks like this:

HR-Approver where Locations eq DynamicVariable copy.jpg

 

I know the "Where" clause is not valid. How would one achieve this?

 

The example is someone in the Dallas office submits a request for approval I want "Jill" to show up in the workflow as the approver.

 

In Nintex this is really easy. With Flow I am confused as to how to achieve a similar result. I created a variable called HR-Approver and am trying to assign the approver whose location matches the location passed in the form to that variable.

 

Guidance would be appreciated.

1 Reply
Highlighted

Hi @Deleted,

 

I couldn't tell from your post where you're deriving the LOCATION variable in your screenshot for the formula. As I understand it, that LOCATION would have to be derived from the Requestor's location. I'm not sure how you're doing that now. 

 

Having said that, I created a similar SharePoint list to yours:

Approval-SP-List.PNG

 

 

 

 

 

 

 

 

 

 

And I created a basic Flow with a SharePoint 'Get Items' action, with a Filter Query:

Flow-Action.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Where "Location" matches exactly the internal name of the SharePoint column, and for the time-being I'm hard-coding the location I want. This properly queries the SharePoint list, and returns the one record that has location of "Dallas."

 

output.PNG

 

Hopefully, that gives you a sense for the OData filter syntax. Let me know how you're deriving the requestor's location. 

 

Once you do get the Location in a variable and use it in the filter, you might need to surround it with single quotes:

 

filter-with-quotes.PNG

 

Hope this helps.