cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IssacJackson
New Member

How to call JSON reponse data from API into the power App?

I connected to a Custom Connector API. But I can not able to call the data into the canvas Power app. Like I called the Excel data as Table.Coloumn1 .So How can I call the JSON response from my API? I can't find any documentation on this.

1 ACCEPTED SOLUTION

Accepted Solutions
mike528
Resolver II
Resolver II

Not sure I am completely understanding what you are trying to do, but for processing a JSON return from a Connector, I tend to call a flow in Power Automate, which calls the connector, then process the JSON response using Request.Response which will then return the JSON as a record or table to PowerApps you can then access directly, load into a collection, etc.

This post addresses shows an example of using this connector in Flow to return data to powerapps.

https://powerusers.microsoft.com/t5/Building-Flows/Parse-Json-in-Flow-to-PowerApps/td-p/318261

 

PowerApps does not natively allow for processing JSON strings. You can create them, but there is no jQuery type functionality as of yet. Please vote this idea up. https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Parse-JSON-in-PowerApps/idc-p/594281

 

Hope that helps

View solution in original post

1 REPLY 1
mike528
Resolver II
Resolver II

Not sure I am completely understanding what you are trying to do, but for processing a JSON return from a Connector, I tend to call a flow in Power Automate, which calls the connector, then process the JSON response using Request.Response which will then return the JSON as a record or table to PowerApps you can then access directly, load into a collection, etc.

This post addresses shows an example of using this connector in Flow to return data to powerapps.

https://powerusers.microsoft.com/t5/Building-Flows/Parse-Json-in-Flow-to-PowerApps/td-p/318261

 

PowerApps does not natively allow for processing JSON strings. You can create them, but there is no jQuery type functionality as of yet. Please vote this idea up. https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Parse-JSON-in-PowerApps/idc-p/594281

 

Hope that helps

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (66,557)