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

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:

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

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."

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:

Hope this helps.