Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Multiple Dataverse Tables in PowerApps


I have been building quite a comprehensive app recently using Canvas apps and recently I have moved the main table over to dataverse. 


I am now thinking about moving away from having one large table and instead splitting the data into multiple smaller tables. 


I have followed a tutorial where you set the primary key and set a lookup from the 'child' table to the 'parent' table but that's about it. In my case the Lookup was the JobID number.  


Basically, I want a main table with job lines with columns such as JobID, JobName, Start Date, End Date etc., and then other tables such as Crew with the same JobID and JobName etc., but other columns such as CrewName, Crew Role etc. I may then have another table for Vehicles etc., again referring back to the same JobID and JobName. 


What is the best way to join these two tables together and wanting to show them and edit them in a gallery?


Many thanks. 


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,232)