multi-tenant architecture with a CDS back end

[arejay]

We are looking to upgrade a handful of existing PowerApps single-tenant applications, which are part of an overall application suite, that use SharePoint Lists for storage to a multi-tenant architecture with a CDS back end and one database-per tenant, which of course may be an elastic pool for cost-effectiveness. We would first like to understand if it is possible to have the same schema in CDS as we do in our SharePoint Lists so that there is little-to-no modification to the apps required to change out the back end to CDS. If this is possible, we would like to understand what tools are available for our centralized system administrators to manage the multiple single-tenant databases on behalf of our customer network. We also need to understand how to estimate the price of this solution as we will need to budget this for a few different usage levels based the size of our customer network.

Does anyone have experience with this or know of someone at Microsoft that could assist with this?

[Pstork1]

To the best of my knowledge, Power Apps is limited to a single Tenant.  You can create an application, export it from one tenant, and import it to another tenant, but at that point its a seperate application.  I believe that's also true if you build the app as a solution.  I have not seen any way to do an app that is multi-tenant aware. So I don't think what you are trying to accomplish is possible.

[arejay]

thank you for the input!

[v-siky-msft]

@arejay  It's impossible, PowerApps is not a multi-tenancy SaaS architecture.

Sik

[CDogs1964]

I understand that a single Power Apps app may not be built to handle separate databases based on the user, but why could you not build a true multi-tenant app with all tenants "living" in the same DB and the data displayed is filtered based on the user?

[edobaria]

Any updates on the possibility of a multi-tenant solution in powerapps? I want to use Azure SQL DB for the backend data source and PowerApps for the front end for multi tenant PowerApp.

[Pstork1]

As I mentioned in my reply you can build a Power App, export/import it into different tenants and all use the same back end Azure SQL database.  But each tenant would be a separate App.  There is no way to write an app that is multi-tenant aware.  But you can Export/Import Apps between tenants.