cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Johwe32
Level: Powered On

Is PowerApps with a Office365 License work for my app?

I'm about to build an app using Excel/Sharepoint as a database. It is intented to be used by around 500 persons, max 120 people at the same time. Totalt number of entrys into Sharepoint/Excel will be around 10 000 posts per year. Is powerapps capable of handling this or should I upgrade my license and work with SQL or CDS?

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Is PowerApps with a Office365 License work for my app?

Hi @Johwe32

 

To use Azure SQL Connector in PowerApps you do not need PowerApps Plan 1 or Plan 2 license, regular Office365 Enterprise plan is enough.

 

If you say it will be around 10,000 records per year I strongly suggest SQL, because it has a lot more delegable functions and works smoother than SharePoint List. For some reason I always have trouble with Apps connected with SharePoint List where sometimes they update correctly sometimes they just don’t. I have rarely had problems with my apps that use Azure SQL Database.

 

You cannot use Excel since at this version of PowerApps you can use maximum of 2,000 rows from excel table.

 

You could use CDS, however then every user that will use your app will require PowerApps Plan1. For 500 people that would be around $2,500 USD/month.

 

More on delegation

 

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

Re: Is PowerApps with a Office365 License work for my app?

Hi @Johwe32

 

To use Azure SQL Connector in PowerApps you do not need PowerApps Plan 1 or Plan 2 license, regular Office365 Enterprise plan is enough.

 

If you say it will be around 10,000 records per year I strongly suggest SQL, because it has a lot more delegable functions and works smoother than SharePoint List. For some reason I always have trouble with Apps connected with SharePoint List where sometimes they update correctly sometimes they just don’t. I have rarely had problems with my apps that use Azure SQL Database.

 

You cannot use Excel since at this version of PowerApps you can use maximum of 2,000 rows from excel table.

 

You could use CDS, however then every user that will use your app will require PowerApps Plan1. For 500 people that would be around $2,500 USD/month.

 

More on delegation

 

View solution in original post

Johwe32
Level: Powered On

Re: Is PowerApps with a Office365 License work for my app?

Thanks for a quick and thorough reply!

 

Does sharepoint have the same limits as excel, 2 000 records?

 

On the topic of Azure SQL connector, I guess the Azure SQL Database is not included in the Office 365 license I have?

Anonymous
Not applicable

Re: Is PowerApps with a Office365 License work for my app?

SharePoint does support delegation (however very basic) so you can have PowerApps with SharePoint List as Data Store and have more than 2,000 records.

 

Azure Services are separate Microsoft product and you will have to order it. However simple Azure SQL database are quite cheap ($10/month).

 

Azure SQL Connector in PowerApps is free and come with Office 365 license.

Johwe32
Level: Powered On

Re: Is PowerApps with a Office365 License work for my app?

I'm trying to find the app you are referring to as Azure SQL Connector. I can't find it in Powerapps under connections. Does it go by another name, Azure SQL Data Warehouse?

Anonymous
Not applicable

Re: Is PowerApps with a Office365 License work for my app?

Hi @Johwe32

 

Sorry for being confusing. The connector is called just "SQL Server"

 

1.png

Johwe32
Level: Powered On

Re: Is PowerApps with a Office365 License work for my app?

I came up with another question.... Do you know if all users of the app will be able to access the SQL database from outside the app, as with a sharepoint-list?

Anonymous
Not applicable

Re: Is PowerApps with a Office365 License work for my app?

Hi @Johwe32

 

If you create an app in Default environment and share the SQL Connector with your users. Then the users will be able to use your SQL connector in the apps they create themselves. They can add the SQL connector and manipulate any data without using the app you created.

Johwe32
Level: Powered On

Re: Is PowerApps with a Office365 License work for my app?

Thanks for your reply. 

 

So basically there is no way to prevent users of the app from seeing all data?

 

The app I'm building is a like the Help Desk app that is a template. Since GDPR came in effect a month ago I only want the users to access their own posts.

Anonymous
Not applicable

Re: Is PowerApps with a Office365 License work for my app?

If you create a new environment (you will need PowerApps Plan 2 license) and create your apps there. Other people will be able to use the app (With basic PowerApps for Office 365 Plan), however they will not be able to create apps there (unless you allow them to). This way they will not be able to bypass your app and access the data.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,015)