cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tbadger
New Member

Table Connections and Connection Roles View

Hi,

I am building an inventory app and am attempting to connect products with associated products.  I tried a many to many relationship but when viewing related records it only showed the related items from the product I originally made the connection from (if I navigated to the associated product and then to related records it was blank). 

 

In order to get around this, I have created a Connection Role in my solution successfully and it works (if I choose related connections for either of the related products it shows the other related products).  However, when viewing "related connections" on a form, I would like to customize the "Active Connection Associated View" to show more than just the Primary Name Column (see example screenshot below).  I cannot seem to find this view anywhere.  Any suggestions on where to look?  It seems to be a system table?

 

tbadger_0-1645159175729.png

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

Hi @tbadger ,

 

This is under the Connection table in the views.  If you don't see this in your list, make sure you change the filter to show "All" tables.  

 

This is a shared view across any Connection so I would suggest to create a new view to utilize for your specific connection relationship and then you can select "Related" under the Table Columns to modify and add your specific columns from your tables.

Screen Shot 2022-02-18 at 4.29.26 AM.png

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @tbadger ,

 

This is under the Connection table in the views.  If you don't see this in your list, make sure you change the filter to show "All" tables.  

 

This is a shared view across any Connection so I would suggest to create a new view to utilize for your specific connection relationship and then you can select "Related" under the Table Columns to modify and add your specific columns from your tables.

Screen Shot 2022-02-18 at 4.29.26 AM.png

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
tbadger
New Member

Thanks Drew!  Problem was I could not find the Connection table even when selecting all tables in my solution.  Turns out I needed to add the table to my solution first.  Thanks for the reply!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,358)