Answered

Is PowerApps with a Office365 License work for my app?

(0) Share

Report

Posted on by Johwe32

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Johwe32 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Johwe32 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Johwe32

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

Was this reply helpful? Yes No
Johwe32 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Johwe32 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Johwe32 44 on at

Like
a
(1)

Report
Copy link

Link copied!

Ok, thank you very much @Anonymous.

I searched this forum and found this https://powerusers.microsoft.com/t5/General-Discussion/PowerApps-Writing-back-to-SQL/td-p/104348.

As I understand it you can restrict access on the SQL side using stored procedures and Flow. In my case this means I could create a SP that filters the data on the users email and thereby solve my problem. Do you think that solution is possible or am I understanding it wrong?

Again, thank you very much.

Was this reply helpful? Yes No