Power Platform Community Forum Thread Details

Hi Team,

Before reading this

I request you to open the below URL to understand more about what actually i am trying to get.

https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/licensing-service-plan-reference

Product name: Used in management portals
String ID: Used by PowerShell v1.0 cmdlets when performing operations on licenses or by the skuPartNumber property of the subscribedSku Microsoft Graph API
GUID: GUID used by the skuId property of the subscribedSku Microsoft Graph API
Service plans included: A list of service plans in the product that corresponds to the string ID and GUID
Service plans included (friendly names): A list of service plans (friendly names)

We have a request to get the Azure Ad users, user licenses, and sublicenses in the Power app.

So we created a GRAPH API and it's working fine.

Now question is

based on the above bullet points

we can able to get skuPartNumber using the graph API, actually, skuPartNumber is not understandable to us,

we need to get the Product name from that Microsoft table(Link which I gave above). so we have created another collection to Lookup the product name to the respective skuPartNumber.

So the collection has the relevant ProductName, to all skuPartNumber.

ProductName is more understandable to us like in the Azure portal example please check the below screenshot from azure.

likewise, we also have sublicense details as well in the collection.

This means in the collection has table values with the license (product name) and sublicense details.

now we need to get into the gallery in the below format

License	Sublicense

The license is in a Lable and the Sublicense is in another label.

to the gallery items property, I set the collection name which we created(which is holding from the Graph API the product name, sublicense friendly name )

the below screenshot shows Graph API that we are getting user license details.

Here is the collection result with columns.

skuPartNumber: is the license name

ServicePlans : is for SubLicense purposes.

Collection to get friendly names

We can able to get ProductDiplayName into the gallery because from Graph API it's a direct field (skuPartNumber)

In the same gallery another label, we want to get the Sub License list as well as the respective license.

you can see the Gallery License label is getting the friendly name from the collection.

same way which is not happening to Sub License. please check the error below.

yes because of the skuPartNumber direct field in Collection so it's working,

whereas serviceplans is a column in a collection, but ServicePlans itself is a table, having the ServicePlanName field from a collection. please check the below screen.

------------------------------------------------------------------

Does any help please on how to get the table filed(ServicePlanName ) value from the collection?

If you make a sample really appreciate it.