How to Configure or Create Relationships in Tables Part III

| Usama Ashraf

How to Create Many-to-Many Relationships:

In Many-to-Many relationship a bridge table or intersection table create that stores only required information from both tables. The intersection table can have a one-to-many relationship with both the Related Tables to stores the necessary information to define the relationship. You cannot add custom columns or lookup columns in that table. Intersection table is not visible on User Interface as well.

Steps of Creating Relationship:

Follow the steps from 1 to 6 in One-to-many relationship and then follow the below steps:

  • Now select the Many-to-Many relationship type.
  • Then add the Related Column in Related Many field.
  • After adding the Table name, click on Done and you many-to-many relationship established.

Conclusion:

Follow all the above steps you can create many-to-many relationship between the tables as per your requirements.

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting