Using ParseJSON in Power Apps to populate a gallery with outputs from Graph
In this post, I’ll explain a bit about the ParseJSON in Power Apps and how you can use this function to get a number of records back from Microsoft Graph using
In this post, I’ll explain a bit about the ParseJSON in Power Apps and how you can use this function to get a number of records back from Microsoft Graph using Power Automate and then use this data in your app.
So, what does the ParseJSON() function let us achieve?
ParseJSON() effectively lets us take a JSON object and understand that in Power Apps. So lets say you have a flow that gets a number of records using the HTTP call step and the Graph API. Now you’re feeding that back into your app using a string output, even though the value isn’t a string. Now Power Apps needs to understand that data we’re bringing back.
Table of Contents
- ParseJSON()
- The scenario
- Building the Flow
- Building our App
More about this Feature
In Power Apps, the ParseJSON function can be used to access data from a Graph API call and populate a gallery with outputs. The ParseJSON function takes a JSON string as an argument and converts it into an internal table that is accessible in Power Apps. This allows you to quickly create galleries of items from API calls without having to manually enter each item individually. To use the ParseJSON function, you will need to know how your API response is structured so that you can map out which fields should be included in your gallery. Once this mapping has been established, all you have to do is pass your response into the ParseJSON function and let it do its work!
More links on about Power Platform/Power Apps
- Parse Json in Flow to PowerApps - Power Platform CommunityHi all, I've got a flow that pulls data from Azure AD via Graph and i've got it all working up until I try to return the data into my.
- How to Parse JSON in Microsoft Power Automate - Encodian
Apr 29, 2020 — Several Encodian actions return JSON data, and before that data can be consumed and used within Power Automate, it must be parsed.
- PowerApps - Using JSON Function to save Pictures
Jul 8, 2019 — The first step to add is a Parse JSON action to convert the JSON into an array. In order for the parameter requested by Flow to be named nicely ...
Questions and Answers about Power Platform/Power Apps-
- How to parse JSON data in PowerApps?
The ParseJSON function will parse a valid JSON string and return an untyped object representing the JSON structure. The ParseJSON function may return errors if the text isn't valid JSON according to the JavaScript Object Notation (JSON) format described in ECMA-404 and IETF RFC 8259.
- How to get value from parse JSON in Power Automate? After this use parse JSON action and pass the outputs of the above compose. And in schema, click on generate from sample and paste the above array in that. Then use Apply to each and pass the body of parse JSON and then use two compose to store column in one and value in other.
- How to use JSON in PowerApps?