Thank you for covering model driven apps. Most content creators only cover canvas apps but I exclusively use model driven apps these days.
@AdamHaas16 күн бұрын
I keep coming back to this video. It's making my complicated app possible. Thank you!
@PragmaticWorks15 күн бұрын
Great to hear! Thanks for letting us know and making my day Adam - Brian.
@felipeabajo3 ай бұрын
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
@Fruition102 жыл бұрын
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.
@stevenhampson86572 жыл бұрын
Ypur videos are gems of practical, succinct and relevant information. Always well thought, and well prepared. Thank you Brian and PW.
@PragmaticWorks2 жыл бұрын
I appreciate that!
@SaidElnaffar2 жыл бұрын
Very rich indeed -- This topic is not easy, and yet very important. Scheduled for deep study. Liked and Subscribed.
@luizclaudioborges3 жыл бұрын
Great teacher, good examples, very well explained. Thank you!
@PragmaticWorks3 жыл бұрын
Thank you for your kind words! Your are very welcome.
@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.
@shrirampophali Жыл бұрын
Thank you very much for this wonderful explanation! 👍
@PragmaticWorks Жыл бұрын
Glad it was helpful!
@HannaSouthAfrica3 жыл бұрын
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!
@HannaSouthAfrica3 жыл бұрын
Essentially I am looking to build a model driven app that have meetings with multiple members in multiple positions within the meetings... :/
@PragmaticWorks3 жыл бұрын
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.
@antonmollerberg29993 жыл бұрын
@@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.
@youcctechnologies53902 жыл бұрын
Great video. thanks for lecturing
@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 😅
@surajpatil13702 жыл бұрын
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.
@EuroWin2 жыл бұрын
This is gold! Thanks for sharing! :)
@PragmaticWorks2 жыл бұрын
Glad it was helpful!
@meganleecy46582 жыл бұрын
This is exactly what i need to know!! Thank you! There are not much resources out there!
@PragmaticWorks2 жыл бұрын
Glad it was helpful!
@chrislloyd8365 Жыл бұрын
Really explained this well - thanks!!
@sossie72 жыл бұрын
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.
@JontyLP8 ай бұрын
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?
@rohanshaw18272 жыл бұрын
Great video! I learnt a lot from it. keep up the great work.
@DennisKuhn772 жыл бұрын
Awesome content, very informative and pleasant to watch :-) Thanks for sharing, keep up the awesomest work 🙂
@withamla4 ай бұрын
Can a flow be used to update the many to many relationship?
@radhikap33227 ай бұрын
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
@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.
@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. :/
@minocat232 жыл бұрын
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.
@PragmaticWorks2 жыл бұрын
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.
@_technomensch9 ай бұрын
@@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.
@njbsu2 жыл бұрын
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?
@benjaminhill012 жыл бұрын
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?
@MrSakymoto2 жыл бұрын
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.
@luizclaudioborges3 жыл бұрын
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...?
@saradehond32932 жыл бұрын
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.
@nocodecreative2 жыл бұрын
I'd like to see an example where you use a table in the middle please!
@PragmaticWorks2 жыл бұрын
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.)
@nocodecreative2 жыл бұрын
@@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! ;)
@Rlaosgonzalez2 жыл бұрын
Hi! Is there some way you can relate and unrelate the records using a combobox?
@PragmaticWorks2 жыл бұрын
Sure, you would essentially do a ForAll loop to loop over the items selected .
@snodnipper32022 жыл бұрын
How can we update this intersection table from Dataverse?
@PragmaticWorks2 жыл бұрын
You would use the Relate and UnRelate functions to add or remove from the intersection table.
@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 ?