Power Apps & Dataverse: Relational Tables Made Easy
Vložit
- čas přidán 25. 07. 2024
- 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
🍬 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 ⬅
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.
Excellent Simple video to follow, that leaves you an opportunity to create many to many relationships. Once again thank you for your help.
You're very welcome!
Love this idea. I had such a hard time with the many to many concept.
Glad it was helpful!
Thank you, thank you! Gold!
Glad it helped!☺️
Thanks!
Welcome!
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?
I love you sirs, it hurts not to have began with you, thanks for all you do, pls keep me posted for subsequent collaborations ❤
😁😁🤗🤗👍👍
Thanks
Wow... thank you!
Hi Darren. Is there a video doing relations using autonumber id columns. Cheers
Yes, I have 3 videos on this!
1 - czcams.com/video/c3Rb7wACap0/video.htmlsi=loHbaXLFHBptYkBj
2 - czcams.com/users/livei_vl1YXPtwQ?si=lCVhg-_kuEoKBN-P
3 - czcams.com/users/livef81vwdcn7JQ?si=nufcTx77X6U01jA9
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.
Thanks for that ☺️
good content
Glad you liked it!😊
Hello what’s the difference doing the relationship this way and selecting the inbuilt many to many table relationship Dataverse offers ?
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.
With a custom many-to-many relationship, you have more control and flexibility over how the relationship is implemented.
Never even knew about the mapping tables before.. Thought this was OOTB
Glad it was helpful ☺️
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?
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.
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.
Oh, i found it already asked and answered down below by some other commenter. Thank you anyways :)
Glad it was helpful!☺️
@@PowerAppsTutorial btw, I'm Matevž, new student from your program:)
Why not just use an option/choices column for the services?
Choice column comes along with its own delegation issues at the long run you know ☺️