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 / Relationship and Sub G...
Power Apps
Suggested Answer

Relationship and Sub Grid question

(0) ShareShare
ReportReport
Posted on by 2

Hi All,  I am new to Power Apps, so please bear this is mind lol.
I have, what I think is a simple task to accomplish, but I cannot get it to work. I have a main Table in Dataverse Planning. This table is the main table for my Model Driven App, and contains at the moment most of my data.
On tab 3 on the main page is for data for another Table called Checks, which then allows input into another table called Outcomes.
So each plan can have many checks, each check can have many outcomes.
On another tab I'd like to have a sub grid to display all the Outcomes that were filled in against the checks. However, despite me creating a One to Many relationship between the Planning and Checks Table and another one to many relationship between the Checks and Outcomes table, i cannot seem to get a view created that will display thee data.
I feel like I'm going round the bend with this, and have ended up creating many to one, many to many relationships between the tables, but to no avail.

so TL;DR I am trying to display data from a column on one table that is linked to another table, via another table into a subgrid :D

Categories:
I have the same question (0)
  • Suggested answer
    CU14080831-0 Profile Picture
    8 on at
    If you would like to display child records - you might want to use grids, specifically https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/the-power-apps-grid-control which is very nice.
     
    But lets start from begining:
     
    So each plan can have many checks, - Here you need main form on 'plan' entity which will include power apps grid (make sure it displays only 'related records')
     
    each check can have many outcomes - Inside power apps grid, you can set your outcomes to be 'Child items' of checks. 
     
    This way you will have a single form dedicated to plan, inside you will have a table with checks. Each check row will be expandable to show outcomes

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 834

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard