cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CapitalWinner
Level: Power Up

Powerapps licencing

Your licensing is confusing! We created a powerapp and want our staff to begin using it. Does the user that created the app need to be licensed? or does every staff member? Subsequently if it is the latter - can we use this PowerApps Portals page view capacity add-on""?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Powerapps licencing

As of October 1, 2019 the SQL connector was reclassified as a premium license. Any app connecting directly to SQL will require your users to have a PowerApps plan: $1300/month by your calculation.

You have right idea about creating a scheduled export of your SQL data to SharePoint for use in PowerApps. There is no need to connect to SQL directly unless you need it’s features (eg higher speed, better concurrency handling, security, etc). Your app will definitely be fine in SharePoint given your user base size and scope of your app.

My suggestion would be to use MS Automate (formerly Flow) to build the workflow. If you have any questions on how to do that there are some wonderful people over in the Flow Community who would able to answer your questions. In my own general opinion this method is acceptable and would be allowed by MS if you purchase the Flow license. However, you will definitely want to talk with your MS licensing partner to confirm.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Powerapps licencing

@CapitalWinner 

The answer depends on what datasources/connectors you plan to use.

 

Do you plan to use a Sharepoint list?  If yes, then anyone who is licensed to use SharePoint can build/use PowerApps at no additional cost.

Do you plan to use the Common Data Service or own Dynamics? If yes, then anyone who is licensed to use those applications can build/use PowerApps at no additional cost.

Do you plan to use Excel? In general, please don't do this.  But its free to build PowerApps on this at additional cost.

Do you plan to use some other data source (e.g. SQL/Azure SQL)? If yes, then its $10 per user per app per month or $40 per month for unlimited apps per user.

 

Suggest you contact your Microsoft licensing provider for exact details on your specific situation/

 

You can also check out this article for a pretty simple explanation of the licensing.  (It's how I got my head around it).

https://collab365.community/powerapps-licence-changes-in-terms-that-matt-weston-understands/

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

CapitalWinner
Level: Power Up

Re: Powerapps licencing

Thanks @mdevaney thats a great help!

 

Lets apply this to our specific circumstance though.

 

All our staff - approximately 130 people have Microsoft 365 E3 licenses. 

We have built an intranet on Sharepoint.

Within this intranet we have added a staff directory powerapp. (This powerapp links to our on premise SQL to retrieve extra details such as interests and hobbies)

We want all the staff to be able to search for staff members using this staff directory powerapp. 

 

Why would we pay $1300 per month only for the ability to search some staff members. Obviously we can do more if we build it but this app is functional and meets the needs of our organisation. 

 

Or alternatively, from your answer can we schedule a routine export of SQL and upload to sharepoint then the app taps into that sharepoint list without users having to subscribe?

Super User
Super User

Re: Powerapps licencing

As of October 1, 2019 the SQL connector was reclassified as a premium license. Any app connecting directly to SQL will require your users to have a PowerApps plan: $1300/month by your calculation.

You have right idea about creating a scheduled export of your SQL data to SharePoint for use in PowerApps. There is no need to connect to SQL directly unless you need it’s features (eg higher speed, better concurrency handling, security, etc). Your app will definitely be fine in SharePoint given your user base size and scope of your app.

My suggestion would be to use MS Automate (formerly Flow) to build the workflow. If you have any questions on how to do that there are some wonderful people over in the Flow Community who would able to answer your questions. In my own general opinion this method is acceptable and would be allowed by MS if you purchase the Flow license. However, you will definitely want to talk with your MS licensing partner to confirm.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

Super User
Super User

Re: Powerapps licencing

@CapitalWinner 

Did this post answer your question?  If yes, please close the thread.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,963)