Utility - Array Sort Items

Overview

The 'Array Sort Items' utility action for Power Automate sorts 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 Sort Items' utility action parameters are detailed below:

  • Data: The JSON array or object to evaluate
  • Sort Type: Set whether the data should be sorted numerically or alphabetically
  • Sort Order: Set whether the data should be sorted in Ascending or Descending order

Advanced Parameters

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

  • Path: Select a specific node within the 'Data' using a JSONPath expression

Return Parameters

Action Specific Return Values

  • Result - A sorted JSON array

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

1 Comments

  • 0
    Avatar
    Robert Heep

    I cant seem to figure out the Path property. I kinda was expecting to enter a property by which the array is sorted. But I believe that is meant to navigate to an array inside the json object somewhere. 

    Anyway, it would be good to have an example path with the notation. 

Please sign in to leave a comment.
Powered by Zendesk