Hi All,
we are working on a requirement to get a current login user license and sublicense app.
Request:
Before going through here I request you to open the below link first to understand more about what azure License GRAPH API will return.
So we have two collections/Tables
1: userLicenses: Graph API values returning into a collection called "User Licenses" having the fields skupartNumber, servicePlans
2: LicenseNames: collection (loaded a predefined table) for friendly names. so we have to lookup and get friendly names for License and Sublicense.
servicePlans column(table) has nested column values.
skupartNumber: returns the License name, but it's not the Friendly name.
servicePlans: Its a kind of table when open it has a few columns, about SubLicense details
servicePlanName: It will return the user's Sublicense list. again this is not a Friendly name.
as I mentioned above, we created a collection (loaded a predefined table) for friendly names as per the link above.
so we have to look up and get friendly names for License and Sub-License names.
See the friendly table fields as well.
ProductDisplayName: is the field to License(skupartNumber) Friendly name.
servicePlaneFiendlyName: This is the Sub-License(servicePlanName) friendly name
to the gallery, we can load/get License value from graph API and we can lookup friendly names as well, using the below formula.
Gallery Items property: UserLicenses
License label :
LookUp(LicenseNames, StringId=ThisItem.skuPartNumber).ProductDisplayName
the above formula returns the expected value because of ThisItem.skuPartNumber direct field so we can lookup from LicenseNames table.
The issue begins here for the sublicense, here we have to load all the sub-license plans for the assigned License.
if you see the above screenshots the "servicePlans" field is not a direct field value to get the list of sublicense.
yes, I understand the Sub-License plan list is not a single value to return as it is multiple sub-license values.
Any assistance please to get the list of
the workaround I find two solutions but those are returning only Sub-License values using the sub-License I am not able to look up the friendly names.
workaround -1
Left(Concat(LookUp(UserLicenses,skuPartNumber = ThisItem.skuPartNumber).servicePlans,servicePlanName & Char (10)),
Len(Concat(LookUp(UserLicenses,skuPartNumber = ThisItem.skuPartNumber).servicePlans,servicePlanName & Char (10)))-2)
In-Fact this is the expected output, but not able to get Friendly names for this Sublicense.
Workaround-2
LookUp(LicenseNames, ServicePlanName= First(LookUp(UserLicenses, skuPartNumber = ThisItem.skuPartNumber).servicePlans).servicePlanName).ServicePlansFriendlyName
in-fact this is not the expected output, because it returns only the first sub-license not the complete list of License Sub-License list. but I can get the friendly name for this sub-license.
here, is there any way to use the workaround-1 solution and use the lookup for friendly names to get all the sub-license lists to the respective License?
Please assist me. your reply would be really appreciated
