Showing results for 
Search instead for 
Did you mean: 
Continued Contributor
Continued Contributor

Help understanding powerapps license changes October 2019

Can anybody shed any light on the new PowerApps licensing plans? I'm having trouble wrapping my head around what is going on.

I specifically went out last year and purchased a number of Office 365 premium licenses as well as the F1 plan for employees in the field, so that we could use powerapps.


I am using a combination of an Azure SQL database(pay as you go license) and SharePoint (under the 365 licensing) to function as the back end for my apps.

Am I now no longer going to be able to develop and distribute Apps to my employees under these licenses? Am I now being asked by microsoft to go out and buy more licenses specific to PowerApps?


Hope this is the right place to ask the 365 messages aren't very clear.

100 REPLIES 100

This is absolutely insane.  If you are looking to kill the platform this is the perfect way to do it.  $40/user/month is just ridiculous to use a connector that should be standard.  Fortunately, I have only 1 application using the platform and tomorrow I start re-writing it. 

If my apps are running on O365 E3, and the only connectors are OneDrive for Business, Sharepoint, and O365. Is there any impact by the new licensing ? 

Really looks like MS is pushing everyone to use the per app / per flow license, as a P2 license which was $15 is now $55 per user ($40 for powerapps and $15 for flow)

I'm still unclear what MS is pushing.  I think any serious business app needs to use a database.  Azure SQL DB was a perfect choice for PowerApps since it was a standard connector.  Now that it made it a premium connector at a cost of $40/user/month it puts the whole use of PowerApps in question.  A business with 1000 users will suddenly have an IT expense of $480K/yr.  For that cost you can easily do custom apps.  I'm thinking MS is saying only use PowerApps with standard connectors and don't do any serious business app in PowerApps.



I am currently in the process of rewriting our app to use SharePoint as a back end and I'm already running into difficulty. SharePoint tables are all non delegable which means I can't even call 'MAX(table_name,Column_name)' from within powerapps.


Sharepoint just does not have the same functionality as a SQL database, and without a SQL database to drive tha App it will not be any where near as powerful or as useful.



I totally agree.  SP Lists isn't for serious business apps.  I use many DB features like views and stored procedures to get around limitations.  I also use Azure Functions.  I have a complex business process that involves a lot of steps 120+, emails, events etc.  SP Lists doesn't work with Azure Functions.  I currently only have 1 app and it is grandfathered until 2014.  I plan to have more.  I'm looking at implementing a custom solution using ASP.NET Core 3  Razor Pages.  I'm a little worried about security and identity but I have time to get it right.  It should be a fun project.  A custom app will allow me to use SQL triggers.  This is a major disappointment/limitation in PowerApps.  It will also allow clients to see selected data.


My opinion is the new pricing model is the death of PowerApps for serious business apps.  Time will tell.

This is just outrageous, we have spent 18 months developing and now actively using PowerApps for our business based on Microsoft finally appearing to allow access to really useful tools at an affordable price. They have effectively, with no notice, stopped us in our tracks and killed any useful development of PowerApps. I have seen some of the threads saying how much this change will cost other large companies; we are small by comparison but tens of thousands of pounds per year now need to be found if we are to continue.


Our hope is that Apps we have developed and in use are unaffected until 2024 and can continue to be 'tweaked' without falling foul of the new licence. Theo ther hope is Microsoft change their minds.


How do we take action to let Microsoft know what a dumb and frankly bully boy move this is?



Advocate V
Advocate V

The Microsoft reasoning behind the price increase is simple to understand.  This is what happens when MS move a product from being licensed as a part of Office 365 to making it licensed as a part of Dynamics 365.  The launch of the CDS was the key to this a couple of years back as it was clear that PowerApps was going to be repositioned as a part of D365 to get over the custom apps/solution issues.


From 'going public' at Ignite to implementing the change on 1st October is a matter of weeks.  What makes this underhand is the way Standard connectors for Microsoft's own platform have become Premium connectors. I wonder as to the age/experience of the humans who signed off this change.  My guess is they are Blue Badge Millenials who have never worked in an end-user scenario so have no idea as to the disruption this financial grab is going to cause.  Take a look at Nintext as an alternative

I am also keen to know this. With some applications in Production environment, we can't just kill them due to cost. We will be moving to some other non microsoft solutions. but need time to build on. How would the transition time work? 

Reading about this move from Microsoft, I'm truly saddened.

Being a long term promoter of Microsofts solutions, I have been driving and implementing Microsoft technologies for more than a decade. Specifically, we just completed a major project to move a number of on-prem SQL servers into Azure, with the specific goal to avoid using premium connectors, the price of which would undermine our IT strategy.

Now, Microsoft decides to completely change the guiding points we have used to decide on PowerApps and Flow for our business applications. Not only are they reclassifying the Azure SQL connector to "Premium", but they are also increasing prices at rates, I have never seen before from any serious IT soultions provider - in our case, specifically, we are using a number of Office 365 Business Essentials and Business Premium licenses for our users. My calculations show we will expierence price increases of more than 500% !!.


I ask myself: How can I ever trust Microsoft again, when this can happen - with this, you are directly undermining my personal credibillity as an advisor, promoting Microsoft solutions. Customers have invested in migrating to Azure and the Powerplatform under completely wrong assumptions and based on Microsoft being a trustworthy partner in the long run. All gone now. It makes me sad. One of the big arguments for migrating to the cloud in general, is less hastle with operations. This just moves the hastle from the IT operations to the strategic level - constantly forcing management in companies to get involved to re-consider their IT strategy, because Microsoft decides to change the economical foundation decisions were based on.

I just kindly ask you to deliver on your promises - make it a worry free expierence to migrate to the cloud without constantly rocking (tipping over) the boat. The least you could do is to provide existing users an option for nothing to change and then only change the price structure for new/added or changed featuresets instead of causing all this agony that is slowly undermining your position as a trustwothy and reliable partner for companies and cloud first strategies in general.

Helpful resources


Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!   This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08  23 @WarrenBelz  31 @DBO_DV  10 @Amik  19 AmínAA 6 @mmbr1606  12 @rzuber  4 @happyume  7 @Giraldoj  3@ANB 6 (tie)   @SpongYe  6 (tie)     Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08  10@WarrenBelz 25 @DBO_DV  6@mmbr1606 14 @AmínAA 4 @Amik  12 @royg  3 @ANB  10 @AllanDeCastro  2 @SunilPashikanti  5 @Michaelfp  2 @FLMike  5 @eduardo_izzo  2   Meekou 2   @rzuber  2   @Velegandla  2     @PowerPlatform-P  2   @Micaiah  2     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27     Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8   SunilPashikanti8

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Top Solution Authors
Top Kudoed Authors
Users online (3,478)