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 / Model driven question
Power Apps
Unanswered

Model driven question

(0) ShareShare
ReportReport
Posted on by 12

I'm stuck on the following issues

 

1)  I have 4 tables

2)  Table 1 has a primary key with values of A, B, C

3)  Table 2 has a primary key with values 1,2,3,4 with a key column referencing the primary key in Table 1

4)  Table 3 has a primary key of values 9,10,11,12 with a key column referencing the primary key in Table 2.  So in turn, it "should be referenced to Table 1 A,B,C since Table 2 has the key column reference for Table 1.

5)  Table 4 has a primary key with values of X, Y, Z with a key column referencing the primary key in Table 1

 

 

This is where I am stuck.  If I create a dropdown on a form for Table 4 with values from Table 5, how can I restrict to only show those records that are have the key reference from Table 1.

 

This may give a better idea:

 

 Table 1                

Key Value:    A         Description: Company A

 

Table 2

Key Value:    1          Description:  Header 1

Company:    A          

 

Table 3

Key Value:    10         Description:  Detail 1

Header:          1

<Here I need the dropdown, but ONLY those people that have the company of A, which is in my header reference>

 

Table 4

Key Value:      X         Description:  Sally

Company:      A

 

 

My question is, should I create the Company in the Detail as well as header and automatically create the company when the detail is created from the header or is there another way?

 

 

 

Categories:
I have the same question (0)
  • JonDoesFlow Profile Picture
    1,304 on at

    hey @bdherhx 

     

    This will help you

     

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Configure-Cascading-Dropdown-in-Model-driven-App/td-p/1230591

     



    ---------------------------------------------------------------------------


    If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

    Blog - JonDoesFlow
    Twitter - JonDoesFlow
    YouTube - JonDoesFlow

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 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard