Power Platform Community Forum Thread Details

Hi,

I get Power Automate response in below JSON format:

{

    "body": [

{

            "state": "Andhra Pradesh",

            "capital": "Amaravati",

            "population": 49577103,

            "area": 162975,

            "districts": 26

},

{

            "state": "Arunachal Pradesh",

            "capital": "Itanagar",

            "population": 1383727,

            "area": 83743,

            "districts": 27

},

{

            "state": "Assam",

            "capital": "Dispur",

            "population": 31205576,

            "area": 78438,

            "districts": 35

}

]

}

I want to display the same JSON in a Power Apps screen. My question is which is the control to be used to display this.

Thanks, I appreciate any help.

Categories:

Building Power Apps

Hello @gavasthi1,

As I understand, you want to display an array response from Power Automate to Power Apps. You need to use ParseJSON() with ForAll() to convert the response into a collection, then use that collection in a Gallery.

For your sample JSON (states data), you can do something like this:

For example - this code you need to put in powerapps:

ClearCollect(
    colStates,
    ForAll(
        Table(ParseJSON(YourFlowName.Run().result).body),
        {
            State: Text(Value.state),
            Capital: Text(Value.capital),
            Population: Value(Value.population),
            Area: Value(Value.area),
            Districts: Value(Value.districts)
        }
    )
)

//result - your response key nae from power automate

Please follow the below blog for more detailed step-by-step guidance.

https://www.matthewdevaney.com/power-apps-parsejson-function-get-collection-from-a-flow/

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 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!