Power Platform Community Forum Thread Details

I have this json file with multiple entries:

[
{
"id":"0ed5b3a1-4fe5-4cac-9",
"identificationNumber":"8734-70156",
"activeState":"active",
"status":"ActiveWithContribution",
"firstName":"Stewart",
"lastName":"Collins",
"association":{
"id":"f0fd7a7e-70d2-419",
"number":2300,
"name":"MAURICE",
"type":"normal"
}
},
{
"id":"3ed5b3a1-4fe5-4cac-8",
"identificationNumber":"9734-70157",
"activeState":"active",
"status":"ActiveWithContribution",
"firstName":"Bernie",
"lastName":"Nichols",
"association":{
"id":"d0fd7a7e-70d2-418",
"number":2306,
"name":"Pierre",
"type":"normal"
}
}
]

Schema looks like this :

{
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"identificationNumber": {
"type": "string"
},
"activeState": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
},
"status": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
},
"firstName": {
"type": "string"
},
"lastName": {
"type": "string"
},
"association": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"number": {
"type": "integer"
},
"name": {
"type": "string"
},
"type": {
"type": "string"
}
}
}
}

Keep in mind That have multiple (3) "association" like that are define as "type":"object" with same "id","number","name"

Problem is I need to be able to use "association" in an 'Apply to Each' function and I can't find a way to do that. Does not appear in Dynamic Content. Yes I can use individual value "id","number","name" from each of the 3 "objects" but this is hard to define as they have the same name and also this is not what I need. What I need is 'association' and other 'objets' as a string in a 'Apply to Each' loop.

Any Idea how I could achieve that?

Categories:

Building flows