Parse JSON from PowerApps Collection

(0) Share

Report

Posted on by 55552

669

I have a JSON input as follows, derived from a PowerApps Collection (using a Send to Flow action) with three columns. Schema first, then the ouput. I am having difficulty parsing the JSON and getting the values for the three columns (PalletID, SeriesID, and SeriesName).

Any ideas on how to construct a compose or Select action after the Parse JSON to parse out these values?

Thanks.

{

"type": "object",

"properties": {

"text": {

"title": "JSONBody",

"type": "string",

"x-ms-dynamically-added": true,

"description": "Please enter your input",

"x-ms-content-hint": "TEXT"

}

"required": [

"text"

]

}

{

"text": "[{\"PalletID\":\"001\",\"SeriesID\":\"000\",\"SeriesName\":\"FoamPallets\"},{\"PalletID\":\"002\",\"SeriesID\":\"000\",\"SeriesName\":\"FoamPallets\"},{\"PalletID\":\"003\",\"SeriesID\":\"000\",\"SeriesName\":\"FoamPallets\"},{\"PalletID\":\"314\",\"SeriesID\":\"300\",\"SeriesName\":\"SteelHeaderPallets\"}]"

}

All responses (2)

Answers (1)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: Parse JSON from PowerApps Collection

Hi @Runner55552 ,

Glad to see you solved the problem. You could mark your answer/solution as a 'Solution' to allow more people with the same problem to solve their own problem as quickly as possible. Thank you so much!

Best Regards,
Dezhi
Verified answer

55552 669 on at

Like (0)

Report

Re: Parse JSON from PowerApps Collection

Ok, I answered my own question. I forgot to use the output above as the input to the Sample Schema in the Parse JSON step. After I did that correctly, the columns of data were readily available in subsequent steps.