Receiving information in JSON requires parsing to use it in a Power App. In this 7-minute citizen developer-focused demo, let Cat Schneider share her insights on JSON, key-value pairs and RegEx.
See a flow that takes a JSON string to parse, inserts information into an HTML table and then sends the result to a Power App – shows up as key value pairs in a gallery. Solution development lessons learned, and resources shared. This PnP Community demo is taken from the Microsoft Power Platform community call – September 2022, recorded on September 21, 2022.
https://www.json.org/json-en.html
We are pleased to announce the experimental release of our ParseJSON function, which can parse JSON strings into Power Fx objects and types.
https://powerapps.microsoft.com/en-gb/blog/power-fx-introducing-parsejson/
Hello,
I am attempting to accept API data on a few of our aircraft and post that to an SP List. I'm new to this process and am having a hard time parsing the data and getting the properties I want because of the format: