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.
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!
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.
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 ...