ycliper

Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
Скачать

Dataverse Tables for Beginners: Build a Library Database in Power Apps! - Ep. 4

Dataverse

PowerApps

MicrosoftPowerPlatform

DatabaseDesign

LowCode

BeginnerTutorial

LibraryManagement

PowerPlatform

LearnPowerPlatform

Microsoft

GUID

ForeignKey

Автор: akshansh sharma

Загружено: 2025-09-21

Просмотров: 79

Описание: Stop guessing how to structure your app's data! This is the ultimate beginner's guide to building a professional, relational database in Dataverse for Power Apps. I'll show you exactly how to create tables, define columns, and establish key relationships for a real-world Library Management System all from scratch.

If you're new to Dataverse or want to solidify your understanding of primary keys, foreign keys, and lookup columns, this video is your complete foundation. By the end, you'll be able to architect robust data models for any canvas app.

🔑 KEY CHAPTERS / TIMESTAMPS:
00:00 - Intro & What We're Building (Library Management System)
01:10 - Navigating to Your Solution in make.powerapps.com
01:30 - The 5 Core Tables We Need (Books, Authors, Publishers, Rented Books, Users)
02:31 - Live Demo: Using dbdiagram.io for Database Design
03:00 - Understanding Primary Keys, Foreign Keys & Relationships (One-to-Many)
04:05 - Creating Our First Table: "Books" & Advanced Settings Explained
06:22 - CRUCIAL: Understanding the "GUID" Primary Key (& Why It's Autogenerated)
07:51 - Creating Columns: "Published On" (Date) & Lookup Columns
09:47 - How to Create Lookup Columns (Author ID, Publisher ID) for Relationships
13:29 - Creating All Remaining Tables (Authors, Publishers, Rented Books, External Users)
15:21 - PRO TIP: Changing the Primary "Name" Column to "Auto-Number" (For Rented Books)
17:10 - LIVE DATA ENTRY: Adding Test Data & Seeing Lookups In Action!
21:46 - How Changes in One Table (Author Name) Automatically Reflect Everywhere
22:50 - Summary & What's Next (Building the Canvas App UI!)

💡 WHAT YOU'LL LEARN:
• The exact process for creating Dataverse tables and columns inside a solution.
• How to plan a data model for a real application (with a free diagram tool).
• The difference between Standard and Virtual tables.
• How to use Lookup columns to create relationships (Foreign Keys) between tables.
• What a GUID is and why it's the primary key for every Dataverse record.
• When to use Auto-Number instead of a text field for the primary name column.
• How to enter data and see relational lookups work instantly.

🚀 FREE RESOURCE:
Database Diagram for this project (dbdiagram.io link): https://dbdiagram.io/d/Library-Manage...
GitHub Repo: https://github.com/akshansh-pp/AS-Pow...

📚 WATCH THE ENTIRE SERIES:
• Part 1:    • Power Apps Environment Setup: Beginners Gu...  
• Part 2:    • Power Apps Basics: Creating Solutions & Pu...  
• Part 3:    • Power Apps Basics: Master the Interface in...  
• Part 4: This Video

👉 Be sure to SUBSCRIBE!    / @akshanshsharma3114  
Turn on notifications so you don't miss the next video where we build the Canvas App UI on top of these tables!

📢 CONNECT WITH ME:
• LinkedIn: www.linkedin.com/in/akshansharma

💬 Did you find the GUID concept clear? What part of Dataverse do you want me to cover next? Let me know in the comments!

#Dataverse #PowerApps #MicrosoftPowerPlatform #DatabaseDesign #LowCode #BeginnerTutorial #LibraryManagement #GUID #ForeignKey #PowerPlatform #Microsoft #LearnPowerPlatform

Не удается загрузить Youtube-плеер. Проверьте блокировку Youtube в вашей сети.
Повторяем попытку...
Dataverse Tables for Beginners: Build a Library Database in Power Apps! - Ep. 4

Поделиться в:

Доступные форматы для скачивания:

Скачать видео

  • Информация по загрузке:

Скачать аудио

Похожие видео

© 2025 ycliper. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]