Append object to array

(0) Share

Report

Posted on by xvzms

103

Hi,
I want to get an array like this:

[
  {
    "sender": "Sales",
    "message": "Please clarify",
    "timestamp": "12/11/2024 4:36 PM"
  },
  {
    "sender": "Recipient",
    "message": "This is a risk total.",
    "timestamp": "12/11/2024 4:37 PM"
  }
]

I tried to create Power Automate workflow, but got this:

[
  "{\n    \"sender\": \"Sales\",\n    \"message\": \"Please clarify\",\n    \"timestamp\": \"12/11/2024 4:36 PM\"\n},",
  "{\n    \"sender\": \"Recipient\",\n    \"message\": \"This is a risk total.\",\n    \"timestamp\": \"12/11/2024 4:37 PM\"\n},"
]

This is my flow:

How can I achieve this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

In your Power Automate flow, use the "Initialize Variable" action. Set the type to Array and name it something like MyArray.

Use the "Append to Array Variable" action to add objects to the array. For example:

{
"sender": "Sales",
"message": "Please clarify",
"timestamp": "12/11/2024 4:36 PM"
}
Add another similar action for the next object:

{
"sender": "Recipient",
"message": "This is a risk total.",
"timestamp": "12/11/2024 4:37 PM"
}
Make sure you are adding the objects directly as shown above. Do not enclose them in quotes or use any string-related expressions.

To confirm, add a "Compose" action after you've appended all objects. Use the array variable MyArray in the "Input" field of the Compose action.

Run the flow. The output from the "Compose" action should now show an array of objects, not strings.

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (1)

Report

Hi @xvzms

Replace this:

With this the current item:

My results:

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,725 Most Valuable Professional on at

Like (1)

Report

The problem is that the values in the Compose will be interpreted as a String, not a JSON array. Just declare the array in the Initialize Variable action. That will give you the array you want.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No