Microsoft Power Platform Developer

How to build your first model-driven app with Dataverse

This module will focus on the building blocks of Dataverse and model-driven apps. These key components will help you build quick business apps in your organization.

• Introduction to Dataverse
• Introduction to model-driven apps
• Model-driven apps, powered by Microsoft Dataverse
• Explore sample apps
• Check your knowledge

Get started with model-driven apps in Power Apps

Model-driven app design is an approach that focuses on quickly adding components to your apps. These components include dashboards, forms, views, and charts. With little to no code, you can make apps that are simple or complex. Unlike in canvas app development, where the designer has total control over the app layout, much of the layout in model-driven apps is determined by the components you add. In other words, the emphasis is more on quickly viewing your business data and making decisions than on intricate app design.

• Introducing model-driven apps
• Components 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
• Check your knowledge

Manage tables in Dataverse

Dataverse tables are similar to tables in a database. Every instance of a Dataverse database includes a base set of tables that provide structure for data that is commonly used by business applications.

• 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
• Check your knowledge

Create and manage columns within a table in Dataverse

Learn how to create and manage table columns in Dataverse.

• Define columns in Microsoft Dataverse
• Column types in Microsoft Dataverse
• Add a column to a table
• Primary name column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key
• Exercises
• Check your knowledge

Working with choices in Dataverse

Do you want to create standardized choice lists that you can use across all of your Power Apps? This module will show you how to create new or use standard choice lists called choices in Dataverse.

• Define choice column
• Choice columns
• Standard choices column
• Lab - Create a new choice or modify an existing choice
• Check your knowledge

Create a relationship between tables in Dataverse

Do you need to create relationships between tables? This module will show how and why you can separate data into tables and how to relate between tables to build complex and robust business solutions. It will also explain the different kinds of relationships that you can define between tables in Dataverse.

• Relate one or more tables - Introduction
• 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
• Check your knowledge

Define and create business rules in Dataverse

The ability to build business rules that ensure consistent business logic whatever app is accessing that data set is imperative to a successful business operation. This module will show you how you can build business rules that are triggered anytime they're used within Dataverse.

• Define business rules - Introduction
• Define the components of a business rule
• Create a business rule
• Exercise - Create a business rule
• Check your knowledge

Create and define calculation or rollup columns in Dataverse

Do you want to use rollup or calculation columns? This module shows you how to build calculations or rollups that are defined and triggered within the data in Dataverse, regardless of the app that accesses that data set.

• Introduction to roll up columns
• Create a rollup column
• Introduction to calculated columns
• Create a calculation column
• Exercise - Create a rollup column
• Exercise - Create a calculated column
• Introduction to Power Fx formula columns
• Check your knowledge

Get started with security roles in Dataverse

Learn how you can set permissions to limit access to an environment, or limit which users can view, edit, or delete data in an environment within 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
• Check your knowledge

Get started with Power Apps canvas apps

Learn how Power Apps can make your business more efficient and streamline your processes.

• 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

Customize a canvas app in Power Apps

This module takes the learner to the next level in app development by teaching how to customize the app by adding controls, images, and logic.

• Improve your app by making basic customizations
• Explore controls and screens in canvas apps
• Exercise - Introduction to formulas in canvas apps
• Exercise - Create basic screen navigation for a canvas app
• Check your knowledge

Manage apps in Power Apps

Manage app versions, app sharing, and environments in Power Apps.

• Exercise - Manage app versions in Power Apps
• Exercise - Share apps in Power Apps
• Exercise - Understand environments in Power Apps
• Power Apps review
• Check your knowledge

Navigation in a canvas app in Power Apps

In this module, learners do an in-depth exploration of navigation in Power Apps.

• Understanding navigation
• The Navigate and Back functions
• More ways to use the Navigate function
• Exercise - App navigation practice
• Check your knowledge

How to build the User Interface in a canvas app in Power Apps

In this module, learners will learn how to build UI for their app including theming, icons, images, personalization, form factors and controls.

• 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
• Check your knowledge

Use and understand Controls in a canvas app in Power Apps

Controls help create a better experience for the user and collect the appropriate data. This module helps you understand and use Controls.

• Introduction to controls
• Core properties of controls
• Entering and displaying data with text controls
• Additional controls for enhancing your app's usability
• Media
• Modern controls
• Work with component libraries
• Lab - Create a canvas app with unique controls
• Exercise - Upload file to SharePoint document library
• Check your knowledge

Document and test your Power Apps application

Learn how to document and test a Power Apps application.

• Create test plans
• User interface testing
• Performance optimization
• Diagnostics and analytics
• Documentation and the customer
• Check your knowledge

Use imperative development techniques for canvas apps in Power Apps

Learn how to use imperative vs. declarative development.

• Imperative versus declarative development
• The three types of variables in Power Apps
• Global variables
• Contextual variables
• Collections
• Additional variable concepts
• Exercise - Using the variables and collections
• Check your knowledge

Create formulas that use tables, records, and collections in a canvas app in Power Apps

Do you have need for complex formulas in your app? This module can help you write those formulas.

• Formulas that process multiple records
• Math operations on tables
• Combine and separate records
• The ForAll function
• Lab - Using the ForAll function in a gallery
• Check your knowledge

Perform custom updates in a Power Apps canvas app

With some Power Apps canvas apps, a form isn't the solution. This module focuses on how to perform custom updates when your data isn't in a form.

• Sometimes you need something more than forms
• Use the Patch function to create and edit records
• Delete records from data sources and collections
• Use the Patch function to update a Gallery
• Check your knowledge

Complete testing and performance checks in a Power Apps canvas app

Do you want to test your app and improve its performance? This module helps you understand how to test an app and improve performance.

• The importance of thinking about performance
• Improve performance with data sources
• Testing and troubleshooting your app
• Exercise - Use the Concurrent function to test performance
• Check your knowledge

Work with relational data in a Power Apps canvas app

Learn how to work with relational data in Power Apps canvas apps.

• What is relational data?
• Work with relationships in Power Apps
• Exercise - Work with relational data
• Microsoft Dataverse for apps makes relationships even easier
• Check your knowledge

Work with data source limits (delegation limits) in a Power Apps canvas app

Delegate data with Power Apps.

• Delegation overview
• Functions, predicates, and data sources combine to determine delegation
• Delegation warnings, limits, and non-delegable functions
• Check your knowledge

Connect to other data in a Power Apps canvas app

Learn how to connect to other data in Power Apps canvas app.

• Overview of the different data sources
• Work with action data
• Power Automate is a companion to Power Apps
• Check your knowledge

Use custom connectors in a Power Apps canvas app

Learn how to use custom connectors in a Power Apps canvas app.

• Overview of custom connectors
• Overview of the custom connector lifecycle
• Build a custom connector for existing API
• Check your knowledge

Get started with Power Automate

Explore Power Automate, an online service automating actions across apps and services. Learn to create flows for reminders & saving email attachments.

• Introducing Power Automate
• Create your first flow
• Exercise - Create recurring flows
• Exercise - Monitor incoming emails
• Exercise - Share flows
• Troubleshoot flows
• Check your knowledge

Build approval flows with Power Automate

Learn how to build approval flows with Power Automate.

• Provide solutions to real-world scenarios.
• Exercise - Build an approval request
• Exercise - Create a business process flow
• Exercise - Create a business process flow that has conditions
• Check your knowledge

Introduction to expressions in Power Automate

Learn how to write 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
• Check your knowledge

Introduction to Microsoft Power Platform developer resources

The goal of this module is to give a broad-scoped overview of the developer experience as it relates to Microsoft Power Platform. It will cover a high-level introduction how the ecosystem is represented, with the intended audience being a software developer with limited experience in working with Microsoft Power Platform.

• Introduction to Microsoft Power Platform for developers
• Overview of Dataverse and the Common Data Model
• Extending Power Platform with Azure
• Power Platform environments
• Exercise - Prepare development environment
• Check your knowledge

Use developer tools to extend Power Platform

This module will focus on the available developer tools that can help you perform development activities with Power Platform.

• Introduction to developer Power Platform tooling
• Exercise - Use the Power Apps CLI
• Solutions overview
• Deploy apps with Package Deployer
• Exercise - Install and use developer tools
• Check your knowledge

Introduction to extending Power Platform

This module will focus on the underlying solution architecture from a technical perspective and what extensibility options exist. It will also cover the ever-important element of Microsoft Power Platform development, which is the decision-making process of determining when to use configuration versus code.

• User experience extensibility
• Dataverse extensibility
• Exercise - Create a custom API
• Determine when to configure or when to code
• Check your knowledge

Introduction to Dataverse for developers

The goal of this module is to give an introductory overview of Microsoft Power Platform SDKs that are available from Microsoft via NuGet.

• Introduction to developing with Microsoft Dataverse
• Microsoft Dataverse extensibility model
• Event framework
• Check your knowledge

Extend plug-ins in Power Platform

The purpose of this module is to provide an in-depth overview of plug-ins as it relates to Microsoft Power Platform development. This module will review how and when plug-ins are implemented, how they're registered and deployed, and the various configuration options that are available during plug-in registration.

• Plug-ins usage scenarios
• Plug-in execution context
• Exercise - Write your first plug-in
• Check your knowledge

Perform common actions with client script in Power Platform

The goal of this module is to review how to achieve common user experience automation procedures through Client Script. This module is intended to serve as a practical guide for how to solve real-world scenarios that are frequently encountered during Microsoft Power Platform implementations.

• Introduction to client-side scripting
• Upload scripts
• Event handlers
• Context objects
• Client scripting common tasks
• Exercise - Use client script to hide a form section
• Check your knowledge

Automate business process flows with client script

This module focuses on educating developers on how to perform common techniques in regard to automating business processes using client scripting, along with explaining the context of when these scenarios might be applied.

• Introduction to conducting global operations with the client API Xrm object
• Client scripting best practices
• Debugging client script
• Exercise - Use table data from client script
• Check your knowledge

Get started with Power Apps component framework

Learn how to get started with Microsoft Power Apps component framework.

• Introduction to Power Apps component framework
• Power Apps component framework architecture
• Power Apps component tooling
• Component manifest
• Demo of the Power Apps code component
• Check your knowledge

Build a Power Apps component

Learn how to build a custom Power Apps component, create a code component solution package, and then test and debug a code component.

• Introduction to creating a code component
• Create a code component solution package
• Test and debug code components
• Check your knowledge

Use advanced features with Power Apps component framework

Learn about Power Apps component framework advanced articles.

• Introduction to using React within a Power Apps component
• Use the formatting API in a Power Apps component
• Use the Microsoft Dataverse web API in a Power Apps component
• Write a pop-up Power Apps component
• Introduction to using React within a Power Apps component
• Check your knowledge

Access Dataverse in Power Pages websites

Learn about the several techniques and methods for displaying and interacting with Dataverse data on Power Pages websites.

• Use lists to display multiple Dataverse records
• Use forms to interact with Dataverse data
• Exercise - Use the list and form components
• Check your knowledge

Extend Power Pages websites

Extend website functionality by using software development and deploying Power Pages websites with ALM techniques.

• Power Pages website life cycle management
• Extend with scripts
• Advanced CSS
• Advanced client-side development
• Exercise - Add advanced client-side functionality
• Check your knowledge

Build custom Power Pages web templates

Find out how to embed custom CSS and JavaScript into your Power Pages templates.

• Create web templates
• Web templates as API
• Exercise - Create an extendable web template
• Check your knowledge

Work with Dataverse Web API

Discover how to work with the Dataverse Web API, including authorizing with OAuth and using OData to query data.

• Introduction to the Microsoft Dataverse Web API
• Insomnia
• Authenticate against Microsoft Dataverse using OAuth
• Use OData to query data
• Use FetchXML to query data
• Call Power Automate actions from the Web API
• Use the Web API to impersonate another user
• Track entity data changes with change tracking and the Web API
• Check your knowledge

Integrate Dataverse Azure solutions

Gain an in-depth overview of options available within Dataverse to integrate data and events to Azure.

• Microsoft Dataverse Azure Solutions overview
• Expose Microsoft Dataverse data to Azure Service Bus
• Write a Service Bus Event Listener that consumes Microsoft Dataverse messages
• Publish Microsoft Dataverse events with webhooks
• Write an Azure Function that processes Microsoft Dataverse events
• Check your knowledge