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?
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.
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?
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021