Power Platform Community Forum Thread Details

Parsing an array of arrays....

Hi,

I need a bit of help please.

I have a flow whereby I need to parse a JSON in order to get the values within the "values" element of the JSON.

The values part is an array of arrays, so I am then trying to loop through each object in here to update Dataverse.

However, before I get this far, I am setting a variable to ensure that I am getting the correct list of objects for values. Every time I run this, however, the output is empty/null. But there is data in there. What could I be doing wrong?

What would the correct output of the Parse JSON command be in order for me to see the items within 'values'?

{
 "type": "object",
 "properties": {
 "statusCode": {
 "type": "integer"
 },
 "headers": {
 "type": "object",
 "properties": {
 "Transfer-Encoding": {
 "type": "string"
 },
 "Vary": {
 "type": "string"
 },
 "Strict-Transport-Security": {
 "type": "string"
 },
 "request-id": {
 "type": "string"
 },
 "client-request-id": {
 "type": "string"
 },
 "x-ms-ags-diagnostic": {
 "type": "string"
 },
 "OData-Version": {
 "type": "string"
 },
 "Timing-Allow-Origin": {
 "type": "string"
 },
 "x-ms-apihub-cached-response": {
 "type": "string"
 },
 "x-ms-apihub-obo": {
 "type": "string"
 },
 "Cache-Control": {
 "type": "string"
 },
 "Date": {
 "type": "string"
 },
 "Content-Type": {
 "type": "string"
 },
 "Content-Length": {
 "type": "string"
 }
 }
 },
 "body": {
 "type": "object",
 "properties": {
 "@@odata.context": {
 "type": "string"
 },
 "@@odata.type": {
 "type": "string"
 },
 "@@odata.id": {
 "type": "string"
 },
 "address": {
 "type": "string"
 },
 "addressLocal": {
 "type": "string"
 },
 "columnCount": {
 "type": "integer"
 },
 "cellCount": {
 "type": "integer"
 },
 "columnHidden": {
 "type": "boolean"
 },
 "rowHidden": {
 "type": "boolean"
 },
 "numberFormat": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 },
 "columnIndex": {
 "type": "integer"
 },
 "text": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 },
 "formulas": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 },
 "formulasLocal": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 },
 "formulasR1C1": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 },
 "hidden": {
 "type": "boolean"
 },
 "rowCount": {
 "type": "integer"
 },
 "rowIndex": {
 "type": "integer"
 },
 "valueTypes": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 },
 "values": {
 "type": "array",
 "items": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 }
 }
 }
 }
}

Thanks

Quick Links

Leaderboard > Power Automate