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

[@zergling6000]

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

[@vk2875]

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

[@Fruition10]

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!

[@stevenhampson8657]

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

[@PragmaticWorks]

I appreciate that!

[@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

[@SaidElnaffar]

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

[@AdamHaas]

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

[@PragmaticWorks]

Great to hear! Thanks for letting us know and making my day Adam - Brian.

[@youssefchannel1327]

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.

[@luizclaudioborges]

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

[@PragmaticWorks]

Thank you for your kind words! Your are very welcome.

[@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!

[@HannaSouthAfrica]

Essentially I am looking to build a model driven app that have meetings with multiple members in multiple positions within the meetings... :/

[@PragmaticWorks]

Oh sure, I can work on one of those in the next few weeks. If you're storing any additional metadata about a Role for example in the meeting, two traditional 1:m with a joiner table would be the way.

[@antonmollerberg2999]

@@PragmaticWorks This would be great, exactly what i am looking for. I can't find any information about creating a functional joining table i dataverse. I have several applications where the native many to many relationship falls short. I specifically have a scenario where an employee can have multiple roles in the company, and the roles can have multiple competency requirements. Getting the relationship to extend all the way to the employee and getting an overview of said employees competency requirements seems impossible with native solutions. Add to that multiple roles that include the same requirements and you got yourself a video :)

[@martinnoah9716]

@@PragmaticWorks have you made a video on this yet? Cheers

[@Livahz]

@@PragmaticWorks Please, have you made the video. Really need a visual for a project I’m working on. Thanks so much.

[@meganleecy4658]

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

[@PragmaticWorks]

Glad it was helpful!

[@surajpatil1370]

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.

[@sossie7]

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.

[@colindunbar3927]

Yes, I agree. I've searched the web and can't find much on creating the custom relationship table. Do you know of any articles on the topic?

[@Livahz]

Me too! Could you please make the video. I really need an explanation.

[@youcctechnologies5390]

Great video. thanks for lecturing

[@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?

[@shrirampophali]

Thank you very much for this wonderful explanation! 👍

[@PragmaticWorks]

Glad it was helpful!

[@chrislloyd8365]

Really explained this well - thanks!!

[@rohanshaw1827]

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

[@EuroWin]

This is gold! Thanks for sharing! :)

[@PragmaticWorks]

Glad it was helpful!

[@withamla]

Can a flow be used to update the many to many relationship?

[@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 😅

[@RyuzakiF]

Can you edit/create the records that are related between those 2 tables using ONLY a canvas app? with a form and a combobox as how it is done for a multiple options column?

[@PragmaticWorks]

Yes absolutely. If it's not a M:M table, you can use a Patch to accomplish this likely most effeciently.

[@DennisKuhn77]

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...?

[@Rlaosgonzalez]

Hi! Is there some way you can relate and unrelate the records using a combobox?

[@PragmaticWorks]

Sure, you would essentially do a ForAll loop to loop over the items selected .

[@radhikap3322]

I don't understand form and may to many relationship how they are interlinked as we have not mentioned this form. Is for this relationship.. Can anyone please help

[@saradehond3293]

Hey, is it possible to add a many to many TextLabel on the first gallery? Like, within the unselected first gallery? I have managed to count the rows related, but not show any items from it.

[@minocat23]

Isn't it a bit dangerous though if it is not possible to see what is in the holding table? Traditionally we can see the two keys in the holding table and identify any issues that may have arisen.

[@PragmaticWorks]

You can still see the data in the table if needed just not on the website. You can see it in Power BI or in traditional SQL Server tools.

[@_technomensch]

@@PragmaticWorks can you show how to display that data in Power Bi? In your construction example, say you need to see all the current projects and all those associated with each project so you know who is and isn't available. Or, in the classroom, you want to see not just all the classes, but also who is in each class.

[@benjaminhill01]

Do you know how to Relate() with a new record? In your example, lets say you want to add a new project. While you're filling in the details like name, can you also relate to accounts? Or are you only able to do it with existing records?

[@MrSakymoto]

did you ever find out? I tried to build a relationship, but when i create a new record, the grid isn't active until I save it.

[@snodnipper3202]

How can we update this intersection table from Dataverse?

[@PragmaticWorks]

You would use the Relate and UnRelate functions to add or remove from the intersection table.

[@bzqp2]

I was wondering why it doesnt work for me. Then I realized that for some reason the separator in the "Relate" function turned from a comma to a semicolon. Why would they change it without updating the documentation?? :o

[@bzqp2]

Turns out the separators change from one language version to another. And the localized documentation is just a machine translation of the English version so it reflects only the English syntax... Classic Microsoft. :/

[@nocodecreative]

I'd like to see an example where you use a table in the middle please!

[@PragmaticWorks]

The table is a physical table you can use in Power BI or in Power Apps, I use Power FX to do something like CompanyGallery.Selected.Contacts (where it pulls the middle table to find what contacts are at what company.)

[@nocodecreative]

@@PragmaticWorks that great - maybe an idea for another video, but I have a model-driven app where my resources are assigned to an assignment, we also have to ear marked resources against unfilled assignments, so one resource could be marked against many assignments or vice versa. What I'd like is to have a status of each rescues against this (potential, interested, put forward, declined, confirmed etc) - now, I've managed to achieve this with a middle table, but this makes a whole new record on the table to manage, with new records every time you mark someone against an assignment as a potential resource, it feels messy, there must be a better way.... just an idea... I've subscribed, so if you make a video on it I'll be sure to watch and share and be very grateful! ;)

[@blutkraehe_official]

thenks man! but i have a problem with the Relate and unrelate funtions: If(ThisItem.tbl_Contact in gal_CustomersCompanys.Selected.tbl_Contact ,DisplayMode.View ,DisplayMode.Edit ) my 'tbl_Contact' says 'expected a one-column table', have you a soluttion ?