I am working on a Power Automate flow where I need to filter rows based on whether the values in a specific column match any value in a predefined array. Here's an example of what I am trying to achieve:
Value A
, Value C
, Value B
, etc.["Value A", "Value B"]
I want to filter rows where Column_Name matches any value in the array ["Value A", "Value B"]
.
I tried using the eq
operator, but I’m not sure how to make it work for multiple values in an array. Is there a way to use an OData filter query or an expression to achieve this in Power Automate?
substringof('@{item()}',Column_Name)
join(variables('ODataQuery'), ' or ')
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.