Not Monitored
Tag not monitored by Microsoft.
37,802 questions
From what I've seen online, manual export and Microsoft Graph are the two ways of getting that data.
how to get office365 activationUserDetail by power app in excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 75%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFD%3C/text%3E%3C/svg%3E)
Frédérique BAROUX
1
Reputation point
Hi, I need to build a costing Dashboard for the It department in Excel. I'm looking for "ActivationUserDetail (with upn, displayname, producttype, lastactivation)" (licence per user) table from office 365 I'd like to get dynamic data from office 365 administration center Today I get this data by exporting reports from "office 365 administration center" as an csv file but it's not dynamic. I've try by powerbi and Microsoft usage analytics, but I Don't find the needed information. I need some help. Thanks
{count} votes
-
Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor2021-02-22T07:35:15.503+00:00 Hi,
I suggest you post this issue to Power apps forum:
https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Sign in to comment
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT 36,411 Reputation points Microsoft Employee2021-02-20T00:21:53.433+00:00