Intro to Many to Many Relationships in Canvas Apps: A Beginner's Guide

Many To Many Relationships in Canvas Apps can be scary! If you don't come from a Database background, the concept can seem pretty foreign! This Video will help you to identify a Many To Many Relationship, how to establish that relationship in your Environment/Solution, and how to use that relationship to relate records from one table to another table inside of your Canvas App.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "NATE30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZbin: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@joeg5526]

This was done really well, exactly what I was looking for. Thank you

[@DanielWesterdale]

Definitely like to see the junction table being used with a filter on the selected student. Will have a try tho.

[@powertothepeople4525]

Made the video, and it should be published to this channel in the next week or so. I'll reply with the link as soon as it's posted!

[@mtamitolanga]

Thank you for the video!! I think I prefer the junction table. In the many-to-many, where are the multiple classes for the student patched? because the virtual table is inaccessible? 👍. Its straight forward in Dataverse

[@badfingergoodwin]

Great video, this is exactly what I was looking for, thank you so much....

[@briankgarland]

I literally just did this an hour before I saw this video. And it was a freaking nightmare. Dataverse makes this much easier, but I didn't have that option. My SQL Server database uses a link table between the main table and the look up table, and a combobox on my detail screen. I finally figured it out using different collections to manage add or deleted items from the combobox and writing the changes out to the table. A nightmare. A stored procedure would've probably been a better option.

[@edjk6278]

Greetings, Nate… I love your work a quick question… Is it possible to structure a many to many relationship where Sharepoint is the data source I noticed in this video you leveraged a table name that was created by Dataverse to create checkbox functionality. How would this work if I had Sharepoint as a data source?

[@powertothepeople4525]

Thanks for the kind words! SharePoint unfortunately is not a database, so Many-To-Many relationships are not supported, however, you could easily set up a Junction table in SharePoint! make sure you check out the other video I posed about Junction tables, and set up your SharePoint lists in the same way :)

[@spoenk7448]

The fact that IntelliSense doesn't suggest the right column is very annoying with the way you have to reference the id column in Power Apps Canvas. What I suggest people do is go to the tables and rename the Display name of your Unique Identifier to something like ClassId and StudentId so you know to reference that. This seems a small thing for this example, but may be huge when you're working with huge tables with column names that are similar to the table name, and column names that are similar to eachother.

[@RD-Man]

Can this be done in the Model-Driven App?

[@powertothepeople4525]

Yes quite easily with a subgrid on the form! no code needed :)

[@pabloteki2782]

How to apply filter in gallery with many to many relationship?