Many to Many Relationships in Power Apps [Dataverse Relationships Part 3]

In this video, you'll learn how to create many to many relationships in Dataverse and a few of the options you can use. You'll also see how to do the Relate and Unrelate function in Power Apps Power FX to join and unjoin two records together. Brian will show you how to implement the functionality for many to many in Dataverse then model-driven apps and lastly Canvas apps. This video series contains information needed for the PL-100, PL-200 and PL-400 certification exams.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
-~-~~-~~~-~~-~-

[zergling]

Thank you for covering model driven apps. Most content creators only cover canvas apps but I exclusively use model driven apps these days.

[AdamHaas]

I keep coming back to this video. It's making my complicated app possible. Thank you!

[vk]

Amazing Video !!! Excellent precision and clarity of thoughts in the walk through. Thanks a lot for making this tutorial.

[felipeabajo]

This is the first time I work with many to many relationships and the first 3 minutes of the video have helped me a lot to understand the high level picture. Thanks for sharing

[Fruition]

I’m about a year late to the party here with my post, but I’d like to point out that you are so awesome sauce, Brian.

Thanks for chopping the elephant in the room down to bite size pieces for us less-experienced Dataverse users to digest.

I also really enjoy when you throw in sprinkles of additional features of Dataverse that are outside of the box for traditional, more linear Excel & SQL users, like me. Dataverse is very powerful. I’m loving it!

[stevenhampson]

Ypur videos are gems of practical, succinct and relevant information. Always well thought, and well prepared. Thank you Brian and PW.

[SaidElnaffar]

Very rich indeed -- This topic is not easy, and yet very important. Scheduled for deep study. Liked and Subscribed.

[luizclaudioborges]

Great teacher, good examples, very well explained. Thank you!

[youssefchannel]

You saved my life Thank you so much I really had a big issue with many to many relationships but now you taught me how to do it thank you again.

[HannaSouthAfrica]

Dear Brian, Thanks for this informative video, it helped a lot. May I Please ask to show a demo of the design of a "If I want to store more information other than just the member information" video pretty please... In other words the traditional way of creating a many to many relationship. Thanks!

[shrirampophali]

Thank you very much for this wonderful explanation! 👍

[financiallyfreegenz]

Great video!
I am new to power apps and trying to make a daily checklist app (that can record results for future audits) as a portfolio. Please kindly make a video that will show the right entities that need to be included and also the proper relationship between them. I just can't seem to get it right 😅

[meganleecy]

This is exactly what i need to know!! Thank you! There are not much resources out there!

[surajpatil]

Thanks for the video. Could you also explain how to filter gallery with many to many relationship? for example, I would like to show list of A entity which is related to B1 record of B entity. A and B has many to many relationship.

[sossie]

Great videos Brian, I have a question about many to many relationships tables. Say there items that are specific to each relationship... e.g. for Project 1, and ContractorX, payment terms are 14 days, but for Project 2, and ContractorX payment terms are 20th of the month. In this the sort of situation where I would have to create a custom relationship table that you mention? It would be great to see a video on this.

[JontyLP]

Hi Brian! Thanks for the video. In the View associated with one of the “Many” tables (Projects for example), is there a way to reference data from the related “Many” table in a Model Driven App? This referred table doesn’t seem to come up in the View columns?

[rohanshaw]

Great video! I learnt a lot from it. keep up the great work.

[DennisKuhn]

Awesome content, very informative and pleasant to watch :-) Thanks for sharing, keep up the awesomest work 🙂

[njbsu]

Hi. Would want to ask, is there any way to restrict end user from removing/adding linked record in the many-to-many relationship table?

[luizclaudioborges]

Is it feasible to customize the upper horizontal menu when a user executes a model-driven app? I mean, would it be possible to hide some options such as ADD, DELETE, EXPORT TO EXCEL, SEND A LINK BY E-MAIL, etc...?