web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / I can't get JSON from ...
Power Apps
Unanswered

I can't get JSON from a Power Automate response to show up on my Canvas App as a table or even just a label. The most I get is 'true'.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

My canvas app is connected to a Power Automate flow that makes an HTTP call to a GraphQL endpoint. The (edited down) response looks like this:

 

{
 "data": {
 "aWSPrices": [
 {
 "id": "229f8c1a-b0ad-490d-bbc5-1932437c571c",
 "offerCode": "AMAZONROUTE53REGIONALCHINA",
 "version": "20210422213356",
 "publicationDate": "2021-04-22T21:33:56.000Z",
 "productSku": "A2FBGTVWPQMCDBGT",
 "productFamily": "DNS Query",
 "productAttributes": null,
 "terms": null,
 "offerAttributes": null
 }]
 }
}

 

 

The schema in the Response step from the flow was generated automatically from this sample as such (I removed the 'required' attribute as mentioned in other posts):

 

{
 "type": "object",
 "properties": {
 "data": {
 "type": "object",
 "properties": {
 "aWSPrices": {
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "id": {
 "type": "string"
 },
 "offerCode": {
 "type": "string"
 },
 "version": {
 "type": "string"
 },
 "publicationDate": {
 "type": "string"
 },
 "productSku": {
 "type": "string"
 },
 "productFamily": {
 "type": "string"
 },
 "productAttributes": {},
 "terms": {},
 "offerAttributes": {}
 }
 }
 }
 }
 }
 }
}

 

 

 

 

My current attempt is to return `body('HTTP').data.aWSPrices` so that just the array of objects is returned to my PowerApp and put into either just a label or a data table. I'm just trying to get any actual JSON data to show up in my PowerApp so that I can build from there and eventually turn this into either a gallery table or basic data table. I attempt to assign this response to a variable in a few different ways so far. This is from the OnSelect property of a button that calls the Power Automate:

 

Set(gqlCallResponse, aWSPrices_GraphQL.Run());
Set(gqlCallResponseJSON, JSON(gqlCallResponse));
ClearCollect(graphQLCallResponse, gqlCallResponseJSON);

 

 

 

 

I've tried mapping gqlCallResponse, gqlCallResponseJSON, and graphQLCallResponse to either a lable or a data grid and none have worked. The only thing I get is a 'true' value in the label (it starts as false until I click the button). The data table then only has one field that I can select which is the 'true' field. I set the Items property to graphQLResponse but that doesn't work either.

 

aec2018_0-1632941601854.png

 

 

I'm pretty lost at this point on how to get this response into my canvas app so that I can build a table from it. Any ideas? 

 

 

Categories:
I have the same question (0)
  • Anousha Profile Picture
    34 on at

    When you run your flow try ClearCollect(MyDataTable, aWSPrices_GraphQL.Run().data); That should bring in your json data into a collection.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard