Overview

This course will consist of three, one day duration, Microsoft Applied Skills Workshops - MPL7001, MPL7002 and MPL7003:

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

Get started with Power Automate by create and manage automated processes with Power Automate. Including creating triggers for cloud flows, configuring actions, implementing conditional logic for a cloud flow, testing a cloud flow, creating and configuring approvals by using Power Automate, and sharing cloud flows.

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

Read more +

Prerequisites

  • You should understand application development, writing formulas such as those in Excel, and creating, reading, updating, and deleting data.
  • Fundamental understanding of Power Platform.
  • Basic understanding of Power Automate.
  • Candidates should be familiar with data modeling concepts in Microsoft Dataverse and with the Power Apps maker portal.

Important:

Multi-factor authentication (MFA) requirements: For security purposes Microsoft might require MFA for access to the Microsoft 365/Dynamics 365 tenants used for this course. As such, you may need to have a mobile device available upon which you will set up the free of charge Microsoft Mobile phone authenticator App which can be downloaded here with details on how to sign in here

Read more +

Outline

Module 1: 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.

  • 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
  • Summary

Module 2: 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.

  • 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
  • Summary

Module 3: 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.

  • 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
  • Summary

Module 4: 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.

  • Introduction
  • 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
  • Check your knowledge6
  • Summary

Module 5: 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.

  • Introduction to forms5
  • Form modes
  • Adding and customizing an Edit form
  • Submit your form
  • Special properties
  • Exercise- Working with forms
  • Check your knowledge
  • Summary

Module 6: 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.

  • Introduction
  • Exercise - Publish your app
  • Exercise - Share your app
  • Exercise - Maintain your app
  • Application lifecycle management
  • Check your knowledge
  • Summary

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

  • Introduction
  • Prepare
  • Exercise - Create a canvas app that connects to a data source
  • Knowledge check
  • Summary

Module 8: Get started with Power Automate

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

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

Module 9: 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.

  • 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
  • Summary

Module 10: 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.

  • Introduction
  • Exercise - Build a flow that uses information like locations or date
  • Exercise - Build a flow accepts user input when run
  • Exercise - Create a flow that blocks time on your calendar
  • Check your knowledge
  • Summary

Module 11: 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.

  • Introduction
  • Exercise - Build a flow that runs when an event in Dynamics 365 occurs
  • Exercise - Build a flow that uses SQL
  • Exercise - Integrate Power Apps, Power Automate, and SharePoint
  • Exercise - Monitor flows
  • Check your knowledge
  • Summary

Module 12: 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.

  • Introduction
  • Prepare
  • Exercise - Build a Power Automate flow to send automated emails
  • Knowledge check
  • Summary

Module 13: 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.

  • Introduction to Microsoft Dataverse
  • Table characteristics
  • Exercise - Create a Microsoft Dataverse table
  • Exercise - Import data into your Microsoft Dataverse database1
  • Table relationships
  • Exercise - Create table relationships
  • Dataverse logic and security
  • Exercise - Create a custom table and import data
  • Dataverse auditing
  • Dual-write vs. virtual tables
  • Check your knowledge
  • Summary

Module 14: 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.

  • 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
  • Summary

Module 15: 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.

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

Module 16: 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
  • Add and remove apps, flows, and entities in a solution
  • Edit a solution-aware app, flow, and table
  • Exercise - Import and export solutions
  • Build and deploy a complex solution with flows, apps, and entities
  • Automate solution management
  • Check your knowledge
  • Summary

Module 17: 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.

  • Introduction
  • Prepare
  • Exercise - Create custom tables
  • Exercise - Modify forms and views
  • Exercise - Build a model-driven app
  • Knowledge check
  • Summary

Read more +

Why choose QA

Special Notices

This course is the replacement for MPL100 (MPL100 retired in June 2024)

Important:

Multi-factor authentication (MFA) requirements: For security purposes Microsoft might require MFA for access to the Microsoft 365/Dynamics 365 tenants used for this course. As such, you may need to have a mobile device available upon which you will set up the free of charge Microsoft Mobile phone authenticator App which can be downloaded here with details on how to sign in here

Dates & Locations

Need to know

Frequently asked questions

How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Let's talk

By submitting this form, you agree to QA processing your data in accordance with our Privacy Policy and Terms & Conditions. You can unsubscribe at any time by clicking the link in our emails or contacting us directly.