About This Course
PL-100 you will build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course may contain 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.
Audience Profile
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 iterative strategies.
Course Outline
Module 1: Describe the business value of the Microsoft Power Platform.
Learn about the components of Microsoft Power Platform, the business value for customers, and how the technology works with other Microsoft products.
After completing this module, students will be able to:
• 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.
• Use Artificial Intelligence to increase productivity.
Module 2: Create tables in Dataverse.
After completing this module, students will be able to:
• Introduction to Microsoft Dataverse.
• Table characteristics.
• Create a Microsoft Dataverse table.
• Import data into your Microsoft Dataverse database.
• Table relationships.
• Create table relationships.
• Dataverse logic and security.
• Create a custom table and import data.
• Dataverse auditing.
• Dual write vs. virtual tables.
Module 3: Get started with model-driven apps in Power Apps.
After completing this module, students will be able to:
• Introducing model-driven apps.
• Design model-driven apps.
• Control security when sharing model-driven apps.
• Incorporate business process flows.
• Create a model-driven app.
Module 4: Create and manage columns within a table in Dataverse.
After completing this module, students will be able to:
• 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.
Module 5: Get started with security roles in Dataverse.
After completing this module, students will be able to:
• Introduction to environment roles.
• Understand environment roles.
Adding or disabling an environment user.
• Understand security concepts in Dataverse.
• Understand user security roles and security role defaults.
• Create a custom role.
• Check the roles that a user belongs to.
• Configure Dataverse teams for security.
• Configure Dataverse group teams for security.
Module 6: Document and test your Power Apps application.
After completing this module, students will be able to:
• Create test plans.
• User interface testing.
• Performance optimization.
• Diagnostics and analytics.
• Documentation and the customer.
Module 7: Get started with Microsoft Dataverse for Teams.
After completing this module, students will be able to:
• Dataverse for Teams vs Dataverse.
• Provision your first Dataverse environment.
• Create your first table to store data.
Module 8: Build your first app with Power Apps and Dataverse for Teams.
After completing this module, students will be able to:
• Create your first app with the hero template.
• Customize your app with Power Apps Studio.
• Publish your app.
• Install template apps.
Module 9: Create a canvas app in Power Apps.
After completing this module, students will be able to:
• Introduction to Power Apps.
• Power Apps building blocks.
• Create your first app in Power Apps.
• Create an app from Excel using Copilot.
• Ways to build Power Apps.
• Power Apps related technologies.
• Additional Power Apps related technologies.
• Designing a Power Apps app.
• Improve apps by making basic customizations in Power Apps.
• Create a navigation model for your canvas app.
• Explore screens and controls in Power Apps.
• Get started with functions 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.
• Create UI for a new canvas app.
• Understanding navigation.
• The navigation and back function.
• Lab – Create navigation functions.
• More ways to use the navigation function.
• Manage app versions in Power Apps.
• Share apps in Power Apps.
• Understand environments in Power Apps.
• Power Apps review.
• Learn about mobile-optimized apps.
• Identify components to make a canvas app mobile-optimized.
• Create a mobile-optimized app that uses responsive designs.
• Identify performance considerations for a mobile-optimized canvas app.
• Monitor the performance of a mobile app.
Module 10: Navigate in a canvas app in Power Apps.
After completing this module, students will be able to:
• Understanding navigation.
• The navigation and back function.
• Create navigation functions.
• More ways to use the navigation function.
Module 11: Build the UI in a canvas app in Power Apps.
After completing this module, students will be able to:
• Use themes to quickly change the appearance of your app.
• Branding a control.
• Icons.
• Images.
• Personalization.
• Using the tablet or phone form factors.
• Create UI for a new canvas app.
Module 12: Use and understand Controls in a canvas app in Power Apps.
After completing this module, students will be able to:
• Introduction to controls.
• Core properties of controls.
• Entering and displaying data with text controls.
• Additional controls for enhancing your app’s usability.
• Media.
• Modern controls.
• Work with component libraries.
• Create a canvas app with unique controls.
• Upload file to SharePoint document library.
Module 13: Get started with Power Automate.
After completing this module, students will be able to:
• Introducing Power Automate.
• Create your first flow.
• Create recurring flows.
• Monitor incoming emails.
• Share flows.
• Troubleshoot flows.
Module 14: Use the Admin center to manage environments and data policies in Power Automate.
After completing this module, students will be able to:
• Administer flows.
• Export and import flows.
• Learn how to distribute button flows.
Module 15: Introduction to Microsoft Power Platform security and governance.
After completing this module, students will be able to:
• Identify Microsoft Power Platform environments.
• Data Loss Prevention policies.
• Microsoft Power Platform Center of Excellence Starter Kit.
• Create a Power Platform environment.
Module 16: Build your first workflow with Power Automate and Dataverse for Teams.
After completing this module, students will be able to:
• Introduction.
• Types of workflows that Power Automate can build in Dataverse.
• Create a workflow that triggers when a new message is created.
• Add a flow to your Power Apps app.
• Schedule a flow.
Module 17: Get started building with Power BI.
After completing this module, students will be able to:
• Use Power BI.
• Building blocks of Power BI.
• Tour and use the Power BI service.
Module 18: Get data with Power BI Desktop.
After completing this module, students will be able to:
• 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.
Module 19: Create reports with Power BI and Dataverse for Teams.
After completing this module, students will be able to:
• Introduction.
• Connect to and transform Dataverse for Teams data from Power BI.
• Create a Power BI report.
• Publish the report.
• Share the data.
Module 20: Get started with AI Builder.
After completing this module, students will be able to:
• Introduction to AI Builder
• Choose an AI capability
• Create your first model
• Ways to use your models
Module 21: Create a chatbot with Microsoft Copilot Studio and Dataverse for Teams.
After completing this module, students will be able to:
• 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
Module 22: Validate app maker skills.
After completing this module, students will be able to:
• Introduction to Microsoft Dataverse.
• Table characteristics.
• Exercise – Create a Microsoft Dataverse table.
• Exercise – Import data into your Microsoft Dataverse database.
• Table relationships.
• Create table relationships.
• Dataverse logic and security.
• Exercise – Create a custom table and import data.
• Dataverse auditing.
• Dual write vs. virtual tables.
• 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.
• Introduction to Power Apps.
• Power Apps building blocks.
• Create your first app in Power Apps.
• Create an app from Excel using Copilot.
• Ways to build Power Apps.
• Power Apps related technologies.
• Additional Power Apps related technologies.
• Designing a Power Apps app.
• Use themes to quickly change the appearance of your app.
• Branding a control.
• Icons.
• Images.
• Personalization.
• Using the tablet or phone form factors.
• Create UI for a new canvas app.
• Introducing Power Automate.
• Create your first flow.
• Create recurring flows.
• Monitor incoming emails.
• Share flows.
• Troubleshoot flows.
• Build a data model and create a canvas app.
• Build Power Automate flows to send automated emails
