Power Platform Community Forum Thread Details

Structure of Tables when expanding App to several sites/departments

Hey Power Apps Community!

I'm working in a company that has several sites all around the world (NA, Europe, Asia etc.)

I have been working on a canvas App for the department in a company I work for (Europe). I now have that luxury problem, that there is a high demand for my app, where several other sites in my company want to implement it to their own department's.

Quick intro to my app

It is a pretty basic app with a form that submits all the relevant data to a Sharepoint list (I want to migrate away from Sharepoint and into Dataverse). In this form, I have two dropdowns that both have their own data source (this comes again from a Sharepoint list) where I'm pretty much just getting some data from these list's and putting them into my two dropdowns. So in total, I have three Sharepoint List's. Here is the catch, the value of the dropdown lists' various from department to department, so this is not fixed.

My question/challenge

I'm struggling a little bit about how I should structure my Tables in Dataverse so that it makes sense when expanding the app to several other sites that will have their own dropdown values.

Would it make sense to have several tables where each site has their own tables, or should I create one gigantic table, that stores all the values from all sites and just use a Site_ID to identify each record?

Is there any best practice of how this can/should be solved?

In terms of adding the values to the dropdown(s), I simply thought about creating a new screen in my already existing app, where an admin from each site then can patch all the values into a Table with their own unique identifier and then just make a Lookup to add these values into the dropdown.

I hope my question makes sense - and please let me know, if you want me to elaborate on anything! I really want to find the best possible solution for this, due to the fact that perhaps 10-20 different sites all around the world will be using this app.

Categories:

Quick Links

Subscribe to this forum!