Hi PA People,
I've been working on a flow from a test list which works fine, and now moving it into production, and I'm getting the error of "Invalid Type, Expected Object but got Array".
I always seem to trip over Parse JSON syntax. The flow runs daily and goes a Get Items action with an oData filter of anniversary date = today.
Next I select the Department Administrator.
I then initialize my array variable with a union statement.
union(body('Select_Department_Administrator'), body('Select_Department_Administrator'))
Next my Parse JSON statement uses the array variable as the content.
The schema is below:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Claims": {
"type": ["string", "null"]
},
"DisplayName": {
"type": ["string", "null"]
},
"Email": {
"type": ["string", "null"]
},
"Picture": {
"type": ["string", "null"]
},
"Department": {
"type": ["string", "null"]
},
"JobTitle": {
"type": ["string", "null"]
},
"@odata.type": {
"type": ["string", "null"]
}
},
"required": [
"@odata.type",
"Claims",
"DisplayName",
"Email",
"Picture",
"Department",
"JobTitle"
]
}
}
