All Content
Timespan
explore our new search
Step-by-Step Guide to Parsing JSON in Microsoft Power Apps
Power Apps
Oct 11, 2022 12:00 AM

Step-by-Step Guide to Parsing JSON in Microsoft Power Apps

by HubSite 365 about Microsoft

Software Development Redmond, Washington

Citizen DeveloperPower AppsPower Selection

Unlock Power Apps potential: Learn how to parse JSON as a Microsoft Expert.

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.

Demo Presenter - Cat Schneider | @YerAWizardCat

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate

https://www.json.org/json-en.html

Power Fx: Introducing ParseJSON

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/

Help with Regex to cleanup data and parse JSON

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:

https://powerusers.microsoft.com/t5/Building-Flows/Help-with-Regex-to-cleanup-data-and-parse-JSON/td-p/1611086

Power Apps Samples by CatSchneider

https://github.com/CatSchneider/powerapps-samples