Creating Apps and Automated Workflows with Microsoft Power Platform Bundle (PL-7000)

PL-7000 Bundle Course Includes

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.

Audience Profile

Ideal for professionals looking to simplify, automate, and transform tasks and processes using Microsoft Power Platform. Suitable for those with basic data modeling, user experience design, requirements analysis, and process analysis skills.

At Course Completion

In this course we’ll cover three main topics:

• Design and create canvas apps and automated workflows
• Analyze and visualize data in the context of apps or workflows
• Build model-driven apps with Power Apps and Dataverse

Prerequisites

Basic understanding of data modeling, user experience design, requirements analysis, and process analysis. Comfortable using technology to solve business problems.

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