Unanswered

multi-tenant architecture with a CDS back end

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
arejay 4 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you for the input!

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CDogs1964 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Trinity365 40 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No