Power Apps and Power Automate: Building Business Solutions

Review of Microsoft Power Platform
What is Microsoft Power Platform?
The business value of Microsoft Power Platform
Data Connectors
Data loss prevention, compliance, privacy, accessibility

Create tables in Dataverse
Introduction to Microsoft Dataverse
Table characteristics
Dual-write vs virtual tables
Dataverse auditing
Exercise: Create a Microsoft Dataverse table
Import data into your Microsoft Dataverse database
Exercise: Create a custom table and import data

Module 3: Manage tables in Dataverse
Identify tables and table types in Dataverse
Create a custom table
Enable attachments within a table
Licensing requirements for each table type
Lab: Create a new custom table and enable attachments

Module 4: Create and manage columns within a table in Dataverse
Define columns in Microsoft Dataverse
Column types in Microsoft Dataverse
Add a column to a table
Create a primary name column
Restrictions that apply to the columns in a table
Create a numbering column
Create an alternate key
Exercises

Create a relationship between tables in Dataverse
Relate one or more tables
Relationship types that are available in Microsoft Dataverse
Create a one-to-many relationship between tables
Create a many-to-many relationship between tables
Edit or delete relationships
Exercise - Create two tables and relate them by using a one-to-many relationship

Working with choices in Dataverse
Define a choice column
Standard choices column
Lab: Create a new choice or modify an existing choice

Get started with security roles in Dataverse
Introduction to environment roles
Understand environment roles
Adding or disabling an environment user
Understand security concepts in Dataverse
Understand user security roles and security role defaults
Exercise - Create a custom role
Check the roles that a user belongs to
Configure Dataverse teams for security
Configure Dataverse group teams for security

Get started with model-driven apps in Power Apps
Introducing model-driven apps
Building blocks of model-driven apps
Design model-driven apps
Exercise
Exercise - Control security when sharing model-driven apps
Incorporate business process flows
Exercise - Create a model-driven app

Configure forms, charts, and dashboards in model-driven apps
Forms overview
Form elements
Configure multiple forms
Use specialized form components
Configure views overview
Configure grids
Use specialty views
Configure charts overview
Dashboards overview
Use interactive streams and tiles

Get started with Power Automate
Introducing Power Automate
Exercise - Create your first flow
Exercise - Create recurring flows
Exercise - Monitor incoming emails
Exercise - Share flows
Troubleshoot flows

Use Dataverse triggers and actions in Power Automate
Introduction
Dataverse triggers
Use triggers
Work with Dataverse actions

Extend Dataverse with Power Automate
Introduction
Set up a flow and configure its trigger
Email Dataverse record
Add to-do items
Test and run your flow

Introduction to expressions in Power Automate
Introduction to expressions
Get started with expressions
Notes make things easier
Types of functions
Write complex expressions
Exercise - Creating a manual flow and using expressions