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

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

Просмотров 4,4 тыс.

50% 1

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.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
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
#PragmaticWorks

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

11 сен 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@joeg5526 2 месяца назад

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

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

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

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

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!

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

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

@spoenk7448 7 месяцев назад

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.

@pabloteki2782 5 месяцев назад

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

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

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

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 :)

@RD-Man Месяц назад

Can this be done in the Model-Driven App?

@powertothepeople4525 24 дня назад

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

@briankgarland 8 месяцев назад

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.