Skip to main content

PowerApps PowerFx ParseJSON Function

Today we start looking at another feature from the feature list called ParseJSON. We have already seen Named Formulas and Find and Replace in our previous blog(s).

In today’s world where most of the solutions are shifting towards Restfull WebAPI’s receiving JSON responses and having a built-in parsing feature will be the cherry on the cake.

PowerApps most recent release allows us to take JSON and extract properties from untyped objects.

What is ParseJSON function?

Use the ParseJSON function to parse data in the JSON format and create untyped objects. Use the dot operator and the Index function to navigate an untyped object. Use the Table function to convert JSON arrays into tables. Use the Value, Text, and Boolean functions to restore the type of primitive data. Use the DateValue, DateTimeValue, TimeValue, ColorValue, and GUID functions to convert untyped strings into typed objects.

How to enable ParseJSON feature?

Assuming you have already created an app and you are using the latest version of PowerApps studio. Click on settings on the top bar of the screen. 

image

You need to select Upcoming Features and select the Experimental Features option and search with “Parse” in top search bar. 

You should now see the “ParseJSON” feature, just enable it.

Graphical user interface, text, application, Teams Description automatically generated

How to use ParseJSON?

Let’s say we have a JSON payload like the below. And we will be extracting values out of it.

{"name":"John", "age":30, "car":null}

I am taking a Text Input control to put JSON body in it. Add above text in Default property of Text Input that we recently added.

Similarly, we will be adding a couple of labels and we need to add the below code in the Text property of the respective label.

Text (ParseJSON(TextInput1.Text).name)

Text (ParseJSON(TextInput1.Text).car)

So, the final output should be something like below.

image

We need to pass json text in ParseJSON function, as the output of name and car is Text so we need to type cast ParseJSON response to text.

Similarly, if we want to derive the age of the person our formula will be.

Value(ParseJSON(TextInput1.Text).age)

 

Hope this helps!

Thanks,

Keyur

Labels:

Comments

Post a Comment

Popular posts from this blog

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...
2 comments
Read more

OneDrive Sharing Report: A Comprehensive Guide

OneDrive Sharing Report Managing and monitoring the sharing permissions of files stored in OneDrive can be a critical task for organizations. This guide provides a step-by-step walkthrough of how to create an Azure AD application with specific permissions, generate a client secret, and use a PowerShell script to retrieve and report the sharing permissions of OneDrive files. By following these steps, you will be able to audit and control file sharing across your organization, ensuring security and compliance. Step 1: Creating an Azure AD Application To get started, you'll need to create an Azure AD application that will allow you to interact with the Microsoft Graph API and retrieve information about users' OneDrive files and sharing settings. Specifically, you need to set the following permissions: Directory.Read.All Directory.ReadWrite.All Files.Read.All ...
Post a Comment
Read more

SharePoint Server continuously prompting for Credentials

Sometimes it is the case when your SharePoint server keeps on prompting for credentials. After some amount of googling and going through some reliable blogs I found following solution. Open Run Type “regedit”.                                                                  In the registry window left panel find HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > LSA                                                                                                                      Now right clic...
3 comments
Read more