Utility - Array Remove Duplicates


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.


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.


Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk