Utility - Array Combine

** AVAILABLE SEPTEMBER / OCTOBER 2024 **

Overview

The 'Array Combine' utility action for Power Automate combines the JSON arrays provided as per the set configuration.

Usage Notes

A sample input and output is provided below:

Input Data:

[
  {
    "ID": 1,
    "Name": "Alex"
  },
  {
    "ID": 2,
    "Name": "John"
  }
]

Input Merge Data:

[
  {
    "ID": 1,
    "Surname": "Smith"
  },
  {
    "ID": 2,
    "Surname": "Doe"
  }
]

Using Data Key "ID", the output will be:

[
  {
    "ID": 1,
    "Name": "Alex",
    "Surname": "Smith"
  },
  {
    "ID": 2,
    "Name": "John",
    "Surname": "Doe"
  }
]

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

• Data: The JSON array or object to evaluate
• Merge Data: The JSON array or object to evaluate and merge into 'Data'
• Data Key: The key attribute to be used when combining 'Data' to 'Merge Data'
• Merge Data Key: The key attribute to be used when combining 'Merge Data' to 'Data'
  • Gives the ability to merge JSON arrays based on different keys
  • If not provided, the 'Data Key' value will be used as the key for both JSON arrays

Advanced Parameters

The advanced 'Array Combine' 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 combined 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.