Skip to main content
Community site session details

Community site session details

Session Id : xo9sd6qmdUfCyogZhL80PK
Power Automate - Using Flows
Unanswered

Parse Json

Like (0) ShareShare
ReportReport
Posted on 16 Jun 2017 16:56:40 by

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"?

 

 

  • v-yamao-msft Profile Picture
    on 20 Jun 2017 at 08:45:36
    Re: Parse Json

    Hi Parimal84,

     

    It seems that currently we are not able to customize JSON file via Flow. If you are familiar with Custom API, please consider to integrate a Custom API with Flow. Please see this blog for more details:
    https://flow.microsoft.com/en-us/blog/integrating-custom-api/

     

    Or you could also consider to submit an idea at Flow Ideas Forum on this issue, I will collect and report it on my side.


    Best regards,
    Mabel Mao

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete