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.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


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

[DanielWesterdale]

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

[spoenk]

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.

[joeg]

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

[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

[RD-Man]

Can this be done in the Model-Driven App?

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

[edjk]

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?

[badfingergoodwin]

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

[pabloteki]

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