Menu
Introduction:
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.
Objectives:
Course Outline:
1 – Get started with Microsoft Power Platform for app makers
- Identify components
- Create apps
- Get started with Microsoft Dataverse
- Work with Copilot in Microsoft Power Platform
2 – Create tables in Dataverse
- Table characteristics
- Table relationships
- Dataverse logic and security
- Dataverse auditing
- Dual-write vs. virtual tables
3 – 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
- Primary name column
- Restrictions that apply to columns in a table
- Create an auto numbering column
- Create an alternate key
4 – Load/export data and create data views in Dataverse
- View data in a table
- Create or edit views of data in a table
- Dataverse data import options
- Load data into a table
- Dataverse data export options
- Export
- Add, update, or delete data in a table by using Excel
- Import data using Power Query
5 – Export data from Dataverse and use Microsoft Excel to edit records
- Export data to Excel
- Edit and update data in Excel
6 – Get started with Microsoft Dataverse for Teams
- Dataverse for Teams vs Dataverse
- Provision your first Dataverse environment
- Create your first table to store data
7 – 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
8 – Build your first workflow with Power Automate and Dataverse for Teams
- Types of workflows that Power Automate can build in Dataverse
- Schedule a flow
9 – 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
10 – Get started building with Power BI
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
11 – Explore what Power BI can do for you
- What can I do with the Power BI service as a consumer?
- View content in the Power BI service
- Collaborate and share in Power BI
- Find and view dashboards and reports
12 – Create and manage workspaces in Power BI
- Distribute a report or dashboard
- Monitor usage and performance
- Recommend a development life cycle strategy
- Troubleshoot data by viewing its lineage
- Configure data protection
13 – Manage semantic models in Power BI
- Use a Power BI gateway to connect to on-premises data sources
- Configure a semantic model scheduled refresh
- Configure incremental refresh settings
- Manage and promote semantic models
- Troubleshoot service connectivity
- Boost performance with query caching (Premium)
14 – Create dashboards in Power BI
- Configure data alerts
- Explore data by asking questions
- Review Quick insights
- Add a dashboard theme
- Pin a live report page to a dashboard
- Configure a real-time dashboard
- Set mobile view
15 – Implement row-level security
- Configure row-level security with the static method
- Configure row-level security with the dynamic method
16 – Create dashboards in Power BI
- Configure data alerts
- Explore data by asking questions
- Review Quick insights
- Add a dashboard theme
- Pin a live report page to a dashboard
- Configure a real-time dashboard
- Set mobile view
17 – Secure, publish, and share data in Power BI
- Share and use reports in Power BI
- Row-level security
- Publish a report to a Power BI workspace
- Share reports and user experience
- Protect data in Power BI
- Data refresh and alerts
18 – Embed Power BI content
- Embed Power BI reports
- Embed other Power BI content types
- Optimize the embedding experience
19 – How to build your first model-driven app with Dataverse
- Model-driven apps, powered by Microsoft Dataverse
- Explore sample apps
20 – Get started with model-driven apps in Power Apps
- Introducing model-driven apps
- Components of model-driven apps
- Design model-driven apps
- Incorporate business process flows
21 – Configure forms, charts, and dashboards 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
22 – Manage Dynamics 365 model-driven app settings and security
- Configure role-based security
- Manage teams and business units
- Explore settings and customizations
23 – Use specialized components in a model-driven form
- Create business process flows
- Embed a canvas app in a model-driven form
- Add a timeline in a model-driven form
- Create a report in a model-driven form
24 – Get started with Power Apps canvas apps
- Start Power Apps
- Power Apps data sources
- Use Power Apps with Power Automate and Power BI
- Designing a Power Apps app
25 – Customize a canvas app in Power Apps
- Improve your app by making basic customizations
- Explore controls and screens in canvas apps
26 – How to build the User Interface in a canvas app in Power Apps
- Use themes to quickly change the appearance of your app
- Brand a control
- Icons
- Images
- Personalization
- Build for phones or tablets
27 – Navigation in a canvas app in Power Apps
- Understanding navigation
- The Navigate and Back functions
- More ways to use the Navigate function
28 – Manage apps in Power Apps
- Power Apps review
29 – Build a mobile-optimized app from Power Apps
- 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
30 – 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
- Modern controls
- Work with component libraries
31 – Create formulas to change properties in a Power Apps canvas app
- Formulas overview
- Use a formula to modify the format of controls
- Use formulas to perform calculations
- Use a control to modify the property of other controls
- Conditional formatting
- Functions for validating data
32 – Use imperative development techniques for canvas apps in Power Apps
- Imperative versus declarative development
- The three types of variables in Power Apps
- Global variables
- Contextual variables
- Collections
- Additional variable concepts
33 – Manage apps in Power Apps
- Power Apps review
34 – Create formulas to change properties in a Power Apps canvas app
- Formulas overview
- Use a formula to modify the format of controls
- Use formulas to perform calculations
- Use a control to modify the property of other controls
- Conditional formatting
- Functions for validating data
35 – Create formulas to change behaviors in a Power Apps canvas app
- Formulas and functionality
- Understanding true and false
- Understanding control behaviors and actions
- Performing multiple actions in a formula
- Control the display mode through a formula
- Use controls and functions to create a dynamic formula
36 – Author a basic formula that uses tables and records in a Power Apps canvas app
- Records and tables
- Using the Table function
- Store a table
- Filter your table
- Use the lookup function to return a record
- Additional table functions
37 – Build a canvas app for a real estate solution with Copilot in Power Apps
38 – Get started with Power Automate
- Introducing Power Automate
- Create your first flow
- Troubleshoot flows
39 – Build approval flows with Power Automate
- Provide solutions to real-world scenarios.
40 – Build flows to manage user information
41 – Power Automate’s deep integration across multiple data sources
42 – 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
43 – Use AI Builder in Power Automate
- AI Builder in Power Automate saves time
- Advanced usage of AI Builder in Power Automate
44 – Optimize your business process with process advisor
- Get familiar with process advisor
- Create your first recording
- Edit recordings and group actions
- Analyze recordings and interpret results
- Automation recommendations
45 – Optimize your business process with process advisor
- Get familiar with process advisor
- Create your first recording
- Edit recordings and group actions
- Analyze recordings and interpret results
- Automation recommendations
46 – Build flows for a real estate solution using Copilot in Power Automate
- When to use Copilot in Power Automate
47 – Use Dataverse triggers and actions in Power Automate
- Dataverse triggers
- Query data
- Create, update, delete, and relate actions
48 – Create tables in Dataverse
- Table characteristics
- Table relationships
- Dataverse logic and security
- Dataverse auditing
- Dual-write vs. virtual tables
49 – 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
- Primary name column
- Restrictions that apply to columns in a table
- Create an auto numbering column
- Create an alternate key
50 – Get started with Power Apps canvas apps
- Start Power Apps
- Power Apps data sources
- Use Power Apps with Power Automate and Power BI
- Designing a Power Apps app
51 – How to build the User Interface in a canvas app in Power Apps
- Use themes to quickly change the appearance of your app
- Brand a control
- Icons
- Images
- Personalization
- Build for phones or tablets
52 – Get started with Power Automate
- Introducing Power Automate
- Create your first flow
- Troubleshoot flows
53 – Challenge Project – Build a booking requests app with Power Apps and Power Automate
- Prepare
Enroll in this course
$1,785.00 – $2,380.00