Power Platform Community Forum Thread Details

Dear all

I am trying to extract values from a complex JSON array. I need the "id" and "created-at", as well as each "answer" property.

The column header for each "answer" should be taken from the property called "widget-label"
The number of objects in "easy-form-widget-responses" object varies, so [0] won't always be the same

Desired outcome:

id	created-at	supplier name	Street Address	Street Address 2	city	Postal Code	State or Provence
368732	313221	supplier-value	street-value	street2-value	city-value	postal-value	state-value

Sample:

{
 "body": [
 {
 "id": 368732,
 "created-at": "2023-04-14T11:16:19+02:00",
 "updated-at": "2023-04-18T20:09:40+02:00",
 "easy-form-id": 3890,
 "name": "2. Request New Supplier",
 "status": "applied",
 "submitted-at": "2023-04-17T09:44:56+02:00",
 "subject": {
 "id": 42063,
 "supplier-id": 319966,
 "display-name": null,
 "supplier-number": "4134054"
 },
 "easy-form-widget-responses": [
 {
 "field-name": "name",
 "widget-label": "Supplier Name",
 "answer": "supplier-value"
 },
 {
 "field-name": "street_address",
 "widget-label": "Street Address",
 "answer": "street-value"
 },
 {
 "field-name": "street_address_2",
 "widget-label": "Street Address 2",
 "answer": "street2-value"
 },
 {
 "field-name": "city",
 "widget-label": "City",
 "answer": "city-value"
 },
 {
 "field-name": "postal_code",
 "widget-label": "Postal Code",
 "answer": "postal-value"
 },
 {
 "field-name": "state_or_provence",
 "widget-label": "State or Provence",
 "answer": "state-value"
 }
 }
 ]
}

Categories:

General topics