Welcome to Episode 2 of the App in a Day series! 🎉 In this episode, we dive deep into Microsoft Dataverse—the powerful low-code data platform within Power Apps.
📌 What you’ll learn:
✔️ What is Dataverse?
✔️ Creating and managing Dataverse tables
✔️ Understanding standard vs. custom tables
✔️ Exploring relationships, choices, and business rules
✔️ Connecting Dataverse to a Canvas App
✔️ Building forms and submitting data in Power Apps
By the end of this session, you'll be confident in handling Dataverse inside Power Apps and leveraging it for real-world applications.
Key Takeaways:
✅ Dataverse Fundamentals – Learn how to create, manage, and secure Dataverse tables.
✅ Data Modeling – Understand relationships, primary keys, and choices in Dataverse.
✅ Business Rules – Automate data logic using Dataverse business rules.
✅ Canvas App Integration – Connect Dataverse to a Canvas App and build dynamic forms.
✅ Form Customization – Pre-fill form fields dynamically using Power FX.
✅ Data Submission & Notifications – Save records and provide user feedback in a Power Apps form.
1️⃣ Dataverse Overview:
A low-code relational data platform built for Power Apps.
Offers security, governance, and integrations with other Microsoft services.
2️⃣ Types of Tables in Dataverse:
Standard Tables: Pre-built system tables.
Custom Tables: User-defined tables.
3️⃣ Relationships in Dataverse:
One-to-Many, Many-to-One, and Many-to-Many relationships.
4️⃣ Business Rules in Dataverse:
Used to automate field behavior like setting default values, visibility, and calculations.
Example: Auto-set shipment date as "Approval Date + 14 days".
5️⃣ Data Experience in Dataverse:
Forms – UI for data input.
Views – Structured data representation.
Charts & Dashboards – Visualization tools within Dataverse.
6️⃣ Integrating Dataverse with Power Apps:
Connecting Dataverse tables to Power Apps.
Using SubmitForm() function for data submission.
Chapters with Timestamps:
📌 00:00 - Introduction to "App in a Day" Series
📌 00:29 - What is Dataverse? Overview & Use Cases
📌 02:04 - Dataverse Tables: Standard vs. Custom
📌 06:50 - Understanding Relationships in Dataverse
📌 08:59 - What are Composite Keys in Dataverse?
📌 10:34 - Forms, Views, Charts & Dashboards in Dataverse
📌 14:39 - Business Rules in Dataverse – Explained
📌 18:25 - Creating a Custom Dataverse Table (Hands-on)
📌 24:47 - Adding Custom Columns & Exploring Data Types
📌 33:55 - Formula Columns – Power FX in Dataverse
📌 40:31 - Creating Business Rules for Automation
📌 45:33 - Connecting Dataverse Table to a Canvas App
📌 52:48 - Setting Default Values Using Power FX
📌 01:01:43 - Submitting Forms & Storing Data in Dataverse
📌 01:06:49 - Success Screen & Confirmation Message
📌 01:12:42 - Final Testing & Demo
📌 01:14:45 - Closing Thoughts & Next Episode Preview
Download the Excel File Sample: https://github.com/MicrosoftDocs/mslearn-developer-tools-power-platform/raw/master/in-a-day/AIAD/AppinADayStudentFiles.zip
Playlist for Power Apps Training Program: https://www.youtube.com/playlist?list=PLib8Q64STW-tLkyHqf_U4Gu7CWDz1E7kE
Key Learning Points:
Introduction to Power Apps:
Explanation of Power Apps features and tools, focusing on Canvas Apps for beginners.
Overview of the App in a Day crash course and its practical focus.
Agenda and Learning Path:
Part 1: Build your first Canvas App using Excel as a data source. https://youtu.be/44K483oblug Part 2: Extend the app with Dataverse as a data source and learn Dataverse features. https://youtu.be/Mnvq0F6U3gU
Part 3: Develop a Model-Driven App based on the same example.
https://youtu.be/Mnvq0F6U3gU
Part 4: Integrate Power Apps with Power Automate.
https://youtu.be/q1EBLMu7YmI
Practical Demonstration:
Chapters:
FO L L O W M E O N S O C I A L M E D I A
================================================================================
Follow my other channel for short content: @DigitalDhruvin
Follow me on Instagram: https://www.instagram.com/powerplatformguy/
Looking for a Consultancy? Connect Here! https://powerplatformtrainings.com/contact/
Follow me on all social Media Handles: https://linktr.ee/dhruvin.shah
#PowerApps #Dataverse #LowCode #MicrosoftPowerPlatform #CanvasApps #BusinessApps #PowerPlatform #Microsoft365 #PowerAutomate #AppDevelopment