How to Set Up Relationships in Power Apps

Find out how to create your table or list relationships in SharePoint quickly and easily with a simple and easy to follow example. We will work with SharePoint Lists. We'll do this by using the Power Platform and SharePoint list relationships.

Darren Neese, Microsoft MVP, PowerApps Tutorial

#DarrenNeese
#PowerAppsTutorial
#LowCode

[RTPgardenguy]

Very helpful, thank you for taking the time to do this!

[markdelbiondi]

I knew all of this but it was well explained! Great job

[anelmorales]

Darren this is extremely helpful! I will use this at work :P Thanks!

[NickyNose]

Never thought to use Patch, I set a variable on my input form Item property and call it from the action form custom ID as the default value using the If statement. This works well but Patch seems to be easier and quicker and wouldn't have to use a form. I will give this a try. Love the flexibility of PowerApps! Thanks Darren!

[iyleess]

Amazing...what took me two days took this guy 12 minutes. Love it

[nonoobott]

This is so brilliant. Thanks so much for sharing. I'm learning a lot from your Channel

[jayong]

Thanks. Exactly what I was looking for. =)

[leodeguzman]

this is exactly what is was looking for.

[rfpfybf]

Excellent Video - very understandable for begginners like me.

[faucillon]

SPEED, awesom. Approach, awesome. Got my like and heck why not got my sub too

[achuthavishnu]

Amazing Video, thank you so much .. this was the solution i was looking for. One Additional question, could we edit the Car name entered against an existing customer in the same view ?

[charlesdawnbeltran]

Very helpful video.
Do you have a video as well on how to download the child table into Excel and it also contains some columns from the parent table?

[levin]

Hi Thanks for the great video !! Do you have an idea how I can do it if the customer does not exist yet. So everything in the same patch statment. Or how could you do that?

[jdkarns]

Great video! Fantastic information. Thanks for that. Question: When you made the Cars List you made a column CustomerID and made it a "Number". Do you have to specify the number to Force Unique Values? How did a number get added each time you added a persons' choice of car?

[gkz]

Thank your sharing, question: if this two list require a SharePoint web level edit, example in SharePoint list the Cars input a new record, because it is not a lookup column relation, how make it easy to input a customer ID?

[lewstrn]

Great explanation, and why is the customer id column is of datatype number rather than a lookup.

[gatorbrown]

hey I just want to know if you already had data entered into a list how would you go about doing this process

[khakkik]

Hi there, how do you handle permissions for the SharePoint lists themselves? I assume all users who would use the app would have to have edit rights for it to work - I've been asked to build an app for everyone at my company to use but I'd like to make sure people can't find and edit the lists themselves. Is there a way to make a Powerapp execute functions as a service account that has higher permissions and not let everyone using the app able to access the "back end" so to speak?

[TheMKTube]

Great video! Does the Title field in the sub-list HAVE to be unique? I wish there was a video about dealing with this annoying title field! lol

[princeofchaos]

how you would do that if you have 3 depth table, Brand, sectors and subsectors. and the relation is 1 table N-N with Brand_id, Sectors_id, and Subsectors_id