Dataverse Lookup columns are how you create a proper relationship in your dataverse table. In this video, you will learn what are relationships, why Manytoone, Onetomany, and Manytomany aren't so scary, and how to create the relationship. With your table structure in place we then go to Power Apps and update the relationship with Forms and Patch. Finally, we use edit data in Excel as the final tool to maintain these powerful relationships. And don't worry we also talk about viewing the data with polymorphic relationships. Much cooler than it sounds. Also, because most people come at this with a SharePoint background we do some compare and contrast between the two platforms.

Power Apps Consulting and training at https://www.PowerApps911.com

0:00 It starts
1:58 Create a Dataverse table to use as our lookup table
4:11 Use edit data in excel to quickly populate the new table
5:43 Add a PowerApps Dataverse Lookup column to the table and connect it to the new table
6:41 Explanation of a lookup or relationship between two tables
8:01 Dataverse Add Relationship types Manytoone, Onetomany, and Manytomany. N:1, 1:N, N:N
12:58 Brief overview view of a Manytomany relationship.
14:56 Create a PowerApps Canvas app to explore the relationship from the app side
16:30 Use a form to update a dataverse lookup column from power apps
17:54 Configure the gallery to display values from a lookup column via the polymorphic lookups
19:52 Use the Patch function to create a record with a lookup column via a dropdown or a lookup function
24:25 Using the GUID primary key for the lookup
25:49 Overview of the Relate function and Unrelate function
26:33 Filtering on the Dataverse Lookup column
27:38 Use Edit data in Excel to modify a Lookup column