Answered

How to flatten a nested JSON using Apply to each in Power Automate?

(0) Share

Report

Posted on by D365FO Junior-Dev

123

Hi Everyone,
I have a JSON object that contains a header and a list of lines I want to flatten this data so that the output looks like the example below

I am using an HTTP action to get the JSON response from an API endpoint.
My question is how can I use Apply to each or loop to flatten the header and line data into a single structure? at the end of the flow I want to have this output

ExpenseReportNumber: ER-000245
EmployeeId: EMP-1023
EmployeeName: John Smith
LegalEntity: USMF
ReportName: Business Trip to Berlin
Purpose: Client meetings and technical workshop
ReportDate: 2025-12-10
CurrencyCode: EUR
TotalAmount: 485.75
Status: Submitted


LineNumber: 1
ExpenseCategory: Hotel
TransactionDate: 2025-12-07
Description: Hotel accommodation – Berlin
Amount: 280

LineNumber: 2
ExpenseCategory: Meals
TransactionDate: 2025-12-08
Description: Client dinner
Amount: 95.75

LineNumber: 3
ExpenseCategory: Transportation
TransactionDate: 2025-12-09
Description: Taxi to client office
Amount: 110

the API response :

{
  "ExpenseReportHeader": {
    "ExpenseReportNumber": "ER-000245",
    "EmployeeId": "EMP-1023",
    "EmployeeName": "John Smith",
    "LegalEntity": "USMF",
    "ReportName": "Business Trip to Berlin",
    "Purpose": "Client meetings and technical workshop",
    "ReportDate": "2025-12-10",
    "CurrencyCode": "EUR",
    "TotalAmount": 485.75,
    "Status": "Submitted"
   


  },
  "ExpenseReportLines": [
    {
      "LineNumber": 1,
      "ExpenseCategory": "Hotel",
      "TransactionDate": "2025-12-07",
      "Description": "Hotel accommodation – Berlin",
      "Amount": 280,
      "CurrencyCode": "EUR",
      "SalesTaxAmount": 19.6,
      "MerchantName": "Berlin Central Hotel",
      "PaymentMethod": "CorporateCard",
      "ProjectId": "PRJ-001",
      "CostCenter": "IT-OPS",
      "ReceiptRequired": true
    },
    {
      "LineNumber": 2,
      "ExpenseCategory": "Meals",
      "TransactionDate": "2025-12-08",
      "Description": "Client dinner",
      "Amount": 95.75,
      "CurrencyCode": "EUR",
      "SalesTaxAmount": 7.25,
      "MerchantName": "City Grill Restaurant",
      "PaymentMethod": "CorporateCard",
      "ProjectId": "PRJ-001",
      "CostCenter": "IT-OPS",
      "ReceiptRequired": true
    },
    {
      "LineNumber": 3,
      "ExpenseCategory": "Transportation",
      "TransactionDate": "2025-12-09",
      "Description": "Taxi to client office",
      "Amount": 110,
      "CurrencyCode": "EUR",
      "SalesTaxAmount": 8.9,
      "MerchantName": "Berlin Taxi Service",
      "PaymentMethod": "Cash",
      "ProjectId": "PRJ-001",
      "CostCenter": "IT-OPS",
      "ReceiptRequired": false
    }
  ]
}

Categories:

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

Kalathiya 1,985 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @D365FO Junior-Dev,

You can use the Parse JSON action in Power Automate to flatten your data. In the Content field, pass the response body from your HTTP action. Then click on “Generate from sample” and upload your sample JSON schema from the API response.

Once parsed, you can use an Apply to Each loop on the lines array. Inside the loop, combine the header fields with each line item to create a flattened structure

📩 Need more help? Mention@Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping

Was this reply helpful? Yes No
Verified answer

Ish S 96 on at

Like (1)

Report
Copy link

Link copied!

Hi @D365FO Junior-Dev,

If you want to get that output then below is a sample flow to get that output. Also below is the schema parse json:

Parse schema:

{

    "type": "object",

    "properties": {

        "ExpenseReportHeader": {

            "type": "object",

            "properties": {

                "ExpenseReportNumber": {

                    "type": "string"

                },

                "EmployeeId": {

                    "type": "string"

                },

                "EmployeeName": {

                    "type": "string"

                },

                "LegalEntity": {

                    "type": "string"

                },

                "ReportName": {

                    "type": "string"

                },

                "Purpose": {

                    "type": "string"

                },

                "ReportDate": {

                    "type": "string"

                },

                "CurrencyCode": {

                    "type": "string"

                },

                "TotalAmount": {

                    "type": "number"

                },

                "Status": {

                    "type": "string"

                }

            }

        },

        "ExpenseReportLines": {

            "type": "array",

            "items": {

                "type": "object",

                "properties": {

                    "LineNumber": {

                        "type": "integer"

                    },

                    "ExpenseCategory": {

                        "type": "string"

                    },

                    "TransactionDate": {

                        "type": "string"

                    },

                    "Description": {

                        "type": "string"

                    },

                    "Amount": {

                        "type": "number"

                    },

                    "CurrencyCode": {

                        "type": "string"

                    },

                    "SalesTaxAmount": {

                        "type": "number"

                    },

                    "MerchantName": {

                        "type": "string"

                    },

                    "PaymentMethod": {

                        "type": "string"

                    },

                    "ProjectId": {

                        "type": "string"

                    },

                    "CostCenter": {

                        "type": "string"

                    },

                    "ReceiptRequired": {

                        "type": "boolean"

                    }

                },

                "required": [

                    "LineNumber",

                    "ExpenseCategory",

                    "TransactionDate",

                    "Description",

                    "Amount",

                    "CurrencyCode",

                    "SalesTaxAmount",

                    "MerchantName",

                    "PaymentMethod",

                    "ProjectId",

                    "CostCenter",

                    "ReceiptRequired"

                ]

            }

        }

    }

}

If these suggestions help resolve your issue. Please consider marking the answer as such.

Was this reply helpful? Yes No