Hi there,
I've been working on this for a full day, searched multiple threads but unable to find my answer.
This is the JSON I'm trying to parse
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#teams('99999999-187a-45c6-9c0e-8feb0a1c7772')/schedule/schedulingGroups",
"@odata.count": 2,
"value": [{
"@odata.etag": "\"02001215-0400-0000-5eea34260000\"",
"id": "TAG_7b120abd-45e0-88bc-80582a4a6e71",
"createdDateTime": "2019-09-27T15:47:17.443Z",
"lastModifiedDateTime": "2020-06-17T15:17:58.775Z",
"displayName": "Bob Doe",
"isActive": true,
"userIds": [
"cb57cde3-061b-9936-94b9809e357d"
],
"lastModifiedBy": {
"application": null,
"device": null,
"conversation": null,
"user": {
"id": "78095471-4380-bafa-4ad2a9ffcd51",
"displayName": "William Doe"
}
}
},
{
"@odata.etag": "\"18007574-0000-5efce0020000\"",
"id": "TAG_180a2e56-4e98-8a07-444627b20b09",
"createdDateTime": "2019-09-27T15:47:53.038Z",
"lastModifiedDateTime": "2020-07-01T19:12:02.294Z",
"displayName": "John Doe",
"isActive": true,
"userIds": [
"15091fcf-cdcf-4527-6e95a205c8cd",
"32d4449f-48f2-4e15-f9343682dea6",
"9edadb37-a13f-49eb-d63ae734893a",
"15102410-7ae7-4fb1-35a829f3411b"
],
"lastModifiedBy": {
"application": null,
"device": null,
"conversation": null,
"user": {
"id": "2df0d32f-4e24-85d8-30eff34c32f8",
"displayName": "Jane Doe"
}
}
}
]
}
the userId is an array, it can contain 0 or more entries in it. And this is the Flow:
It does everything but puts the userId in a nested structure in csv.
But I need to the CSV to look like below, (everything expanded). but I cannot get it....Could you help? thanks!

Report
All responses (
Answers (