Power Apps & Dataverse: Relational Tables Made Easy

[@PowerAppsTutorial]

🍬 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 ⬅

[@MEPsideofBIM]

Thanks

[@PowerAppsTutorial]

Wow... thank you!

[@enjtbpu9027]

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

[@PowerAppsTutorial]

Glad it was helpful!

[@brysonuk]

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

[@PowerAppsTutorial]

You're very welcome!

[@dvspriest]

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?

[@richardclowes6166]

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.

[@eyoborelvis8224]

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]

😁😁🤗🤗👍👍

[@MEPsideofBIM]

Thank you, thank you! Gold!

[@PowerAppsTutorial]

Glad it helped!☺️

[@MEPsideofBIM]

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]

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

[@PowerAppsTutorial]

Glad it was helpful!☺️

[@MEPsideofBIM]

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

[@johnbrennan8442]

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

[@_PowerThomas]

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]

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

[@michaeldell6309]

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

[@PowerAppsTutorial]

Yes, I have 3 videos on this! 1 - kzbin.info/www/bejne/mWS1k2qtdqiUppIsi=loHbaXLFHBptYkBj 2 - kzbin.infoi_vl1YXPtwQ?si=lCVhg-_kuEoKBN-P 3 - kzbin.infof81vwdcn7JQ?si=nufcTx77X6U01jA9

[@bernardor]

Hi! loved your videos! I have a problem that you may be able to help me with; I have a dataflow populating a fact table which has a lookup column, pointing to a dimension table. My problem is that whenever I have a record with a value that is not in the dimension table, my dataflow will fail (due to the missing lookup value). Is there a way to avoid that? I would like for the record to be added, and put a null in the lookup column, or something like that.

[@PowerAppsTutorial]

To avoid dataflow failures when a lookup value is missing from the dimension table, you can modify the dataflow to perform a left join instead of an inner join, allowing unmatched records to still be added with a null or default value in the lookup column. Additionally, you can include conditional logic to handle missing lookup values during the transformation step and automate validation reports to track data integrity issues. This ensures that your fact table is populated without disruption while maintaining flexibility in handling missing values.🚀 You can join my FREE Community for more www.skool.com/power-apps-community 🙂

[@bernardor]

@@PowerAppsTutorial thank you very much!

[@MikeyMyra]

Thanks!

[@PowerAppsTutorial]

Welcome!

[@mikedsjr]

If I had a category in side service and I included it in people servicemap because I need it as a way to ensure no duplicates, how do I get it to show in peopleservicemap because I can’t figure that out.

[@PowerAppsTutorial]

Have your question posted on my FREE community for quick help😊: www.skool.com/power-apps-community

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]

Thanks for that ☺️

[@lorneandersen]

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]

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.

[@Stjopa-lq7cv]

Does this custom many-to-many (PeopleServiceMaps) work also in model driven app? I guess no

[@PowerAppsTutorial]

Yea sure🙂

[@andredoestech]

good content

[@PowerAppsTutorial]

Glad you liked it!😊

[@ralphlagos4210]

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

[@PowerAppsTutorial]

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

[@ralphlagos4210]

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

[@PowerAppsTutorial]

Glad it was helpful ☺️