web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : h3M5o13le0EI50FHFpkrPn
Power Apps - Power Apps Governance and Administ...
Answered

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

Like (0) ShareShare
ReportReport
Posted on 29 Jun 2021 14:21:28 by 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:
I have the same question (0)
  • MattTaylor Profile Picture
    123 on 13 Apr 2023 at 11:19:11
    Re: Get environment capacity using Power Platform for Admins (or other method)

    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! 

  • BenGillard Profile Picture
    120 on 21 Mar 2023 at 14:24:41
    Re: Get environment capacity using Power Platform for Admins (or other method)

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

  • niclasdahl Profile Picture
    19 on 17 Mar 2023 at 15:25:35
    Re: Get environment capacity using Power Platform for Admins (or other method)

    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 %?

  • Stephen Pryke Profile Picture
    36 on 25 Mar 2022 at 09:21:45
    Re: Get environment capacity using Power Platform for Admins (or other method)

    Excellent. Just what I was looking for 🙂

  • Verified answer
    MattTaylor Profile Picture
    123 on 16 Sep 2021 at 02:30:16
    Re: Get environment capacity using Power Platform for Admins (or other method)

    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:
    scn_ppa1.png

     

    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 

  • joe_hannes_col Profile Picture
    1,843 Super User 2024 Season 1 on 29 Jun 2021 at 15:05:17
    Re: Get environment capacity using Power Platform for Admins (or other method)

    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.

  • MattTaylor Profile Picture
    123 on 29 Jun 2021 at 15:02:00
    Re: Get environment capacity using Power Platform for Admins (or other method)

    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. 

  • Verified answer
    joe_hannes_col Profile Picture
    1,843 Super User 2024 Season 1 on 29 Jun 2021 at 14:58:54
    Re: Get environment capacity using Power Platform for Admins (or other method)

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 892 Most Valuable Professional

#2
Power Apps 1919 Profile Picture

Power Apps 1919 356

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 310 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics