Extract string from JSON in PowerApps

Question

In PowerApps, I’ve received a JSON string containing several columns, and I need to extract specific column information from this JSON. Which function can assist me in achieving this?

Answer 1

How to Extract string from JSON in PowerApps?

The ParseJSON function in PowerApps allows us to parse data in JSON format, whether it is simple complex, or array-based. We can use the output of the ParseJSON function to traverse through our JSON objects using dot notation, the index function, and other functions.

Suppose we have this JSON string that we need to extract the different information from it.

Fromula

{ "Name": "Heba Kamal" ,"Age": 22, "Active":false,"ReleaseDate" : "2022-09-01"}	

Output

For more details, kindly check PowerApps Parse JSON Examples