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?
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?