Power Platform Community Forum Thread Details

Hello,

since there is no action to get Team owners, I followed this workaround article(Getting Group owners using MS Graph API in Power Automate) to get it via Graph API call. However, I am unable to parse the JSON result. Please help and happy holidays 🙂

Result:

============

[

{

"message": "Invalid type. Expected String but got Null.",

"lineNumber": 0,

"linePosition": 0,

"path": "value[1].mobilePhone",

"schemaId": "#/properties/value/items/properties/mobilePhone",

"errorType": "type",

"childErrors": []

{

"message": "Invalid type. Expected String but got Null.",

"lineNumber": 0,

"linePosition": 0,

"path": "value[1].preferredLanguage",

"schemaId": "#/properties/value/items/properties/preferredLanguage",

"errorType": "type",

"childErrors": []

}

]

=====

Schema

=====

{

"type": "object",

"properties": {

"value": {

"type": "array",

"items": {

"type": "object",

"properties": {

"id": {

"type": "string"

"businessPhones": {

"type": "array",

"items": {

"type": "string"

}

"displayName": {

"type": "string"

"givenName": {

"type": "string"

"jobTitle": {},

"mail": {

"type": "string"

"mobilePhone": {

"type": "string"

"officeLocation": {},

"preferredLanguage": {

"type": "string"

"surname": {

"type": "string"

"userPrincipalName": {

"type": "string"

"@odata.type": {

"type": "string"

}

"required": [

"@odata.type",

"id",

"businessPhones",

"displayName",

"givenName",

"jobTitle",

"mail",

"mobilePhone",

"officeLocation",

"preferredLanguage",

"surname",

"userPrincipalName"

]

}

"@odata.context": {

"type": "string"

}

Categories:

Building flows

I ended up figuring this out. Based on the null errors in message I set the type to: "type": ["string", "null"]

Afterwards, the Parse JSON worked.

{
"type": "object",
"properties": {
"@@odata.context": {
"type": "string"
},
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"id": {
"type": "string"
},
"businessPhones": {
"type": "array"
},
"displayName": {
"type": "string"
},
"givenName": {
"type": "string"
},
"jobTitle": {
"type": ["string", "null"]
},
"mail": {
"type": "string"
},
"mobilePhone": {
"type": ["string", "null"]
},
"officeLocation": {
"type": "string"
},
"preferredLanguage": {
"type": ["string", "null"]
},
"surname": {
"type": "string"
},
"userPrincipalName": {
"type": "string"
}
},
"required": [
"@@odata.type",
"id",
"businessPhones",
"displayName",
"givenName",
"jobTitle",
"mail",
"mobilePhone",
"officeLocation",
"preferredLanguage",
"surname",
"userPrincipalName"
]
}
}
}
}