You are currently viewing How to use Power Automate filter array?
Power Automate filter array

How to use Power Automate filter array?

In this post we will provide a complete tutorial about how to use Power Automate filter array? , What is filter array in Power Automate ? How does filter array work in Power Automate? and How to use filter array output in Power Automate?

what is filter array in power automate?

  • The “Filter Array” is an action listed in Power Automate under data operation.
  • It used to filter items from an array or a list based on specific criteria such as SharePoint lists or Excel spreadsheets. So it limit or reduce its items based on a single or multiple condition.
  • You can filter an array of records based on a condition or multiple conditions using the advanced mode editor.
  • It take an array of items as its data and return the array of items after applying the filter conditions.
Power Automate filter array

How does Power Automate filter array work?

  • In the form input it takes an array , for example here it takes the output of Get Items from SharePoint.
  • Next apply the condition that you want to filter the input array with , for example here I want to filter the input items to return only the Approval Status that is Automatically Approved. You will find many comparison that you can use to apply your conditions and filter criteria as shown below.
filter3 | Power Platform Geeks
  • These comparisons differ according to the field value , for example if you compare a number field you will find only the below comparisons.
filter4 | Power Platform Geeks
  • The Out put of the Filter array is another array that can then be used in subsequent steps of your Power Automate workflow.
filteroutput | Power Platform Geeks

Filter Array with Multiple Conditions

  • You can apply multiple conditions to the filter array in Power Automate using Edit in advance mode .
  • In advanced mode, you’ll have access to a text editor where you can write your custom filter expressions using the Power Automate expression language, you can use logical operators to Combine Conditions such as Or, And.
    • AND: Use the “and” operator to require that both conditions must be true for an item to be included in the filtered array.
    • OR: Use the “or” operator to include an item in the filtered array if either of the conditions is true.
@and(<Condition 1>,<Condition 2>, <Condition 3>)
@or(<Condition 1>,<Condition 2>, <Condition 3>)
See Also
Join us
Need Help
  • Have a related question? Please ask it at Community.

Heba Kamal

Microsoft MVP, MCT, Technical Speaker, Blogger, and Microsoft 365 and Power Platform Consultant.