Apply to each in array - extract key/values

(1) Share

Report

Posted on by WebPortal

2,295

In Power Automate, I get the following object out of a Parse JSON action:

{
    "body": {
        "order_id": "ORD-20250221-001",
        "order_date": "2025-02-21",
        "order_total": 1349.98,
        "payment_method": "Credit Card",
        "order_status": "Processing",
        "estimated_delivery_date": "2025-02-25",
        "shipping_carrier": "FastExpress",
        "tracking_number": "FAST123456789US"
    }
}

The number of items in this object is variable.

I want an array that I can loop in an apply to each and extract each key/value.

I've managed to convert the JSON into an array with a compose:

replace(replace(string(body('Parse_JSON')),'{','['),'}',']')

And:

split(outputs('Compose'),',')

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi

I am not sure what you are asking help with, Thank you for sharing your flow, but whgich part are you stuck on?

Are you turning it into an Array?

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

@FLMike,

I'd like an apply to each on the array:

Add a new row per item on a Dataverse table.
Column A: key

Column B: value

Was this reply helpful? Yes No