Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
111 views
in Power Apps by 26 29 35
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?

1 Answer

2 like 0 dislike
by 48 54 93
selected by
 
Best answer

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

PowerApps Parse JSON Examples

For more details, kindly check PowerApps Parse JSON Examples

If you don’t ask, the answer is always NO!
...