cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Withnail
New Member

PowerApps License Pricing: building with Microsoft SQL Server

Having spent an hour researching pricing, I am (yet again with Microsoft) completely confused. 😧

 

I have office 365 Business Essentials which costs GBP £3.80 per month and this gives me "PowerApps for Office 365". My reading is that this allows you to connect to things like SharePoint Lists and Excel workbooks but not the CDS or any databases.

I believe that, in order to create a canvas app that connects to MS SQL Server (online) for CRUD operations, I have to purchase the PowerApps Plan 2 licence which costs £30.20 per month. Is that correct?

There is a free 3 month period. Can I develop the app in those 3 months and then turn off this licence? 😀 And then turn it back on when I want to update it?

 

I want two other users to be able to run the app. Can they use their current "PowerApps for Office 365" or do I need a Plan 1 licence for each? (Having now created a trial tenant and then connected to SQL Server, I get this message: "Apps that use this connector will require end users to have at least Power Apps Plan 1." So I think I've answered my own question - can someone confirm?)

 

Thanks!

 

The biggest hurdle to developing apps in PowerApps is the pricing / licensing model. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
timl
Super User
Super User

Hi @Withnail 

I get how confusing this is.

Plan 1 and 2 licenses no longer exist - they've been superseded by the per app and per user licensing model.

In your case, the cheapest way to use MS SQL Server is to purchase per app licenses at £10/user/month. As you've found out, your other 2 users will also need a license.

You need a license to run and develop your app. So if you develop your app with a trial license and the trial expires, you'll no longer be able to run your app (it won't load).

Feel free to post back if you need any clarification on this.

View solution in original post

Hi @Withnail 

Unfortunately, Office 365 Business Essentials doesn't include the option to connect to SQL Server.

I think they haven't completely changed the dialogs, which is why we still references to Plan 1 and Plan 2.

View solution in original post

4 REPLIES 4
timl
Super User
Super User

Hi @Withnail 

I get how confusing this is.

Plan 1 and 2 licenses no longer exist - they've been superseded by the per app and per user licensing model.

In your case, the cheapest way to use MS SQL Server is to purchase per app licenses at £10/user/month. As you've found out, your other 2 users will also need a license.

You need a license to run and develop your app. So if you develop your app with a trial license and the trial expires, you'll no longer be able to run your app (it won't load).

Feel free to post back if you need any clarification on this.

View solution in original post

@timl - thanks so much! That is much clearer, and cheaper! 😀

 

Just one other thought: we all have Office 365 Business Essentials which includes 'PowerApps for Office 365'. I'd noticed that this was a stripped down version of P1 and P2 licences i.e. without database connectivity. Is it still the case that this is different to the new $10/month licence? Or (hope against hope) have I already got a fully fledged PowerApps licence within Office 365?

 

BTW, when I try to connect to SQL Server it still says it's a "Premium connection will start a Power Apps Plan 2 trial." 🤔

Hi @Withnail 

Unfortunately, Office 365 Business Essentials doesn't include the option to connect to SQL Server.

I think they haven't completely changed the dialogs, which is why we still references to Plan 1 and Plan 2.

View solution in original post

Thanks, yes that makes sense.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,636)