Power Platform Community Forum Thread Details

Parse Json

I am doing an HTTP call which returns JSON data. Here is the sample data.

{
"fields": {
    "005 Location": {
      "text": "Admin",
      "id": "6728f83f-f73f-4f1c-b0a6-a53e00ebf99a",
      "name": "005 Location",
      "type": "TextBox"
    },
    "005 Modify Location": {
      "value": null,
      "id": "4eddf15a-cac1-40db-a753-a53e00f34d9c",
      "name": "005 Modify Location",
      "type": "Database"
    },
    "Inspector": {
      "text": "Parimal Shukla",
      "id": "72314a94-5c0d-4b5d-8f83-a53e01294447",
      "name": "Inspector",
      "type": "TextBox"
    },
    "Joint Quality": {
      "value": null,
      "displayValue": null,
      "id": "10247dde-2fc3-4378-aa6b-a53e01294447",
      "name": "Joint Quality",
      "type": "DropDown"
    },
    "Item": {
      "text": "1200000",
      "id": "4478a447-5f31-423e-9505-a53e0129444b",
      "name": "Item",
      "type": "TextBox"
    },
    "Finish Surfaces": {
      "value": null,
      "displayValue": null,
      "id": "dca1f03e-a0ab-4979-bb1a-a53e0129444b",
      "name": "Finish Surfaces",
      "type": "DropDown"
    }
}
}

It has nested objects with repeating names. When I parse the data using Parse JSON action, it gives me a list in alphabetic order for each field. How can I make the output look like "fields_005_Location_text"?

Quick Links

Leaderboard