Explore secure data management with Dataverse, learning how to create tables and import data into a cloud-based storage system.
This module explains how to:
- Create tables with Dataverse
- Import data into a Dataverse database
Learn how to create and manage table columns in Dataverse.
This module explains:
- What a column is in Dataverse.
- The types of columns that are available in Dataverse.
- How to add a column to a table.
- What a primary name column is in Dataverse.
- How to identify restrictions that are associated with columns.
- How to create an auto-numbering column.
- How to create an alternate key.
Learn how Power Apps can make your business more efficient and streamline your processes.
This module explains how to:
- Explore how Power Apps can make your business more efficient.
- Use different technologies to perform different tasks in Power Apps.
- Build an app in Power Apps in different ways.
- Create your first app from data in an Excel workbook.
In this module, learners will learn how to build UI for their app including theming, icons, images, personalization, 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.
- Learn how to preview and modify an app to fit different form factors.
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.
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

Syllabus

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
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
- Primary column
- Restrictions that apply to columns in a table
- Create an auto numbering column
- Create an alternate key
- Exercises
- Check your knowledge
- Summary
Get started with Power Apps canvas apps
- Introduction to Power Apps
- Start Power Apps
- Exercise - Create your first app in Power Apps
- Power Apps data sources
- Exercise - Create an app from Excel using Copilot
- Use Power Apps with Power Automate and Power BI
- Designing a Power Apps app
- Check your knowledge
- Summary
How to build the User Interface in a canvas app in Power Apps
- Use themes to quickly change the appearance of your app
- Brand a control
- Icons
- Images
- Personalization
- Build for phones or tablets
- Exercise - Create and adjust UI for a new canvas app
- Module assessment
- Summary
Get started with Power Automate
- Introducing Power Automate
- Create your first flow
- Exercise - Create recurring flows
- Exercise - Monitor incoming emails
- Exercise - Share flows
- Troubleshoot flows
- Module assessment
- Summary
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
- Module assessment
- Summary