Power Platform Community Forum Thread Details

ParseJSON is brand spanking new. Started looking at it last week and it seems to be working nicely. Had a few issues on how to get data out myself in a Gallery, into a label. Finally sorted it so I thought I'd share.

Here is an example of how I’m using it so far …

‘ThisItem.Answer’ …. In a gallery contains the following …

[

"Text 1",

"Text 2",

"Text 3"

]

… using the following code ….

Concat(Table( ParseJSON( ThisItem.Answer )), Text(Value) & "

… gives me …

Text 1

Text 2

Text 3

Also … If you’re dealing with JSON holding records and fields like below. In this example, the gallery records now holds the data below in ‘ThisItem.Answer’ ...

[

{

"name": "TheFileName.xlsx",

"link": "https://YourSite.sharepoint.com/sites/SiteName/_layouts/15/Doc.aspx?sourcedoc=%7B5747E771-9325-475A-AA03-F746E3764231%7D&file=TheFileName.xlsx&action=default&mobileredirect=true"

}

]

… you can use the following to get a field into a label ..

With( First(Table( ParseJSON( ThisItem.Answer ))),

Value.name

)

.. which will give you … ‘TheFileName.xlsx’.

As you are working with tables and records, maybe a ForAll could be used as well. Not yet tried this, if you do, past your results in this thread.