Utility - Array Filter Items

** AVAILABLE SEPTEMBER / OCTOBER 2024 **

Overview

The 'Array Filter Items' utility action for Power Automate filters the items in the JSON array provided or targeted using a JSONPath expression.

Credit Count

This is a Utility action and therefore consumes only 0.05 credits per operation (except 1 credit on the free plan). For example, 100 operations will consume 5 credits on a trial and all paid plans.

Parameters

The default 'Array Filter Items' utility action parameters are detailed below:

• Data: The JSON data to filter
• Keywords: A comma-separated list of keywords used to filter the JSON data provided
• Match Type: Set how items should be filtered using the keywords provided

Advanced Parameters

The advanced 'Array Filter Items' utility action parameters are detailed below:

• Ignore Case: Set whether text case should be ignored when filtering items
  
• Path: Select a specific node within the 'Data' using a JSONPath expression

Return Parameters

Action Specific Return Values

• Result - The filtered items from the JSON array provided

Standard Return Values

• OperationId - The unique ID assigned to this operation.
• HttpStatusCode - The HTTP Status code for the response.
• HttpStatusMessage - The HTTP Status message for the response.
• Errors - An array of error messages should an error occur.
• Operation Status - Indicates whether the operation has been completed, has been queued or has failed.