Course Outline
How to build your first model-driven app with Dataverse
- Discover the value and key features of Dataverse
- Learn about the value and key features of model-driven apps
- Explore sample model-driven template apps
Get started with model-driven apps in Power Apps
- Learn about model-driven app design
- Create a model-driven app
- Lab: Control security when sharing model-driven apps
- Lab: Create a model-driven app
Manage tables in Dataverse
- Tables in Dataverse
- Types of tables that are available in Dataverse
- Creating a custom table
- Enabling attachments within a table
- Which licensing requirements to apply to use each type of table
- Lab: Create a new custom table and enable attachments
Create and manage columns within a table in Dataverse
- 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
Working with choices in Dataverse
- Learn about choices
- Explore the standard choices
- Create a new choice or modify an existing one
- Lab: Create a new choice or modify an existing choice
Create a relationship between tables in Dataverse
- Why you should segment data that is used by your solutions into many tables
- Why you need to relate one table to another
- How to build relationships between tables
- How to select the proper relationship type when you're building solutions with Dataverse
- Lab: Create two tables and relate them by using a one-to-many
Define and create business rules in Dataverse
- Define business rules in Dataverse
- Create and manage business rules in Dataverse
- Lab: Create a business rule
Get started with security roles in Dataverse
- Learn about security roles and apply them to users in an environment
- Learn how to add users to an environment
- Understand security concepts in Dataverse
- Identify default security roles
- Create a custom role
- Create a custom security role and assign it to entities and users
- Learn how to configure Dataverse teams for security
- Learn how to configure Dataverse group teams for security
- Lab: Create a custom role
Get started with Power Apps canvas apps
- 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
- Lab: Create your first app in Power Apps
Customize a canvas app in Power Apps
- Change the data that a control shows
- Change the order in which fields appear
- Change the control with which a user provides information
- Explore controls on each screen of an app
- Format a number as a price
- Color prices based on their values
- Explore formulas in a generated app
- Lab: Get started with functions in Power Apps
Manage apps in Power Apps
- Learn how to view and restore app versions
- Explore how to share an app, including permissions and notifications
- Learn about what environments are, how to create them, and how to manage security
Navigation in a canvas app in Power Apps
- Understand how navigation works in a canvas app
- Use the Navigate and Back functions
- Understand the different ways these functions can be invoked
- Lab: Create navigation functions
How to build the UI in a canvas app in Power Apps
- 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
- Lab: Create UI for a new canvas app
Use and understand Controls in a canvas app in Power Apps
- Understand how to use controls in a canvas app
- Use the different types of controls
- Understand how Galleries and Forms related to controls
- Lab: Create a canvas app with unique controls
Document and test your Power Apps application
- Learn about the different types of test plans and the components of a good test plan
- Identify and discuss optimization tools and performance tuning
- Learn about the benefits of documenting your application
Use imperative development techniques for canvas apps in Power Apps
- Understand imperative vs. declarative development
- Understand the variables in Power Apps
- Understand when to utilize each of the three different types of variables
- Lab: Using the variables and collections
Create formulas that use tables, records, and collections in a canvas app in Power Apps
- Use the Concat function to combine text from multiple records
- Perform math operations on data in a table
Perform custom updates in a Power Apps canvas app
- Use the Patch function to update your data
- Understand how the Defaults function is used to create new records with Patch
- Utilize the Remove and RemoveIf functions to delete records
- Determine whether to use Clear and Collect or ClearCollect in their scenario
Complete testing and performance checks in a Power Apps canvas app
- Use best practices to improve the performance of your app
Work with relational data in a Power Apps canvas app
- Understand relational data
- Use relational data to improve an app user's experience in Power Apps
- Understand how to use relational data in Microsoft Dataverse
- Lab: Work with relational data
Work with data source limits (delegation limits) in a Power Apps canvas app
- Understand the different limits of different data sources
- Understand how functions, predicates, and operators all play roles in the limits
- Use this new understanding to choose the best data source for an app
Connect to other data in a Power Apps canvas app
- Integrate user information and user-profile information into a canvas app
Use custom connectors in a Power Apps canvas app
- Understand custom connectors and the basics of how to build one
Get started with Power Automate
- Create a flow that automatically saves email attachments
- Learn how to create a button flow to send yourself a reminder
- Lab: Create your first flow
- Lab: Create recurring flows
- Lab: Monitor incoming emails
- Lab: Share flows
Build approval flows with Power Automate
- Build a flow that runs at recurring time intervals
- Create a business process flow with conditions
Introduction to expressions in Power Automate
- Use one or more functions to create expressions
- Use functions to retrieve data, change data, evaluate data, and more
Introduction to Microsoft Power Platform developer resources
- Explain what solution components exist within the Microsoft Power Platform
- Explain key components of Microsoft Dataverse and the Common Data Model
- Explain what Azure solution elements relate to the Microsoft Power Platform
- Explain what AI Solutions exist as it relates to the Microsoft Power Platform
- Navigate the Developer Guide successfully in support of their Microsoft Power Platform development efforts
Use developer tools to extend Microsoft Power Platform
- Install NuGet packages available for Microsoft Power Platform development
- Work with the Configuration Migration tool
- Work with Package Deployer
- Leverage Solution Packager to isolate features
- Run the Plugin Registration Tool
- Lab: Install and use developer tools
- Lab: Use the Power Apps CLI
Introduction to extending Microsoft Power Platform
- Identify which elements architecturally comprise the Microsoft Power Platform
- Learn about the areas of extensibility that are available to customize Microsoft Power Platform through code
- Discover different approaches to common business scenarios with respect to achieving extensibility by means of configuration versus code
- Lab: Create a Custom API
Introduction to Dataverse for developers
- Explain what functions can be executed against Microsoft Power Platform via Microsoft Power Platform SDKs
- Perform basic operations against Microsoft Power Platform, such as create/read/update/delete operations
Extend plug-ins
- Learn how to extend plug-ins
- Lab: Write your first plug-in
- Lab: Write a custom workflow extension
Performing common actions with client script
- Write client script to perform common actions as listed in the module units
- Lab: Use client script to hide a form section
Automate business process flows with client script
- Automate business process flow actions by using JavaScript/TypeScript API methods
- Lab: Use table data from the client script
Get started with the Power Apps component framework
- Learn about Power Apps component framework architecture
- Learn about Power Apps component tooling
Build a Power Apps component
- Create a custom Power Apps component
- Create a code component solution package
- Test and debug a code component
- Learn key concepts of Dataverse auditing
Use advanced features with the Power Apps component framework
- Use formatting API in a Power Apps component
- Use Dataverse web API in a Power Apps component
Access Dataverse in Power Apps portals
- Discover the portal components that are available to display and interact with Dataverse data on the portal
- Identify the various features of the portal components
- Display a list of data and an associated drill-down for details
- Configure a table form to access individual records
- Trigger classic Dataverse workflows from the portal
- Lab: Use a table list and table form
Extend Power Apps portals
- Discover where software development can resolve particular portal feature requirements
- Employ portal application lifecycle management for Power Apps portals
- Apply JavaScript code to portal assets
- Use Cascading Style Sheets (CSS) to address specific portal development requirements
- Lab: Add advanced client-side functionality
Build custom Power Apps portals web templates
- Learn about the relationship between web templates, page templates, and webpages
- Discover how custom web templates can be built by using HTML, Cascading Style Sheets (CSS), Liquid, and JavaScript
Work with Dataverse Web API
- Interact with Dataverse Web API by using Postman
- Authorize against Dataverse with OAuth
- Use OData to query data
Integrate Dataverse Azure solutions
- Publish Dataverse events to Microsoft Azure Service Bus
- Write a Service Bus Event Listener that consumes Dataverse events
Use Liquid template language to build and structure web templates
- Learn how to embed custom CSS and JavaScript into web templates
- Learn how to reference other web templates in a web template
- Lab: Create an extendable web template