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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,463)