Vault™ > PL-7000: Creating Apps and Automated Workflows with Microsoft Power Platform

Access to the Vault™ requires an active Microsoft Live Subscription.

Login Buy Subscription

PL-7000: Creating Apps and Automated Workflows with Microsoft Power Platform

By Tyler Farmer
4 Days
Live Class Recording
June 25, 2024
Course Description

Transition from the retiring PL-100T00: Microsoft Power Platform App Maker to the new PL-7000 Bundle. This 4-day live instructor-led course combines three official Microsoft Applied Skills courses: PL-7001 (Create and Manage Canvas Apps with Power Apps), PL-7002 (Create and Manage Automated Processes using Power Automate), and PL-7003 (Create and Manage Model-driven Apps with Power Apps and Dataverse).

PL-7001: Create your own data model and canvas app to support a scenario for a fictional company. You’re provided high-level specifications on the custom tables, columns and canvas app needed to complete this project.

PL-7002: Get started with Power Automate by creating and managing automated processes including creating triggers for cloud flows, configuring actions, implementing conditional logic for a cloud flow, testing a cloud flow, creating and configuring approvals, and sharing cloud flows.

PL-7003: Build model-driven apps by using Microsoft Power Apps. The skills validated include creating Dataverse tables, modifying forms and views, and configuring a model-driven app. The scenario in this experience represents real-world challenges faced by individuals with business-specific expertise who build model-driven apps.

Course Outline

Get started with Power Apps canvas apps

This module introduces the learner to Power Apps. It starts with an introduction video briefly describing the “why” (case for Power Apps) and the “what” for what users can do with Power Apps. The units then take users through the “how” instilling in them the confidence that they can use Power Apps to interact with their data.

Lessons

  • Start Power Apps
  • Power Apps data sources
  • Use Power Apps with Power Automate and Power BI
  • Designing a Power Apps app

Exercise

  • Create your first app in Power Apps
  • Create an app from Excel using Copilot

 

Customize a canvas app in Power Apps

In this module, we'll show learners how to customize their app, a necessary skill for taking advantage of the capabilities of Power Apps. This unit builds upon the app produced in the first unit.

Lessons

  • Improve your app by making basic customizations
  • Explore controls and screens in canvas apps

Exercise

  • Introduction to formulas in canvas apps
  • Create basic screen navigation for a canvas app

 

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. In their learning path, thus far, learners have used basic controls with little to no customization. This unit shows how to make an app more personal and help it fit branding or personal requirements.

Lessons

  • 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

 

Work with external data in a Power Apps canvas app

Do you need to connect an app to access data? Then this module is for you. It focuses on connecting your app to a data source.

Lessons

  • Data-source overview
  • Add a data source
  • Add Office 365 users to your application
  • Display and interact with your data in a gallery
  • Move data between collections and data sources by using Collect

Exercise

  • Work with external data in a canvas app

 

Write data in a Power Apps canvas app

Forms can be used to view, edit, and create records. This module demonstrates how to use forms to write data to your data source. Topics will include form setup, the different form modes, and how to configure a submit button.

Lessons

  • Introduction to forms
  • Form modes
  • Adding and customizing an Edit form
  • Submit your form
  • Special properties

Exercise

  • Working with forms

 

Publish, share, and maintain a canvas app

You've built your first app. Now, it's time to publish, share it with others, and maintain subsequent versions of the app.

Lessons

  • Introduction
  • Application lifecycle management

Exercise

  • Publish your app
  • Share your app
  • Share your app

 

Guided Project - Create and manage canvas apps with Power Apps

Create your own data model and canvas app to support a scenario for a fictional company. You're provided high-level specifications on the custom tables, columns and canvas app needed to complete this project.

Lessons

  • Prepare

Exercise

  • Create a canvas app that connects to a data source

 

Get started with Power Automate

Power Automate is an online workflow service that automates actions across the most common apps and services.

Lessons

  • Create your first flow
  • Troubleshoot flows

Exercise

  • Create recurring flows
  • Monitor incoming emails
  • Share flows

 

Build approval flows with Power Automate

Power Automate is an online workflow service that automates actions across the most common apps and services. In this module, you build approval flows to streamline your business, save time, and work more efficiently.

Lessons

  • Provide solutions to real-world scenarios

Exercise

  • Build an approval request
  • Create a business process flow
  • Create a business process flow that has conditions

 

Build flows to manage user information

Power Automate is an online workflow service that automates actions across the most common apps and services. In this module, you build more flows to manage user information.

Lessons

  • Introduction

Exercise

  • Build a flow that uses information like locations or date
  • Build a flow accepts user input when run
  • Create a flow that blocks time on your calendar

 

Power Automate's deep integration across multiple data sources

Power Automate is an online workflow service that automates actions across the most common apps and services. In this module, you'll build flows across multiple data sources.

Lessons

Introduction

Exercise

  • Build a flow that runs when an event in Dynamics 365 occurs
  • Build a flow that uses SQL
  • Integrate Power Apps, Power Automate, and SharePoint
  • Monitor flows

 

Guided Project - Create and manage automated processes with Power Automate

Create your own data model and flow to support a scenario for a fictional company. You'll be provided with high-level specifications on the custom tables, columns, and flow needed to complete this project.

Lessons

  • Prepare

Exercise

  • Build a Power Automate flow to send automated emails

 

Create tables in Dataverse

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.

Lessons

  • Table characteristics
  • Table relationships
  • Dataverse logic and security
  • Dataverse auditing
  • Dual-write vs. virtual tables

Exercise

  • Create a Microsoft Dataverse table
  • Import data into your Microsoft Dataverse database
  • Create table relationships
  • Create a custom table and import data

 

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 or no code, you can make apps that are simple or complex.

Lessons

  • Introducing model-driven apps
  • Components of model-driven apps
  • Design model-driven apps
  • Incorporate business process flows

 

Exercise

  • Create a Solution and add an existing data table
  • Control security when sharing model-driven apps
  • Create a model-driven app

 

Configure forms, charts, and dashboards in model-driven apps

In this module, you'll learn about forms, grids, views, charts, and dashboards that can be used in model-driven apps.

Lessons

  • Forms overview
  • Form elements
  • Configure multiple forms
  • Use specialized form components
  • Configure views overview
  • Configure grids
  • Create and edit views
  • Configure charts overview
  • Dashboards overview
  • Use interactive streams and tiles

Exercise

  • None

 

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..

Lessons

  • Introduction
  • Add and remove apps, flows, and entities in a solution
  • Edit a solution-aware app, flow, and table
  • Build and deploy a complex solution with flows, apps, and entities
  • Automate solution management

Exercise

  • Import and export solutions

 

Guided Project - Create and manage model-driven apps with Power Apps and Dataverse

In this module, practice building model-driven apps with Microsoft Power Apps, including creating Dataverse tables, modifying forms and views, and configuring apps. The lab offers interactive practice with real-world scenarios for business-specific challenges.

Lessons

  • Prepare

Exercise

  • Create custom tables
  • Modify forms and views
  • Build a model-driven app
Course Content
Introduction
Introduction
Introduction to Microsoft Power Platform
Introduction to Microsoft Power Platform
Introduction to Microsoft Power Platform (Continuation after break)
Create and manage canvas apps with Power Apps
Get started with Power Apps canvas apps
Get started with Power Apps canvas apps (Continuation after lab)
Get started with Microsoft Dataverse
Customize a canvas app in Power Apps
Customize a canvas app in Power Apps (Continuation after lab)
How to build the User Interface in a canvas app in Power Apps
How to build the User Interface in a canvas app in Power Apps (Continuation after lunch)
Work with external data in a Power Apps canvas app
Publish, share, and maintain a canvas app
Create and manage model-driven apps with Power Apps and Dataverse
Create tables in Dataverse
Get started with model-driven apps in Power Apps
Get started with model-driven apps in Power Apps (Continuation after lab)
Create and manage automated processes by using Power Automate
Get started with Power Automate
Get started with Power Automate (Continuation after lab)
Build approval flows with Power Automate
Additional Demos
Additional Demos
Create and manage automated processes by using Power Automate
Build flows to manage user information (Variables and Expressions)
Power Automate's deep integration across multiple data sources
Housekeeping and handouts
Housekeeping and handouts
Extra Module
Manage security in Microsoft Dataverse