web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Two tables in one app
Power Apps
Answered

Two tables in one app

(0) ShareShare
ReportReport
Posted on by 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?

 

I have the same question (0)
  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    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)

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard