ParseJASON

[qxaziz123]

I have a text field in SharePoint which has a sting [{"App":"App1},{"App":"App2"},{"App":"App3"}]. Which is in JSON format.

I need to use ParseJSON on this string. I have tried Text(ParseJSON( {"App":"App1"} ).App) and it gives me "App1". But how would I use ParseJSON on [{"App":"App1},{"App":"App2"},{"App":"App3"}] so that I get the values App1, App2, App3. 

[timl · Accepted solution]

Hi @qxaziz123 

The syntax would look like this:

Concat(
  Table(ParseJSON(EnterYourJSONHere)),
  Text(Value.App) & ","
)