Get environment capacity using Power Platform for Admins (or other method)

(0) Share

Report

Posted on by MattTaylor

123

Hi folks,

I've been trying to find a way to get the capacities for my environments (apart from manually looking at the analytics on the Power Platform Admin Centre). It looks like this might do it: https://docs.microsoft.com/en-us/connectors/powerplatformforadmins/#get-environment-as-admin, but I'm not having any luck with it - the capacity part of the properties doesn't seem to have anything in it.

Has anyone managed to do this?

Thanks in advance

Categories:

Governance & administering

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (1)

Report

Hello @MattTaylor,

Just tried it out, and I'm getting the same result in both Power Apps and Power Automate: the capacity part of the properties is omitted.

Was this reply helpful? Yes No
MattTaylor 123 on at

Like (0)

Report

Thanks for responding @joe_hannes_col, it's a shame - I really need a way of setting up alerts for storage and keeping a history so I can analyse the increases over time, without just going to the Admin Centre and doing it with a CSV download.

Was this reply helpful? Yes No
joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (1)

Report

I agree. I fiddled with some PowerShell commands, but I didn't find any that would return the capacity. There probably is a way to query the capacity from the Business Applications Platform API, but I didn't find a request. If I find something I'll post back.
Or maybe the functionality will come back - the property seems to be there, it just appears empty in Power Apps.

Was this reply helpful? Yes No
Verified answer

MattTaylor 123 on at

Like (2)

Report
For anyone that's interested, I found the solution to get that capacity data.

1. Using the 'Power Platform for Admins' connector, look for the 'List Environments as Admin' Action
2. Click Show Advanced Options on the action
3. In the Expand Properties box enter the following:

properties.capacity,properties.addons
It looks like this:

4. You can then add steps afterwards to use the output. You'll need to parse the JSON of the capacity property in order to pull out individual details (it looks like this):

[ { "capacityType": "Database", "actualConsumption": 2232.062, "ratedConsumption": 2232.062, "capacityUnit": "MB", "updatedOn": "2021-09-16T01:27:45Z" }, { "capacityType": "File", "actualConsumption": 3311.855, "ratedConsumption": 3311.855, "capacityUnit": "MB", "updatedOn": "2021-09-16T01:27:45Z" }, { "capacityType": "Log", "actualConsumption": 0.2265625, "ratedConsumption": 0.2265625, "capacityUnit": "MB", "updatedOn": "2021-09-16T01:27:45Z" } ]

I assume you can do the same with the 'Get Environment as Admin' Action.

For reference, this tutorial helped me work out where I needed to make the changes: https://docs.microsoft.com/en-us/power-platform/admin/programmability-tutorial-create-daily-capacity-report

Was this reply helpful? Yes No
Stephen Pryke 36 on at

Like (1)

Report

Excellent. Just what I was looking for 🙂

Was this reply helpful? Yes No
niclasdahl 19 on at

Like (1)

Report

Hey @MattTaylor!

Just curious, doesn't that just give the amount of how much data that is currently being used (consumed)? Wouldn't you then need to run that against the actual storage capacity limit to be able to see how much data your are using of what is available, so that you can set alerts to when it goes above a certain %?

Was this reply helpful? Yes No
BenGillard 120 on at

Like (0)

Report

Agree. The above is great but without capacity it doesn't help with management. Does anyone know you to get tenant capacity using flow?

Was this reply helpful? Yes No
MattTaylor 123 on at

Like (0)

Report

Hi @niclasdahl,

Yep, absolutely! This is the issue I've got at the moment as well. I've asked a few contacts in Microsoft about getting access to that but as of yet have heard nothing back. Will update here once/if I do!

Was this reply helpful? Yes No