Power Apps How to do Inner Join between Data Verse Tables Dataflows

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=BPkv7S11Zp8

Dataverse Lookup columns are how you create a proper relationship in your dataverse table. In this video, you will learn what are relationships, why Many-to-one, One-to-many, and Many-to-many 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 Many-to-one, One-to-many, and Many-to-many. N:1, 1:N, N:N • 12:58 Brief overview view of a Many-to-many 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

#############################

New on site