web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Advanced Filter syntax
Power Automate
Suggested Answer

Advanced Filter syntax

(0) ShareShare
ReportReport
Posted on by

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:

  • Column_Name: This column contains values like Value A, Value C, Value B, etc.
  • Array to Match: ["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?

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,527 Super User 2025 Season 2 on at
    Rows of what?  Where does the data originate? Did you load it into an array?
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at
    Hi,
     
    If you are planning to do via Odata filter query, contains approach is not supported for array as you require. But there is another way you can try around using or approach, this will create or conditions dynamically based on array elements.
     
    Assume you have a column name as FailedStation, I need to filter whether the column contains FS1 or FS2 in Sharepoint list. Refer how to do it as shown below:
     
    1. Use select action to convert the array values to filter query syntax as shown below.
     
    Expression - 
    concat('FailedStation eq ','''',item(),'''')
     
    2. Use join function to join all the elements of select action using or delimiter as shown below
     
     
    Expression-  join(body('Select'),' or ')
     
    3. Use the compose action's output in filter query field in get items action (if you are using sharepoint)
     
     
    So when you run - you will see the result like this
     
     
    So you can understand that how the array values can be converted to filter query.
     
    Hope it helps !
     
    Thanks & Regards,
    Nived N
     
    Mark it as solution if it resolves your query !
     
     
     
  • Expiscornovus Profile Picture
    33,374 Most Valuable Professional on at
    With the same approach Nived shared you could also use a substringof function to check multi-valued choice type of fields.
     
    1. The append to array variable action
    substringof('@{item()}',Column_Name)
     
    2. The OData filter
    join(variables('ODataQuery'), ' or ')

    Test result

    ​​​​​​​

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Expiscornovus Profile Picture

Expiscornovus 185 Most Valuable Professional

#2
harshdeol Profile Picture

harshdeol 167 Moderator

#3
S-Venkadesh Profile Picture

S-Venkadesh 159 Moderator

Last 30 days Overall leaderboard