- Module 1: Dataverse lets you securely store and manage data that's used by business applications. Standard and custom tables within Dataverse provide a secure and cloud-based storage option for your data.
This module explains how to:
- Create tables with Dataverse
- Import data into a Dataverse database
- Module 2: Learn how to create and manage table columns in Dataverse.
In this module, you will:
- Learn what a column is in Dataverse.
- Learn about the types of columns that are available in Dataverse.
- Add a column to a table.
- Learn what a primary name column is in Dataverse.
- Identify restrictions that are associated with columns.
- Create an auto-numbering column.
- Create an alternate key.
- Module 3: Learn the basics of Power Apps and how you can use it in your organization.
In this module, you will:
- Explore how Power Apps can make your business more efficient.
- Learn how to use different technologies to perform different tasks in Power Apps.
- Learn about the different ways to build an app in Power Apps.
- Create your first app from data in an Excel workbook.
- Module 4: Do you want to build a better UI for app users? This module helps you do that using themes, icons, images, personalization, different form factors, and controls.
In this module, you will:
- Understand the basics of building the UI through themes, icons, control customization, and images.
- Use personalization in a canvas app
- Understand the differences between the Tablet and Mobile form factors
- Module 5: Learn how to create simple flows to make your life easier.
In this module, you will:
- Create a flow that automatically saves email attachments
- Learn how to create a button flow to send yourself a reminder
- Module 6: Create your own data model, app, and flow to support a scenario for a fictional company. You'll be provided with high-level specifications on the custom tables, columns, canvas app, and flows needed to complete this project.
In this module, you'll demonstrate your ability to:
- Customize a Dataverse database to meet business requirements
- Create a Power Apps canvas app based on provided specifications
- Create a Power Automate flow based on provided specifications
Overview
Syllabus
- Module 1: Module 1: Create tables in Dataverse
- Introduction to Microsoft Dataverse
- Table characteristics
- Exercise - Create a Microsoft Dataverse table
- Exercise - Import data into your Microsoft Dataverse database
- Table relationships
- Exercise - Create table relationships
- Dataverse logic and security
- Exercise - Create a custom table and import data
- Dataverse auditing
- Dual-write vs. virtual tables
- Check your knowledge
- Summary
- Module 2: Module 2: 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 columns in a table
- Create an auto numbering column
- Create an alternate key
- Exercises
- Check your knowledge
- Summary
- Module 3: Module 3: Get started with Power Apps canvas apps
- Introduction to Power Apps
- Power Apps building blocks
- Exercise - Create your first app in Power Apps
- Exercise - Create an app from Excel using Copilot
- Ways to build Power Apps
- Power Apps related technologies
- Additional Power Apps related technologies
- Designing a Power Apps app
- Check your knowledge
- Summary
- Module 4: Module 4: How to build the UI in a canvas app in Power Apps
- Use themes to quickly change the appearance of your app
- Branding a control
- Icons
- Images
- Personalization
- Using the tablet or phone form factors
- Exercise - Create UI for a new canvas app
- Check your knowledge
- Summary
- Module 5: Module 5: 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
- Check your knowledge
- Summary
- Module 6: Module 6: Challenge Project - Build a booking requests app with Power Apps and Power Automate
- Introduction
- Prepare
- Exercise - Build a data model and create a canvas app
- Exercise - Build Power Automate flows to send automated emails
- Knowledge check
- Summary