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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,346)