Display JSON data in Power Apps

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.

Hi Gautam,

In Power Apps (Canvas App), since your JSON contains an array inside body, the correct control to display this data is a:

Gallery Control:

Because:

Your JSON has multiple records (states).
A Gallery is designed to display lists/arrays of records.
It can dynamically show all items from the body array.

How to Use It-

Convert JSON to Collection (If coming from Power Automate)

If you're calling a flow, it typically returns something like:

Set(varResponse, YourFlow.Run());

Then convert the body to a collection:

ClearCollect(
    colStates,
    varResponse.body
)

Insert a Gallery

Go to Insert --> Gallery --> Vertical Gallery
Set the Items property to:

colStates

Add Labels Inside the Gallery

Inside the gallery template, add labels and set their Text property:

State:
```
ThisItem.state
```
Capital:
```
ThisItem.capital
```
Population:
```
ThisItem.population
```
Area:
```
ThisItem.area
```
Districts:
```
ThisItem.districts
```

Alternative (If You Just Want Raw JSON Text)

If you simply want to display the raw JSON as text (not formatted list):

Use a Label or Text Input (Multiline) control and set:

JSON(varResponse.body, JSONFormat.IndentFour)

But this is only for display — not structured viewing.

Final Recommendation

Use a Gallery control to properly display structured JSON array data.
Use a Label/Text Input only if you want to show raw JSON text.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Raghunath Bhukan6mo ago
Accepted answer
Hi Gautam,
In Power Apps (Canvas App), since your JSON contains an array inside body, the correct control to display this data is a:
Gallery Control:
Because:
- Your JSON has multiple records (states).
- A Gallery is designed to display lists/arrays of records.
- It can dynamically show all items from the body array.
How to Use It-
1. Convert JSON to Collection (If coming from Power Automate)
If you're calling a flow, it typically returns something like:
```
Set(varResponse, YourFlow.Run());
```
Then convert the body to a collection:
```
ClearCollect(
    colStates,
    varResponse.body
)
```
1. Insert a Gallery
- Go to Insert --> Gallery --> Vertical Gallery
- Set the Items property to:
```
colStates
```
1. Add Labels Inside the Gallery
Inside the gallery template, add labels and set their Text property:
- State:
  ThisItem.state
- Capital:
  ThisItem.capital
- Population:
  ThisItem.population
- Area:
  ThisItem.area
- Districts:
  ThisItem.districts
Alternative (If You Just Want Raw JSON Text)
If you simply want to display the raw JSON as text (not formatted list):
Use a Label or Text Input (Multiline) control and set:
```
JSON(varResponse.body, JSONFormat.IndentFour)
```
But this is only for display — not structured viewing.
Final Recommendation
- Use a Gallery control to properly display structured JSON array data.
- Use a Label/Text Input only if you want to show raw JSON text.
+1