I. Overview:

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to design, develop, test, and troubleshoot solution components that use the extension points of Microsoft Power Platform. You use traditional code to solve challenges not appropriate with low-code.

II. Duration: 40 hours (5 days)

III. Intended Audience:

In this course you will learn to build solutions using Visual Studio and Visual Studio Code that include the following: Microsoft Power Platform services, JavaScript, JSON, TypeScript, C#, HTML, RESTful Web APIs, and Microsoft Azure. As a training attendee you must have previous software developer experience using code techniques with modern programming languages such as C# and JavaScript.

IV. Prerequisites:

You must also have a foundational understanding of Microsoft Power Platform and have hands-on experience with the following:

• Developing a data model in Microsoft Dataverse
• Creating tables, columns, and relationships in Microsoft Dataverse
• Building Power Apps canvas apps
• Building Power Apps model-driven apps
• Building Power Automate cloud flows

V. Course outlines:

1. Use advance techniques in canvas apps to perform custom updates and optimization

• Use imperative development techniques for canvas apps in Power Apps: Imperative development techniques can help you achieve the goal for your app. You learn about different development methods and different variables in Power Apps.
• 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.
• Use Dataverse choice columns with formulas: Explore how you can use Power Fx formulas to work with the Choice column in Microsoft Dataverse. These column data types present the user with a fixed list of values that are defined by the maker.
• Reduce complexity in your data model with Dataverse table relationships: Learn how to use Dataverse relationships in canvas apps from Power Apps. As real-life objects are related to each other, the relationships are used in Dataverse to link rows in one table to another. Using the relationships properly means that apps can hide unnecessary complexities of the data model.
• Work with relational data in a Power Apps canvas app: Do you want to improve a user's experience in your canvas app? This module will show you how to work with relational data to provide a good experience for app users.
• Work with data source limits (delegation limits) in a Power Apps canvas app: It's important to learn how to work with data source limits. You need to understand the various limits and variables that go into those limits to best work with data in Power Apps. This will help you chose the best data source for an app to meet your requirements.
• 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.
• Optimize app load time: Learn how you can evaluate and improve app load times. By regularly reviewing and measuring your app, you can proactively identify and remediate startup performance problems.
• Use Monitor to troubleshoot Power Apps: Learn how the Monitor tool from Power Apps Studio can help you proactively identify, troubleshoot, and resolve issues within your app.
• Use Power Apps Instrumentation with Application Insights: Explore how you can set up your Power Apps canvas app to send telemetry to Application Insights.

2. Automate a business process with expressions and Dataverse actions using Power Automate

• Get started with Power Automate: Power Automate is an online workflow service that automates actions across the most common apps and services.
• Introduction to expressions in Power Automate: Get the most out of your data using functions to create expressions.
• Use Dataverse triggers and actions in Power Automate: This module introduces the triggers and actions that you can use to build flows in Power Automate with Dataverse.

3. Introduction to developing with Microsoft Power Platform

• 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.
• Use developer tools to extend Power Platform: This module will focus on the available developer tools that can help you perform development activities with Microsoft Power Platform.
• 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.

4. Extend the user experience with client scripting and command bar customization

• 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.
• 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.
• Customize the command bar: Learn to implement actions for customized commands on the command bar in Power Apps.

5. Build basic code components with the Power Apps Component Framework

• Get started with Power Apps component framework: Learn how to get started with Microsoft Power Apps component framework.
• Build a Power Apps component: Build a custom Power Apps component, create a code component solution package, and then test and debug a code component.

6. Extending Power Platform Dataverse

• 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.
• 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.
• Work with Dataverse Web API: Learn about working with the Dataverse Web API.

7. Integrate with Dataverse and Azure

• Integrate Dataverse Azure solutions: Gain an in-depth overview of options available within Dataverse to integrate data and events to Azure.
• Explore Azure Functions: Learn how Azure Functions can be a great solution for data processing, systems integration, and building simple APIs and microservices.
• Develop Azure Functions: Learn how to create and deploy Azure Functions.

8. Get started with custom connectors for Microsoft Power Platform

• Get started with custom connectors in Microsoft Power Platform: Connectors help make it easier for app and flow makers to connect to other apps, data, and devices in the cloud. Learn how to configure and use custom connectors with Microsoft Power Apps, Microsoft Power Automate, and Microsoft Azure Logic Apps.
• Discover and use Web APIs with Power Apps: Has your organization developed a web API and need to use it within a Power Apps application? In this module, you'll learn how you can build custom connectors to have your Power Apps applications interact with your web APIs.
• Configure custom connectors with authenticated APIs in Microsoft Power Platform: Custom connectors can provide access to custom or third-party APIs that are accessible via public endpoints. In this module, learn how to configure custom connectors with authenticated APIs in Microsoft Power Platform.
• Configure policy templates for custom connectors in Microsoft Power Platform: Policies allow you to modify the behavior of a custom connector at runtime. You can use policies to perform data conversion, route requests, set parameter values, and more. You can configure policies directly in the custom connector API properties file before import, or you can do it from the maker portal in the custom connector designer by applying policy templates.
• Create Microsoft Power Platform OpenAPI custom connectors: You can define extensions to OpenAPI to configure specific features that are supported by custom connectors in Microsoft Power Platform. This module covers authentication, actions, and triggers that are used with OpenAPI connectors.

9. Basic application lifecycle management in Microsoft Power Platform

• Manage solutions in Power Apps and Power Automate: Microsoft Power Apps and Power Automate include such package features as apps from Microsoft Power Apps, site maps, flows, entities, customer connectors, and more. In this module, you'll learn how to manage solutions with Power Automate.
• Introduction to solutions for Microsoft Power Platform: Solutions for Microsoft Power Platform can help you transport an existing app and components from one environment to another. Additionally, solutions will help you apply a set of customizations to existing apps. This module will share solution basics and best practices.