PL-100T00: Microsoft Power Platform App Maker

This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

Description

Overview

This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

Who Should Attend

The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and interactive strategies.

Course Objectives

  • Get started with Microsoft Power Platform for app makers
  • Create tables in Dataverse
  • Create and manage columns within a table in Dataverse
  • Load/export data and create data views in Dataverse
  • Export data from Dataverse and use Microsoft Excel to edit records
  • Get started with Microsoft Dataverse for Teams
  • Build your first app with Power Apps and Dataverse for Teams
  • Build your first workflow with Power Automate and Dataverse for Teams
  • Create reports with Power BI and Dataverse for Teams
  • Get started building with Power BI
  • Explore what Power BI can do for you
  • Manage workspaces and datasets in Power BI
  • Create dashboards in Power BI
  • Secure, publish, and share data in Power BI
  • Embed Power BI content
  • How to build your first model-driven app with Dataverse
  • Get started with model-driven apps in Power Apps
  • Configure forms, charts, and dashboards in model-driven apps
  • Manage Dynamics 365 model-driven app settings and security
  • Use specialized components in a model-driven form
  • Create a canvas app in Power Apps
  • Use and understand Controls in a canvas app in Power Apps
  • Create formulas to change properties in a Power Apps canvas app
  • Use imperative development techniques for canvas apps in Power Apps
  • Manage apps in Power Apps
  • Use basic formulas to make better Power Apps canvas apps
  • Build a canvas app for a real estate solution with Copilot in Power Apps
  • Automate a business process using Power Automate
  • Optimize your business process with process advisor
  • Build flows for a real estate solution using Copilot in Power Automate
  • Use Dataverse triggers and actions in Power Automate
  • Validate your app maker skills

Course Outline

Lesson 1: Describe the business value of the Microsoft Power Platform

  • Explore Microsoft Power Platform
  • Describe the business value of the Power Platform
  • Explore connectors and Microsoft Dataverse
  • Describe how Power Platform works with Microsoft 365 apps and services
  • Explore how Power Platform works with Microsoft Teams
  • Describe how Power Platform works with Microsoft Dynamics 365 apps
  • Describe how Power Platform solutions consume Microsoft Azure services
  • Explore how Microsoft Power Platform apps work together

Lesson 2: How to build your first model-driven app with Dataverse

  • Model-driven apps, powered by Microsoft Dataverse
  • Explore sample apps

Lesson 3: Create tables in Dataverse

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

Lesson 4: Get started with model-driven apps in Power Apps

  • Introducing model-driven apps
  • Components of model-driven apps
  • Design model-driven apps

Lesson 5: Create and manage columns within a table in Dataverse

  • Define columns in Microsoft Dataverse
  • Column types in Microsoft Dataverse
  • Add a column to a table
  • Create a primary name column
  • Restrictions that apply to columns in a table
  • Create an auto numbering column
  • Create an alternate key

Lesson 6: Get started with security roles in Dataverse

  • Understand environment roles
  • Adding or disabling an environment user
  • Understand security concepts in Dataverse
  • Understand user security roles and security role defaults
  • Check the roles that a user belongs to
  • Configure Dataverse teams for security
  • Configure Dataverse group teams for security

Lesson 7: Document and test your Power Apps application

  • Create test plans
  • User interface testing
  • Performance optimization
  • Diagnostics and analytics
  • Documentation and the customer

Lesson 8: Get started with Microsoft Dataverse for Teams

  • Provision your first Dataverse environment
  • Create your first table to store data

Lesson 9: Build your first app with Power Apps and Dataverse for Teams

  • Create your first app with the hero template
  • Customize your app with Power Apps Studio
  • Publish your app
  • Install template apps

Lesson 10: Navigation in a canvas app in Power Apps

  • Understanding navigation
  • The navigation and back function
  • LAB - Create navigation functions

Lesson 11: How to build the UI in a canvas app in Power Apps

  • Use themes to quickly change the appearance of your app
  • Branding a control
  • Icons
  • Images
  • Personalization
  • Using the tablet or phone form factors

Lesson 12: Use and understand Controls in a canvas app in Power Apps

  • Core properties of controls
  • Entering and displaying data with text controls
  • Additional controls for enhancing your app's usability
  • Media
  • LAB - Create a canvas app with unique controls

Lesson 13: Get started with Power Automate

  • Introducing Power Automate
  • Troubleshoot flows

Lesson 14: Use the Admin center to manage environments and data policies in Power Automate

  • Administer flows
  • Export and import flows
  • Learn how to distribute button flows

Lesson 15: Introduction to Microsoft Power Platform security and governance

  • Identify Microsoft Power Platform environments
  • Data Loss Prevention policies
  • Microsoft Power Platform Center of Excellence Starter Kit

Lesson 16: Build your first workflow with Power Automate and Dataverse for Teams

  • Types of workflows that Power Automate can build in Dataverse
  • Schedule a flow

Lesson 17: Get started building with Power BI

  • Use Power BI
  • Building blocks of Power BI
  • Tour and use the Power BI service

Lesson 18: Get data with Power BI Desktop

  • Overview of Power BI Desktop
  • Explore Power BI Desktop
  • Connect to data sources
  • Get data from Excel
  • Transform data to include in a report
  • Combine data from multiple sources
  • Clean data to include in a report

Lesson 19: Create reports with Power BI and Dataverse for Teams

  • Connect to and transform Dataverse for Teams data from Power BI
  • Create a Power BI report
  • Publish the report
  • Share the data

Lesson 20: Get started with AI Builder

  • Choose an AI capability
  • Create your first model
  • Ways to use your models

Lesson 21: Create a chatbot with Power Virtual Agents and Dataverse for Teams

  • Create your first chatbot
  • Create and modify topics
  • Add inputs, variables, and conditions
  • Call an action to pull in Dataverse for Teams data
  • Publish and share your new chatbot

System Requirements for Online Participants:

Active participation in this course is crucial. The lab activities all build on one another (so for example, you are unable to move into Lab 2 if you haven't completed Lab 1). Please ensure you and/or your students have your calendars blocked off and are ready to be a full/active participant in this class - no multi-tasking please!

Prerequisites

  • Basic data modeling, user experience design, requirements analysis, and process analysis skills
  • A personal growth mindset and are comfortable using technology to solve business problems
  • An understanding of the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies

Similar courses

This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.

More Information

This course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.

More Information

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

More Information

In this 5-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and 2019.

More Information

The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.

More Information

This course gives a detailed overview of Microsoft Intune and how it is used in organizations.

More Information

As an endpoint administrator, you collaborate with architects, Microsoft 365 administrators, security administrators, and other workload administrators to plan and implement a modern workplace strategy that meets the business needs of an organization. This course will also prepare you for the Endpoint Administrator Associate Microsoft certification.

More Information

In this course, you will use Copilot to streamline communication, power up your content creation, and maximize the potential of generative AI.

More Information

This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings.

More Information

Gain fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers.

More Information

Learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues.

More Information

In this course, you will use Microsoft Power Apps to build and deploy low-code business apps.

More Information

In this course, you will use generative AI tools to help you develop text and images that you can use in your word processor or desktop publishing application.

More Information

This course begins by examining the Microsoft Copilot for Microsoft 365 design. Its main focus, however, is on the security and compliance features that administrators must configure in their Microsoft 365 tenant to protect their company's organizational data before they implement Copilot for Microsoft 365.

More Information

This course will teach students who are new or unfamiliar with Microsoft Copilot how to use it effectively in common situations. The course focuses on Copilot for Microsoft 365, using the AI in applications like Word, PowerPoint, Excel, Outlook, OneNote and Teams. It also covers other popular Copilot experiences found in Windows 11, Edge and the Copilot website.

More Information

This five-day instructor-led course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server in most organizations. It is designed primarily for IT professionals who have some experience with Windows Server and will be responsible for managing identity, networking, storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server.

More Information

This four-day course is intended for Windows Server Hybrid Administrators who have experience working with Windows Server and want to extend the capabilities of their on-premises environments by combining on-premises and hybrid technologies. Windows Server Hybrid Administrators implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.

More Information

This course is a continuation of AZ-040T00: Automating Administration with PowerShell, taking a deep dive into the development of PowerShell cmdlets and modules and features both hands on labs and challenging exercises to help you practice the skills presented in class. Time will be spent on the theory of how to design cmdlets as well as the proper structure of the programming code to facility cmdlets that work with the PowerShell piping in keeping with community standards.

More Information

This is a 4-day course is designed to provide you with the knowledge and skills required to support and troubleshoot Windows 11 PCs and devices in an on-premises Windows Server Active Directory domain environment.

More Information

This course introduces fundamental concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. It is designed as a blended learning experience that combines instructor-led training with online materials. The hands-on exercises in the course are based on Learn modules, and students are encouraged to use the content on Learn as reference materials to reinforce what they learn in the class and to explore topics in more depth.

More Information

AI-102 Designing and Implementing an Azure AI Solution is intended for software developers wanting to build AI infused applications that leverage Azure Cognitive Services, Azure Cognitive Search, and Microsoft Bot Framework. The course will use C# or Python as the programming language.

More Information

This course teaches Network Engineers how to design, implement, and maintain Azure networking solutions. This course covers the process of designing, implementing, and managing core Azure networking infrastructure, Hybrid Networking connections, load balancing traffic, network routing, private access to Azure services, network security and monitoring.

More Information

Azure OpenAI Service provides access to OpenAI’s powerful large language models such as GPT; the model behind the popular ChatGPT service. These models enable various natural language processing (NLP) solutions to understand, converse, and generate content. Users can access the service through REST APIs, SDKs, and Azure OpenAI Studio. In this course, you’ll learn how to provision Azure OpenAI service, deploy models, and use them in generative AI applications.

More Information

This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using Key Vault and Managed Identities. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.

More Information

This is an introductory course. Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build a foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. You will explore the roles, tasks, and responsibilities in the world of data.

More Information

This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms.

More Information

This course will provide foundational level knowledge on cloud concepts; core Azure services; and Azure management and governance features and tools.

More Information

This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.

More Information

This course covers the following key elements of Microsoft 365 administration: Microsoft 365 tenant management, Microsoft 365 identity synchronization, and Microsoft 365 security and compliance.

More Information

The Microsoft Identity and Access Administrator course explores how to design, implement, and operate an organization’s identity and access management systems by using Microsoft Entra ID (Formerly Azure AD). Learn to manage tasks such as providing secure authentication and authorization access to enterprise applications. You will also learn to provide seamless experiences and self-service management capabilities for all users.

More Information

Learn how to protect information in your Microsoft 365 deployment. This course focuses on data governance and information protection within your organization. The course covers implementation of data loss prevention policies, sensitive information types, sensitivity labels, data retention policies and Office 365 message encryption among other related topics. The course helps learners prepare for the Microsoft Information Protection Administrator exam (SC-400).

More Information

This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. This course is for an on-premise SharePoint environment.

More Information

The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.

More Information

This course teaches developers how to create applications using the SQL API and SDK for Azure Cosmos DB. Students will learn how to write efficient queries, create indexing policies, manage and provision resources, and perform common operations with the SDK.

More Information

In this course students will learn the various security, compliance, and identity concepts. After attending you will be able to describe the capabilities of Microsoft’s identity and access management solutions and Microsoft security and compliance solutions.

More Information

This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics.

More Information

Learn to efficiently manage enterprise devices using Microsoft Intune, including enrollment, application deployment, endpoint security, and Windows Autopilot, to enhance productivity and security.

More Information