Is there a Power Automate function to show 0365 Licenses assigned to users?

[helpmeplease123]

We have an Excel sheet we use to show which type of 0365 License is assigned to each user in our organization (Business Basic, Business Premium, etc.). On the sheet, next to the name of the license is the price that we pay for the specific license the user is assigned. We are needing to automate the sheet, so I'm trying to see if there's a way to automate the sheet every time we assign/un-assign a license for each user in O365 Admin Center.

I can't seem to find a trigger or an action in Power Automate when typing in "license" but I know for a fact there's a way to incorporate it. I've tried searching online with no success so if anyone can guide me with the correct steps, I would really appreciate it. Or at least a good place to start! Thanks everyone.

[Expiscornovus · Accepted solution]

Hi @helpmeplease123 ,

I would have a look at the change tracking (delta) function for the user resource in the Graph API.

https://docs.microsoft.com/en-us/graph/api/user-delta?view=graph-rest-1.0&tabs=http

You can use that to post an initial tracking request. With a $select query parameter you can specify that you want to specifically monitor changes to the assignedLicenses field.

https://graph.microsoft.com/v1.0/users/delta?$select=id,userPrincipalName,assignedLicenses 

That request will generate a response with an @odata.nextLink. You can use that in a recurrent flow (once a day?) to retrieve the changes and write the changes to for example in an Excel sheet.

Hope this helps to get you started?

[helpmeplease123]

Thanks for the help! I will try it out soon.