Model-Driven Apps with Microsoft Dataverse in Power Apps

Introduction to the Microsoft Power Platform

The Power Platform is a powerful combination of tools that allow you to build business applications to store, process and share your data. This chapter will show you how the Power Platform is built, explain the licensing system and give you an overview of what is possible.

• The past: Dynamics CRM
• From Dynamics CRM to Dynamics 365 for Customer Engagement, The Common Data Model and Model-Driven Apps
• Overview of the Microsoft Power Platform
• Introduction to Microsoft Dataverse
• The Common Data Model
• Dynamics 365 Sales, Customer Services, ... as Model-Driven Apps on Microsoft Dataverse

Overview of Model-Driven Apps/Dynamics 365

Before Model-Driven Apps can be created, a environment with a Microsoft Dataverse database must be provisioned. This chapter introduces the concept of an environment and what role it plays in the creating, manage and deployment of Model-Driven Apps. Students are also provided with a quick overview of the look and feel that every Model-Driven App has and the common functionality of Model-Driven Apps.

• Creating and Working with Environments
• The Relationship between Environments and Microsoft Dataverse
• Navigating and Using a Model-Driven App

Working with Solutions

Solutions are used by customizers and developers to package related customizations together so that they can be managed and deployed as a single unit. We will see what components can be added to a solution and how they are essentially the building blocks of your environment.

• Introduction to Customizing Model-Driven Apps
• Working with Publishers and Solutions
• Difference between Managed and Unmanaged Solutions
• Adding Components to your Solutions
• Working with Managed Properties
• Importing and Exporting Solutions
• Versioning Solutions
• LAB: Working with Solutions

Creating Model-Driven Apps

Model-Driven Apps are the building block of any business solution. For instance, we could create our own "event management" app. The app will group together everything our user needs from Microsoft Dataverse and the components we have built.

• Concepts of a Model-Driven App
• The Structure of a Site Map
• Creating a Site Map for an App
• Creating Apps with the App Designer
• Navigating between Apps
• Managing Apps in Solutions
• Preview: the Modern App Designer
• Introducing XrmToolBox
• LAB: Creating Model-Driven Apps

Creating and Customizing Tables

Table are used to model and store business data in a Model-Driven Apps. Conceptually they are like tables in a relational database. Microsoft Dataverse defines quite some build-in tables like contact, account,... but almost always customizers will have to create new tables. In this chapter you will learn all aspects of how to create new tables.

• Creating and Configuring tables in Microsoft Dataverse
• The Default Table Columns
• Creating Custom Activity Tables
• LAB: Creating and Configuring Tables

Managing Relationships

Just like accounts and contacts have relationships in Microsoft Dataverse, we can provide relationships for our own tables. You will learn what types of relationships are possible and how to configure them.

• Plan, Create, and Configure Table Relationships
• Creating and Using Relationships - 1:N, N:N
• Connections and Connection Roles
• Defining Self-Referential Relationships
• Defining Hierarchy Visualizations
• Creating Polymorphic or Multi-Table Relationships
• LAB: Managing Relationships

Creating and Customizing Columns

Columns define the individual data items that can be used to store data in a table. Columns are sometimes also called fields or attributes

• Adding Custom Columns to Tables
• Supported Column Data Types
• Working with File and Image Data Types
• Working with Lookups
• Preview: Creating Multi-Table or Polymorphic Lookups
• The Choice and Choices Data Types
• Using the Status and Status Reason Columns
• Defining Alternate Keys for a Table
• Importing Rows in Tables using Dataflows
• Aggregating Data with Rollup Columns
• Calculate Data based on other Column with Calculated Columns
• Creating Formula Columns using PowerFX
• LAB: Creating Columns

Customizing Forms

Forms are used to visualize table rows. In this module you will learn about the different Form Types and how to create or customize forms using the Form Designer.

• Define the Structure of Forms
• How to Add, Remove or Modify the Components of a Form using the Form Designer
• Placing Image Column on Forms
• Configure and Use Quick Create, Quick View and Card Forms
• Working with Custom Components
• Embedding Canvas Apps in a Form
• LAB: Creating and Configuring Forms

Business Rules

Business rules essentially automate control logic on tables, without the need for development. Think of making columns required depending on the value of another column for instance.

• What are Business Rules?
• Create and Apply Business Rules
• Defining the Scope of Business Rules
• Business Rules Limitations
• LAB: Working with Business Rules

Creating and Using Views

Offer the data needed for different scenario's with views. With a view, we can either look at all table rows, or we could apply some filtering, sorting, etc.

• Examine the Different Types of System, Public and Personal Views
• Create New Public Views and Modify Existing Views
• Configure Quick Find, Advanced Find and Associated Views
• Configure Views with Custom Controls like the Editable Grid, Calendar Control,...
• LAB: Creating and Configuring Views

Reporting in Model-Driven Apps

Reporting is essential when working with data. In this module you will learn how you can create Charts and Dashboards. This module also shows how you can integrate Microsoft Dataverse and Model-driven apps with Power BI

• Build Interactive Charts to show in Views or on Dashboards
• Classic Dashboards showing Charts, Data or web pages
• Interactive Dashboards with dynamic sorting and filtering
• Working with the Tabular Data Stream (TDS) endpoint
• Using Power BI Desktop with data stored in Microsoft Dataverse
• Creating embedded Power BI Dashboards
• Embedding a Power BI report in a Table Form
• LAB: Reporting in model-driven apps

Creating Business Process Flows

Business process flows in Dataverse are guided workflows that streamline and standardize processes within an organization by providing a visual representation of the steps needed to complete a task. They ensure consistency and compliance by guiding users through predefined stages and actions.

• What is a Business Process Flow
• Creating a Business Process Flow
• Using a Business Process Flow
• LAB: Creating a Business Process Flow

Securing Model-Driven Apps

This module teaches how you can implement a robust security model in Model-Driven Apps using Business Units, Security Roles, Users and Teams.

• Building a Security Model
• Business Units and their Role in Security Modeling
• Define Privileges and Access Levels in Security Roles
• Creating and Maintaining Users
• Team Management
• LAB: Implementing Security in Microsoft Dataverse

Power Platform Automation

Power Automate gives you the ability to automate organizational processes. As a part of the Microsoft Power Platform, it integrates seamlessly with the Model-Driven Apps and Microsoft Dataverse.

• Power Automate Overview
• Trigger a Flow Based on a Create, Update or Delete of an Table Row
• Consuming Microsoft Dataverse Data Inside a Power Automate Flow
• Available Actions with the Microsoft Dataverse Connector