DEV Community

Kinga
Kinga

Posted on • Updated on

Power Apps License calculator

It's not all that easy to "get a feeling" about the license cost for Power Apps.
Even if we consider that Per User is 4 times the price of Per App (per user/per app) and pay-as-you-go(per active user/per app) is half the price of Per User, I cannot easily foresee how the total license cost will develop, and what would be the best option under different circumstances.

My Power Apps License Calculator sample, published only yesterday, provides a visual representation of the cost:
license price
and the best license type for different usage scenarios:
license type

The sample consists of a reusable component, and a Canvas App. After importing the solution, you may embed the component in your own application, and configure it with your own Volume Licensing prices.

How to configure the component

The license cost per user, the currency and the initial percentage of the active users are all accessible via component's Custom properties. "Show info" toggle allows you to decide if you want to display the "legend"- the information about acronyms used when multiple license types result in the same price.

Custom properties

And anything more advanced?

In case you'd like to display different amount of apps and users, edit the component's onReset:

ClearCollect(
    colUsers,
    Table(
        {userCount: 1},
        {userCount: 10},
         //...
        {userCount: 5000}
    )
);
ClearCollect(
    colApps,
    Table(
        {appCount: 1},
        {appCount: 2},
        {appCount: 3},
        {appCount: 4},
        //...
        {appCount: 3000},
        {appCount: 5000}
    )
);
Enter fullscreen mode Exit fullscreen mode

The matrix source is automatically recalculated based on these two collections, and the license cost component parameters.
There are some additional columns in colLicenses, currently not used in the control. Perhaps you want to use them to display additional information when user hovers over the cell?
This is also the place where you can change the cell colors, in case the current theme is not your cup of tea.

ForAll(
    colApps ,
    ForAll(
        colUsers,
        Collect(
            colLicenses,
            //...
             {
                        Type: If(CountRows(matches)>1,Concat(matches,Left(type,1),"/"),First(matches).type) ,
                        Price: First(matches).price,
            //...
            }
Enter fullscreen mode Exit fullscreen mode

The resulting colLicenses collection is provided as a gallery source:

configuration

In order to display it in a matrix format, I'm setting wrap parameter of the gallery to the length of the users' collection.
In case you decide to change the colUsers, make sure that this setting is updated if necessary.

Such a simple solution to such a complicated problem. =)

Top comments (1)

Collapse
 
jaloplo profile image
Jaime López

Great article!!!

Power Platform licenses are a nightmare or, at least, they were some months ago. I'm a bit off right now but remember to download the Power Platform licensing paper and, sometimes, it made more noise than solved the problem.

Great app to make life easir for the decission makers.