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\"}]"
}
