The Ultimate Guide to Lookups in Model-Driven Power Apps and Dataverse
Lisa Crosbie
@lisacrosbieAbout
This channel is all about making AI at work accessible to everyone. I break down these technologies into practical, easy to follow fun tutorials. Here you will find short and long form tutorials and free courses on Copilot Studio, Microsoft Copilot, Power Apps, and other Microsoft technologies, as well as tutorials on how to use AI at work. You'll also find feature updates here every time there is a major event or new announcement from Microsoft, to help you keep up with what's ahead, and what's important and why. I am a five-time Microsoft Most Valuable Professional (MVP) and Microsoft Certified Trainer, with more than a decade of experience consulting with organizations and training business users to get the most out of Microsoft applications at work. Thanks for watching!
Latest Posts
Video Description
This video answers all your questions about how to work with lookups in Dataverse and Model-Driven Power Apps, including - Why can't I add multiple values to a lookup? - What if I want to show something other than the primary name in a lookup? - How can I copy data from a related table? Jump straight to the section you want using the chapters, or come along for the whole ride and become an expert on all the things you can do with lookups. Did I miss your question? Let me know in the comments. Timestamps: 0:00 - Lookups - Your Questions Answered 1:40 - Table relationships in Dataverse 3:45 - Creating lookup columns 8:27 - Primary name and configuring the lookup view 12:29 - Quick View Forms 15:50 - Mapping data from one table to another 22:31 - Filtering - creating dependent lookups 25:56 - Security - stop a user creating a new record in a lookup 26:57 - Importing data - mapping to lookup columns 29:22 - Adding more than one record - choices and many to many tables
Crispy Wing Must-Haves
AI-recommended products based on this video
Portable Air Conditioner, Air Conditioner Portable with 3 Speeds, 3 Mist Settings, 1200ml XL Water Tank, 2~8h Timer, Portable Ac Unit, Small Mini Air Conditioner, Personal Air Cooler Fan for Bedroom
Conair Ceramic Long Barrel XL Curling Iron, 1 ½” Barrel Produces Classic Curls – for use on Medium and Long Hair, Hair Curler
Ninja Air Fryer Pro 5-in-1, 5 QT Capacity, Air Fry, Bake, Roast, Reheat, and Dehydrate, Air Crisp Technology, Nonstick Basket & Crisper Plate, Grey, AF142C
Glass Oil Sprayer for Cooking, 180ml Olive Oil Sprayer Bottle with Brush, Olive Oil Spray Mister, Kitchen Gadgets Accessories for Air Fryer, Canola Oil Spritzer (GREY)
8 Inch Solar Fan with Dual Solar Panels, 25W Powerful Solar Powered Fan for Air Circulation and Cooling in Greenhouse, Pet House, Chicken Coop, Garage, Camping, Install-Free
Cat Calming Treats, 140 Soft Chews to Relieve Anxiety, Stress & Prevent Bites, Perfect for Travel & Veterinary Visits, Soothing Calming Care for Indoor Cats Chicken Flavor 7.41 OZ
Cat Calming Treats, 140 Soft Chews to Relieve Anxiety, Stress & Prevent Bites, Perfect for Travel & Veterinary Visits, Soothing Calming Care for Indoor Cats Chicken Flavor 7.41 OZ
Chicken Balls Cage for Outside, 2025 New 1/3pack Chicken Ball Cage Rolling,Chicken Coop Ball, Mobile Poultry Enclosure Round, Removable Safety Cage, for Chicks Rabbits Birds (Purple-19.68in-3PCs)
Ninja Air Fryer Pro 5-in-1, 5 QT Capacity, Air Fry, Bake, Roast, Reheat, and Dehydrate, Air Crisp Technology, Nonstick Basket & Crisper Plate, Grey, AF142C