You’re offline. This is a read only version of the page.
7
I have a complex app for project management. I supply the app from Dataverse Table where I store all project details. Now I want to add approx 50 new rows for new functionality.
My idea is to store all of these rows in new Dataverse Table, because the data have not a lot to do with the data in first table. The only think that is common for both tables will be the name of the project.
Here I have first question: does it make sense from technical point of view to store the data separately? I have already a lot of columns in the first table and do not want to add additional 50.
if yes is there a way to copy automatically the name of the project from the first table to another and then download data from both tables to power app gallery?
Hi @lonsdaleit ,
You could create a relationship between the Project table and this new table with a "Lookup" column on the new table that points to the project in the first table. This will basically create a (1:N) mapping from the project table to this new one.
You will be able to add a subgrid to the model-app form (if this is what you are using) to create the related records right from the Project table. When you do this, you can define column mappings in the relationship (Map table columns in Power Apps - Power Apps | Microsoft Learn)
Share
Report
All responses (
Answers (
