You’re offline. This is a read only version of the page.
Announcements
149
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.
Hello @Rama96x,
Create a table called SITE Details and Store all the SITE INFORMATION like (Europe/India/US Etc)
Then create a LOOK UP field in the TABLE and map the SITE INFORMATION(Table). So that we can easily identity which Site this Record belongs too.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Share
Report
All responses (
Answers (
