Power Apps & Dataverse: Relational Tables Made Easy

⬇️ Get access to all of my FREE courses ⬇️

Darren Neese, Microsoft MVP, PowerApps Tutorial

#DarrenNeese
#PowerAppsTutorial
#Dataverse

[brysonuk]

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

[enjtbpu]

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

[michaeldell]

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

[richardclowes]

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.

[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.

[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?

[eyoborelvis]

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

[johnbrennan]

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

[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.

[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.

[Stjopa-lqcv]

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

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.

[ralphlagos]

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

[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?

[ralphlagos]

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