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