Share
Report
199I am building a flow that is triggered from Powerapps. The trigger grabs a collection from Powerapps, passed as a JSON, and will use that data to populate a Word template.
I am currently working in the Powerapps(v2) trigger, but I tried the v1 trigger and it was behaving the same way. Here is how the trigger is configured.
When I run the flow, this is the output for the body.
"body": {
"text": "[{\"crd93_bawfinishid\":\"PL-2\",\"crd93_item\":\"Formica - 7012-58 - Amber Maple\",\"crd93_jobno\":\"22-117\",\"crd93_submittalid\":\"5ee21905-104f-ed11-bba1-000d3a338f6f\",\"crd93_submittalno\":\"22-117-01\",\"crd93_submittalstatus\":858310000,\"crd93_submittaltype\":858310002,\"createdon\":\"2022-10-18T18:09:37.000Z\"},{\"crd93_bawfinishid\":\"SS-1\",\"crd93_item\":\"LG Hausys Hi-Macs - G118 - Moon Haze\",\"crd93_jobno\":\"22-117\",\"crd93_submittalid\":\"7c46904a-124f-ed11-bba1-000d3a338f6f\",\"crd93_submittalno\":\"22-117-04\",\"crd93_submittalstatus\":858310000,\"crd93_submittaltype\":858310002,\"createdon\":\"2022-10-18T18:25:55.000Z\"}]",
"text_1": "Approval",
"text_2": "Email",
"text_3": "8517ea26-7f15-ed11-b83d-000d3a382d59"
}There are two records that need to be parsed ("PL-2" and "SS-1"). I tried just parsing the body by generating schema from the above example and the result is:
{
"type": "string"
}Which outputs both records as one string. How can I parse this further to get to the individual records and the properties for each record?
Categories:
I have the same question (0)
All responses (
Answers (
