cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
helpmeplease123
New Member

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Dual Super User
Dual Super User

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?

 

 

View solution in original post

2 REPLIES 2
Expiscornovus
Dual Super User
Dual Super User

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?

 

 

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (4,377)