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

Подписаться 225 тыс.

Просмотров 29 тыс.

50% 1

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.
Part 1: Creation and Enforcement of Relationships: • Creation and Enforceme...
Part 2: Hierarchy Relationships: • Hierarchies and Self-J...
Part 3: Many to Many Relationships and Relate and Unrelate: • Many to Many Relations...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

Опубликовано:

22 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 59

@zergling6000 Год назад

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

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

@vk2875 Год назад

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

@SaidElnaffar Год назад

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

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

@stevenhampson8657 2 года назад

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

@PragmaticWorks 2 года назад

I appreciate that!

@DennisKuhn77 2 года назад

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

@youcctechnologies5390 2 года назад

Great video. thanks for lecturing

@luizclaudioborges 2 года назад

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

@PragmaticWorks 2 года назад

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

@rohanshaw1827 2 года назад

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

@meganleecy4658 2 года назад

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

@PragmaticWorks 2 года назад

Glad it was helpful!

@chrislloyd8365 Год назад

Really explained this well - thanks!!

@shrirampophali Год назад

Thank you very much for this wonderful explanation! 👍

@PragmaticWorks Год назад

Glad it was helpful!

@EuroWin 2 года назад

This is gold! Thanks for sharing! :)

@PragmaticWorks 2 года назад

Glad it was helpful!

@financiallyfreegenz 10 месяцев назад

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 😅

@surajpatil1370 2 года назад

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.

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

@saradehond3293 2 года назад

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.

@JontyLP 6 месяцев назад

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?

@luizclaudioborges 2 года назад

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

@radhikap3322 6 месяцев назад

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

@withamla 3 месяца назад

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

@sossie7 2 года назад

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.

@HannaSouthAfrica 2 года назад

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 2 года назад

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

@PragmaticWorks 2 года назад

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 2 года назад

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

@facundogorla8772 Год назад

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.

@benjaminhill01 2 года назад

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.

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

@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. :/

@snodnipper3202 2 года назад

How can we update this intersection table from Dataverse?

@PragmaticWorks 2 года назад

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

@minocat23 2 года назад

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 2 года назад

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 8 месяцев назад

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

@nocodecreative 2 года назад

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

@PragmaticWorks 2 года назад

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 2 года назад

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