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
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.
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?
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 :)
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.
Definitely like to see the junction table being used with a filter on the selected student. Will have a try tho.
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!
This was done really well, exactly what I was looking for. Thank you
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
Great video, this is exactly what I was looking for, thank you so much....
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.
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?
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 :)
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.
Can this be done in the Model-Driven App?
Yes quite easily with a subgrid on the form! no code needed :)
How to apply filter in gallery with many to many relationship?