Filter Array #PowerAutomate

An array is a collection of data, such as a list of names, numbers, or objects. Power Automate allows you to filter arrays by specifying certain conditions, so that only the elements that meet those conditions will be included in the final output.

For example, let’s say you have an array of customer data, and you want to filter out all customers who have not made a purchase in the past month. With Power Automate, you can set up a filter that checks the purchase date for each customer, and only includes those that have made a purchase within the last 30 days.

Another example is, you have an excel sheet, and you want to filter out the all rows where column “Name” is “John” . You can use “Filter array” action in Power Automate to filter out all rows where column “Name” is “John”

There are many different ways to use the filter array feature in Power Automate, and it can be a valuable tool for automating your workflows and streamlining your business processes.

The best scenario I used to use filter array is to reduce redundant queries on a flow. Let say you want to query a table and but for different steps you need a different type to be filtered on the same table. In this case, we can have one query that filter off a broader filter and use the filter array connector to filter on the sub category filter late whenever it is needed.

The basic mode only lets you to specify only one filter condition, toggle to advanced more will help to configure multiple filter which is quite handy to use.

In summary, Power Automates “Filter array” action is a powerful tool that allows you to easily filter arrays of data based on specific conditions, which can help you automate your workflows and streamline your business processes. This action can be used in various scenarios like filtering excel rows, SharePoint list items, etc.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s