Skip to main content

Notifications

Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Referencing an element...
Power Automate - Building Flows
Answered

Referencing an element of a JSON object

(0) ShareShare
ReportReport
Posted on by Sbsyx 113

I have a data structure like this (this is a fragment). How can I reference "skuId"?
item()?['assignedLicenses'][1] and item()?['assignedLicenses']['skuId'] not working throws an error that it cannot be referenced. Is there any other way to appeal?

[
{
"id": "38479404-dfeb-4c1b-918e-5115243ae3da",
"mail": "admin@CRM948641.onmicrosoft.com",
"assignedLicenses": [
{
"disabledPlans": [],
"skuId": "f30db892-07e9-47e9-837c-80727f46fd3d"
},
{
"disabledPlans": [],
"skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
},
{
"disabledPlans": [
"f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
"afc06cb0-b4f4-4473-8286-d644f70d8faf",
"e95bec33-7c88-4a70-8e19-b10bd9d0c014",
"199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
"3efbd4ed-8958-4824-8389-1321f8730af8",
"dcf9d2f4-772e-4434-b757-77a453cfbc02"
],
"skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
},
{
"disabledPlans": [],
"skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b"
},
{
"disabledPlans": [
"70d33638-9c74-4d01-bfd3-562de28bd4ba"
],
"skuId": "69442a54-c321-449a-bdf5-7a2073723593"
},
{
"disabledPlans": [],
"skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
}
]
},

 

  • Verified answer
    Chriddle Profile Picture
    Chriddle 7,793 Super User 2025 Season 1 on at
    Re: Referencing an element of a JSON object

    Change the TmpResut's Map to

    if(
	contains(body('MailIndex'), item()),
	null,
	json(
		concat(
			'{"mail":"',
			json(
				xpath(
					xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
					'//Item/*/skuId | //mail'
				)[max(take(body('MailIndex'), item()))]
			)?['mail'],
			'", "displayName":"',
			json(
				xpath(
					xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
					'//Item/*/skuId | //displayName'
				)[max(take(body('MailIndex'), item()))]
			)?['displayName'],
			'", "skuId":"',
			json(
				xpath(
					xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
					'//Item/*/skuId | //mail'
				)[item()]
			)?['skuId'],
			'"}'
		)
	)
)

     

  • Sbsyx Profile Picture
    Sbsyx 113 on at
    Re: Referencing an element of a JSON object

    Ok. Thanks. And... When would I like to add an additional field displayName?

    displayname.zip
  • Verified answer
    Chriddle Profile Picture
    Chriddle 7,793 Super User 2025 Season 1 on at
    Re: Referencing an element of a JSON object

    OK, according to your JSON file, my assumption was wrong

    So I need a few more actions:

    Chriddle_0-1718485907783.png

    Json (Compose)

    Your JSON

    Spoiler (Highlight to read)
    [
 {
 "id": "38479404-dfeb-4c1b-918e-5115243ae3da",
 "mail": "admin@CRM948641.onmicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [],
 "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d"
 },
 {
 "disabledPlans": [],
 "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
 },
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [],
 "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "disabledPlans": [],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 }
 ]
 },
 {
 "id": "cea55e0e-f5b8-4a66-83ac-5c1a3d5054f5",
 "mail": "alans@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [],
 "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
 }
 ]
 },
 {
 "id": "32c83a92-1faf-494e-9292-76115b4dc015",
 "mail": "aliciat@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "bd21c56e-f191-48fe-a17f-dc4cebb048d4",
 "mail": "allieb@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "663681ab-1ad0-4fc2-8bec-9362b8bf82bf",
 "mail": "amya@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "407fa22e-b99d-4ef1-ad41-7d6c72dd27d1",
 "mail": "annew@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "957c8796-ffd5-462d-94bb-a9c2224a44f6",
 "mail": "carlosg@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "7d933f3e-8070-4742-a7f9-3846951ea017",
 "mail": "christag@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "55e4272f-17de-4f39-9fac-2b5948ce96a2",
 "mail": "danj@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "eadc69de-0456-4d45-8d4a-20f95f31a89f",
 "mail": "davids@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "2977b421-bca5-4111-912c-2f8388b9a274",
 "mail": "dianep@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "cfd3e515-d383-4da9-9bdb-d379ce7bf09f",
 "mail": "ericg@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "cf2d4612-0718-432f-9e00-713b4aae1c65",
 "mail": "gregw@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "6aa499a2-8d00-4ffa-bc63-b78fdf42c7a9",
 "mail": "jamier@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "5732492a-98fa-4b78-a835-f6c891e52133",
 "mail": "jeffh@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "1f4a0764-4504-4135-ab2c-f1ceaa3ec7b0",
 "mail": "juliani@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "d69b6fb2-56ab-4022-a10b-c140bedcc7df",
 "mail": "karenb@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "f526af70-d433-4f9d-a35e-6894af01b275",
 "mail": "kellyk@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "7476a205-fadd-403c-98d9-d99ab6d3b5f4",
 "mail": "mollyc@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "fa222745-d2ba-4411-885b-fe3a545995b1",
 "mail": null,
 "assignedLicenses": []
 },
 {
 "id": "dd632a8c-10cf-484c-a9c1-7743062beee9",
 "mail": "reneel@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "bac2c10e-7286-4bd2-856b-721927f4e679",
 "mail": "sanjays@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "1b2a7d02-18f5-4e3a-a490-5101fdd06fee",
 "mail": "spencerl@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "7e77ff19-1471-4358-87fb-d1f2eba467e0",
 "mail": "svenm@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "27b4d054-77f3-47ec-af10-e4c1334d9c10",
 "mail": "veronicaq@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 },
 {
 "id": "21cd53a9-aff7-49d7-808e-d2485bee1345",
 "mail": "williamc@CRM948641.OnMicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "disabledPlans": [],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
 ]
 }
]

     

    [ { "id": "38479404-dfeb-4c1b-918e-5115243ae3da", "mail": "admin@CRM948641.onmicrosoft.com", "assignedLicenses": [ { "disabledPlans": [], "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d" }, { "disabledPlans": [], "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80" }, { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [], "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "disabledPlans": [], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" } ] }, { "id": "cea55e0e-f5b8-4a66-83ac-5c1a3d5054f5", "mail": "alans@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [], "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80" } ] }, { "id": "32c83a92-1faf-494e-9292-76115b4dc015", "mail": "aliciat@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "bd21c56e-f191-48fe-a17f-dc4cebb048d4", "mail": "allieb@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "663681ab-1ad0-4fc2-8bec-9362b8bf82bf", "mail": "amya@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "407fa22e-b99d-4ef1-ad41-7d6c72dd27d1", "mail": "annew@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "957c8796-ffd5-462d-94bb-a9c2224a44f6", "mail": "carlosg@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "7d933f3e-8070-4742-a7f9-3846951ea017", "mail": "christag@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "55e4272f-17de-4f39-9fac-2b5948ce96a2", "mail": "danj@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "eadc69de-0456-4d45-8d4a-20f95f31a89f", "mail": "davids@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "2977b421-bca5-4111-912c-2f8388b9a274", "mail": "dianep@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "cfd3e515-d383-4da9-9bdb-d379ce7bf09f", "mail": "ericg@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "cf2d4612-0718-432f-9e00-713b4aae1c65", "mail": "gregw@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "6aa499a2-8d00-4ffa-bc63-b78fdf42c7a9", "mail": "jamier@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "5732492a-98fa-4b78-a835-f6c891e52133", "mail": "jeffh@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "1f4a0764-4504-4135-ab2c-f1ceaa3ec7b0", "mail": "juliani@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "d69b6fb2-56ab-4022-a10b-c140bedcc7df", "mail": "karenb@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "f526af70-d433-4f9d-a35e-6894af01b275", "mail": "kellyk@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "7476a205-fadd-403c-98d9-d99ab6d3b5f4", "mail": "mollyc@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "fa222745-d2ba-4411-885b-fe3a545995b1", "mail": null, "assignedLicenses": [] }, { "id": "dd632a8c-10cf-484c-a9c1-7743062beee9", "mail": "reneel@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "bac2c10e-7286-4bd2-856b-721927f4e679", "mail": "sanjays@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "1b2a7d02-18f5-4e3a-a490-5101fdd06fee", "mail": "spencerl@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "7e77ff19-1471-4358-87fb-d1f2eba467e0", "mail": "svenm@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "27b4d054-77f3-47ec-af10-e4c1334d9c10", "mail": "veronicaq@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] }, { "id": "21cd53a9-aff7-49d7-808e-d2485bee1345", "mail": "williamc@CRM948641.OnMicrosoft.com", "assignedLicenses": [ { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "disabledPlans": [], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ] } ]  

     

    MailIndex (Select)

    Get the indexes of mails in XML node array

    From

    range(
	0,
	length(
		xpath(
			xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
			'//Item/*/skuId | //mail'
		)
	)
)

    Map

    if(
	equals(
		json(
			xpath(
				xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
				'//Item/*/skuId | //mail'
			)[item()]
		)?['mail'],
		null
	),
	0,
	item()
)

     

    TmpResult (Select)

    If the current XML node is a mail node, null is returned.

    If the current XML node is a skuId node, an object with skid and email (computed from MailIndex) is returned.

    From

    range(
	0,
	length(
		xpath(
			xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
			'//Item/*/skuId | //mail'
		)
	)
)

    Map

    if(
	contains(body('MailIndex'), item()),
	null,
	json(
		concat(
			'{"mail":"',
			json(
				xpath(
					xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
					'//Item/*/skuId | //mail'
				)[max(take(body('MailIndex'), item()))]
			)?['mail'],
			'", "skuId":"',
			json(
				xpath(
					xml(json(concat('{"Root":{"Item":', outputs('Json'), '}}'))),
					'//Item/*/skuId | //mail'
				)[item()]
			)?['skuId'],
			'"}'
		)
	)
)

     

    Result (Filter array)

    Removed null values

    From

    body('TmpResult')

    Filter

    item()

     is not equal to

    null

    Chriddle_1-1718486551689.png

    Spoiler (Highlight to read)
    [
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "alans@CRM948641.OnMicrosoft.com",
 "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
 },
 {
 "mail": "aliciat@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "aliciat@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "aliciat@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "allieb@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "allieb@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "allieb@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "amya@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "amya@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "amya@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "annew@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "annew@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "annew@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "carlosg@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "carlosg@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "carlosg@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "christag@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "christag@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "christag@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "danj@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "danj@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "danj@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "davids@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "davids@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "davids@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "dianep@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "dianep@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "dianep@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "ericg@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "ericg@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "ericg@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "gregw@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "gregw@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "gregw@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "jamier@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "jamier@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "jamier@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "jeffh@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "jeffh@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "jeffh@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "juliani@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "juliani@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "juliani@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "karenb@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "karenb@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "karenb@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "kellyk@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "kellyk@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "kellyk@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "mollyc@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "mollyc@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "mollyc@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "mollyc@CRM948641.OnMicrosoft.com",
 "skuId": ""
 },
 {
 "mail": "reneel@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "reneel@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "reneel@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "sanjays@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "sanjays@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "sanjays@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "spencerl@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "spencerl@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "spencerl@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "svenm@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "svenm@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "svenm@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "veronicaq@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "veronicaq@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "veronicaq@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "williamc@CRM948641.OnMicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "williamc@CRM948641.OnMicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 },
 {
 "mail": "williamc@CRM948641.OnMicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 }
]
    [ { "mail": "admin@CRM948641.onmicrosoft.com", "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d" }, { "mail": "admin@CRM948641.onmicrosoft.com", "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80" }, { "mail": "admin@CRM948641.onmicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "admin@CRM948641.onmicrosoft.com", "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b" }, { "mail": "admin@CRM948641.onmicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "admin@CRM948641.onmicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "alans@CRM948641.OnMicrosoft.com", "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80" }, { "mail": "aliciat@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "aliciat@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "aliciat@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "allieb@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "allieb@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "allieb@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "amya@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "amya@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "amya@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "annew@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "annew@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "annew@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "carlosg@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "carlosg@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "carlosg@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "christag@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "christag@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "christag@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "danj@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "danj@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "danj@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "davids@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "davids@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "davids@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "dianep@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "dianep@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "dianep@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "ericg@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "ericg@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "ericg@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "gregw@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "gregw@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "gregw@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "jamier@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "jamier@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "jamier@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "jeffh@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "jeffh@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "jeffh@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "juliani@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "juliani@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "juliani@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "karenb@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "karenb@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "karenb@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "kellyk@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "kellyk@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "kellyk@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "mollyc@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "mollyc@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "mollyc@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "mollyc@CRM948641.OnMicrosoft.com", "skuId": "" }, { "mail": "reneel@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "reneel@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "reneel@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "sanjays@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "sanjays@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "sanjays@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "spencerl@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "spencerl@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "spencerl@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "svenm@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "svenm@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "svenm@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "veronicaq@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "veronicaq@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "veronicaq@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "mail": "williamc@CRM948641.OnMicrosoft.com", "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "mail": "williamc@CRM948641.OnMicrosoft.com", "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" }, { "mail": "williamc@CRM948641.OnMicrosoft.com", "skuId": "69442a54-c321-449a-bdf5-7a2073723593" } ]

     

     

  • Chriddle Profile Picture
    Chriddle 7,793 Super User 2025 Season 1 on at
    Re: Referencing an element of a JSON object

    Assuming that each skuId is associated with exactly one email, you can do the following:

    Chriddle_0-1718456968808.png

    Compose

    Spoiler (Highlight to read)
    [
 {
 "id": "38479404-dfeb-4c1b-918e-5115243ae3da",
 "mail": "admin@CRM948641.onmicrosoft.com",
 "assignedLicenses": [
 {
 "disabledPlans": [],
 "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d"
 },
 {
 "disabledPlans": [],
 "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
 },
 {
 "disabledPlans": [
 "f0ff6ac6-297d-49cd-be34-6dfef97f0c28",
 "afc06cb0-b4f4-4473-8286-d644f70d8faf",
 "e95bec33-7c88-4a70-8e19-b10bd9d0c014",
 "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2",
 "3efbd4ed-8958-4824-8389-1321f8730af8",
 "dcf9d2f4-772e-4434-b757-77a453cfbc02"
 ],
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "disabledPlans": [],
 "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b"
 },
 {
 "disabledPlans": [
 "70d33638-9c74-4d01-bfd3-562de28bd4ba"
 ],
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "disabledPlans": [],
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 }
 ]
 }
]
    [ { "id": "38479404-dfeb-4c1b-918e-5115243ae3da", "mail": "admin@CRM948641.onmicrosoft.com", "assignedLicenses": [ { "disabledPlans": [], "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d" }, { "disabledPlans": [], "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80" }, { "disabledPlans": [ "f0ff6ac6-297d-49cd-be34-6dfef97f0c28", "afc06cb0-b4f4-4473-8286-d644f70d8faf", "e95bec33-7c88-4a70-8e19-b10bd9d0c014", "199a5c09-e0ca-4e37-8f7c-b05d533e1ea2", "3efbd4ed-8958-4824-8389-1321f8730af8", "dcf9d2f4-772e-4434-b757-77a453cfbc02" ], "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01" }, { "disabledPlans": [], "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b" }, { "disabledPlans": [ "70d33638-9c74-4d01-bfd3-562de28bd4ba" ], "skuId": "69442a54-c321-449a-bdf5-7a2073723593" }, { "disabledPlans": [], "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26" } ] } ]

    Select

    From

    xpath(
	xml(json(concat('{"Root":{"Item":', outputs('Compose'), '}}'))),
	'//skuId/text()'
)

    Map mail

    xpath(
	xml(json(concat('{"Root":{"Item":', outputs('Compose'), '}}'))),
	concat('string(//Item[assignedLicenses/skuId = "', item(), '"]/mail/text())')
)

    Map skuId

    item()

     

    Result

    [
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "f30db892-07e9-47e9-837c-80727f46fd3d"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "5b631642-bd26-49fe-bd20-1daaa972ef80"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "7e31c0d9-9551-471d-836f-32ee72be4a01"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "84a661c4-e949-4bd2-a560-ed7766fcaf2b"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "69442a54-c321-449a-bdf5-7a2073723593"
 },
 {
 "mail": "admin@CRM948641.onmicrosoft.com",
 "skuId": "e23e2b65-8fc9-4036-a902-a17473ff6d26"
 }
]

     

  • claudiovc Profile Picture
    claudiovc 94 on at
    Re: Referencing an element of a JSON object

    Hi @Sbsyx 

     

    Please try these

     

    entire flow

    FlujoCompleto.PNGFlujoCompleto2.PNG

     

    Flow detail:

    The "Redactar" (compose) action is your json

    detalleFlujo1.PNG

    length(item()['assignedLicenses'])

     

    detalleFlujo2.PNG

     

    detalleFlujo3.PNG

     

    detalleFlujo4.PNG

    items('Aplicar_a_cada_uno')?['assignedLicenses']

     

    detalleFlujo5.PNG

    items('Aplicar_a_cada_uno_2')?['skuId']
    items('Aplicar_a_cada_uno')?['mail']
     
    detalleFlujo6.PNG
     
    I hope it helps you
     

  • Sbsyx Profile Picture
    Sbsyx 113 on at
    Re: Referencing an element of a JSON object

    Ok, but it only selects for one user and I have many of them.

    I will upload the entire JSON.

    JSON.zip
  • v-yetonggu-msft Profile Picture
    v-yetonggu-msft on at
    Re: Referencing an element of a JSON object

    Hi @Sbsyx ,

    Okay, I see what you mean.

    Please check this test:

    vyetonggumsft_0-1718356964562.png

    Flow Configuration:

    vyetonggumsft_1-1718357165575.png

    outputs('Compose')?[0]?['assignedLicenses']

    Best Regards,

    Sunshine Gu

  • Sbsyx Profile Picture
    Sbsyx 113 on at
    Re: Referencing an element of a JSON object

    Ok, this is data downloaded from the API in JSON, where there is a SKU ID for each email, some have only one product pinned, others have several, I would like to present it in the form of a table.

    Sbsyx_0-1718355556817.png

     

     

  • v-yetonggu-msft Profile Picture
    v-yetonggu-msft on at
    Re: Referencing an element of a JSON object

    Hi @Sbsyx ,

    I don't understand what you mean, could you please describe it in more detail?

    Thank you.

    Best Regards,

    Sunshine Gu

  • Sbsyx Profile Picture
    Sbsyx 113 on at
    Re: Referencing an element of a JSON object

    Thank you, but that's not it. I need to extract its sku id from json in "select" for each email. It is:

    {

    "Sku ID": " ",

    "Mail":"@item()?['mail']"

    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans