Power Apps & Dataverse: Relational Tables Made Easy

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

Просмотров 8 тыс.

50% 1

Database design doesn't have to be complicated. This video tutorial breaks down how to create one-to-many and many-to-many relationships in Microsoft Dataverse for Power Apps. By focusing on a practical scenario involving three simple tables - People, Service, and PeopleServiceMap, we bridge the gap in understanding that many Power Apps users face. Whether you're a beginner or have some experience, this guide will help you handle relational data confidently and elevate your Power Apps projects.
➡️ Get access to our free Power Apps crash course (and our community) here:
tinyurl.com/DarrensStuffFree 🔗
Darren Neese, Microsoft MVP, PowerApps Tutorial
#DarrenNeese
#PowerAppsTutorial
#Dataverse

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

21 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@PowerAppsTutorial 11 месяцев назад

🍬 Get my free video course, access to my free community, and, if you would like, you can book a call with me here: go.superpowerlabs.co/opt-in-page-page ⬅

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

Interesting I followed along doing exactly the same thing yet in the PersonServiceMap table I could do the PersonLookup but I couldn't do the ServiceLookup. The Service table didn't pop up. I waited a few minutes and re-watched your video. Then decided to click away to another environment and come back and now it's there. Like you say, the scribes can only work so fast! Just mentioning if others face the same issue. I realize there's so much more to all of this, but when you do again, you should show in the "manage relationships" how it created the 1:N relationship etc.. Thanks for the simple explanation to all of this. It seems less daunting now.

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

Excellent Simple video to follow, that leaves you an opportunity to create many to many relationships. Once again thank you for your help.

@PowerAppsTutorial 9 месяцев назад

You're very welcome!

@enjtbpu9027 9 месяцев назад

Love this idea. I had such a hard time with the many to many concept.

@PowerAppsTutorial 9 месяцев назад

Glad it was helpful!

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

Thank you, thank you! Gold!

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

Glad it helped!☺️

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

I love you sirs, it hurts not to have began with you, thanks for all you do, pls keep me posted for subsequent collaborations ❤

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

😁😁🤗🤗👍👍

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

Hi Darren, I have three tables of data that I receive, two of the tables have primary keys, the third has two related columns to link the two If I create a virtual table how I do I make these relationships then to the existing columns? Or do I need to manually create a new lookup column and populate the data?

@MikeyMyra 11 месяцев назад

Thanks!

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

Welcome!

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

good content

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

Glad you liked it!😊

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

Hi Darren. Is there a video doing relations using autonumber id columns. Cheers

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

Yes, I have 3 videos on this! 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-c3Rb7wACap0.htmlsi=loHbaXLFHBptYkBj 2 - ru-vid.comi_vl1YXPtwQ?si=lCVhg-_kuEoKBN-P 3 - ru-vid.comf81vwdcn7JQ?si=nufcTx77X6U01jA9

@ralphlagos4210 6 месяцев назад

Never even knew about the mapping tables before.. Thought this was OOTB

@PowerAppsTutorial 6 месяцев назад

Glad it was helpful ☺️

@johnbrennan8442 11 месяцев назад

Hello what’s the difference doing the relationship this way and selecting the inbuilt many to many table relationship Dataverse offers ?

@_PowerThomas 11 месяцев назад

The built-in many to many feature creates a hidden table in the background to map the records between the selected tables. You can’t reach that table neither alter it. If you want to store additional properties of that relationship, you need to create your own linking table.

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

With a custom many-to-many relationship, you have more control and flexibility over how the relationship is implemented.

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

Nice video. Just a comment about the comparison and asignment of records: You have a copy of the record in your gallery, so they are not equal. For asignment you only need the right type, you just replace what is in the database for something else.

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

Thanks for that ☺️

@lorneandersen 11 месяцев назад

I am using the same drawSQLApp that you are using, but I have the free version. What is odd is that I cannot select the same data description as you can do. In other words, you can select "unique identifier", but I cannot. Is there something that I am doing wrong?

@NielsShared 11 месяцев назад

When creating a database diagram, did you choose the SQL Server Database type? I've got the free version as well, created a SQL Server database diagram and I'm able to select unique identifier as data type.

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

Thanks

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

Wow... thank you!

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

Pardon if i missed it in the video, but what is the advantage of creating a dedicated many-many table. Doesn't dataverse create automatically one for you in the background when you assign such relationship between two tables? Pardon for my ignorance. Rookie here.

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

Oh, i found it already asked and answered down below by some other commenter. Thank you anyways :)

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

Glad it was helpful!☺️

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

@@PowerAppsTutorial btw, I'm Matevž, new student from your program:)

@ralphlagos4210 6 месяцев назад

Why not just use an option/choices column for the services?

@PowerAppsTutorial 6 месяцев назад

Choice column comes along with its own delegation issues at the long run you know ☺️