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 Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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.

Users online (3,562)