Utility - Array Remove Duplicates

Overview

The 'Array Remove Duplicates' utility action for Power Automate removes duplicates from the JSON array provided or targeted using a JSONPath expression.

Example Flow

Please refer to the following article showcasing how to 'Remove duplicate entries from Excel'

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 Remove Duplicates' utility action parameters are detailed below:

• Data: The JSON array or object to evaluate

Advanced Parameters

The advanced 'Array Remove Duplicates' utility action parameters are detailed below:

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

Return Parameters

Action Specific Return Values

• Result -  The modified JSON array or object

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.