Mastering Power Apps and Power Automate
Duration: 32 hours
Course description
This course offers a comprehensive journey from the fundamentals to advanced
techniques in app and flow building. We will begin by exploring the Power Platform,
creating Canvas Apps, and writing expressions. As you progress, you will learn how
to build data-driven Canvas Apps, focusing on screen design, galleries, forms, and
data manipulation. The course also covers advanced development concepts such
as reusable components and the Power Apps component framework. You’ll dive
into Dataverse for data modeling and learn to build Model-Driven apps.
The content will help you develop a strong foundation in Power Automate, learning
how to create, test, and manage flows, automate processes, and perform process
mining. Advanced topics include managing content and approvals, integrating
PowerApps with external systems, and automating desktop workflows. Finally, you
will discover how to integrate PowerApps with other Power Platform tools like Power
BI, embedding dashboards, extending reports, and designing real-time data flows.
By the end of the course, the developer will be equipped to create sophisticated,
automated solutions using the Power Platform.
Audience Pre-requisites
• Basic knowledge of Power Apps and Power Automate.
• Basic data modelling, user experience design, requirements analysis, and
process analysis skills.
• Personal growth mindset and comfortable using technology to solve business
problems.
• Understanding of the operational needs and have a vision of the desired
outcome. They approach problems with phased and iterative strategies.
• Basic understanding of JavaScript/ TypeScript and CLI.
Course Delivery Methodology
• This is an instructor led online course
• Courseware will be provided as part of the training to each participant
• Lab environment will be set up for the participants for hands-on exercises
• There will be a complimentary revision session once the training is completed
• An evaluation exercise will be part of the training to assess the knowledge and
skills gained from the training.
Course Content
1. Getting Started with the Power Platform
• Getting Started with Power Platform
• Creating Canvas Apps
• Writing Power apps Expressions
• Working with connectors and Data Binding
• Understanding Delegation
2. Building Data -Driven Canvas Apps
• Screen Design Guidelines
• Different Between Gallery & Data table
• Different Type of Galleries in canvas
• Customizing the forms and gallery controls
• Using Table Functions to Filter and Sort Data
• Updating Data using Edit Forms and Data Cards
• Customizing SharePoint List forms
• Variables & Collections
• Using Patch
• Work with Search and Sort functions
• Logical Functions: If/ Nested If / Switch
• Update Functions
3. Development in Power Apps
• Designing Reusable Components
• Package Power apps using Power Platform CLI
• Power apps component framework
4. Model driven apps and Dataverse
• Work with Dataverse
• Design a data model with Dataverse
• Connecting with External data
• Building Model -Driven apps
• Creating a Custom entity
• Performing common actions with client script
• Business Process Flows
5. Getting Started with Power Automate
• Power Automate Fundamentals
• Creating and Testing Flows
• Writing Flow Expressions
• Use data operations
• Manage automations
6. Building Flows to Manage Content and Approvals
• Converting and Reshaping data
• Uploading data to SharePoint
• Automating Approval processes
• Integrating Flow with Microsoft forms
• Understanding Parallel Execution
7. Integrating PowerApps with External systems
• Executing Child flows from a Parent Flow
• Creating and Testing Custom Connectors
8. Automate Desktop based processes with Power Automate
• Introduction to Desktop Flows
• Desktop Automation tools
• Creating a simple Flow with Power Automate for Desktop
• Record a desktop flow
• Work with desktop Flow variables
• Connect desktop Flows with Cloud flows.
• Connect flows with Cloud services like Outlook / SharePoint and teams
• Integrate flows with AI builder
• Test and share Flows
• Process Mining
9. Integrating PowerApps with Power BI
• Overview of Power BI Integration features
• Embedding Power BI dashboard Tiles in PowerApps
• Extending Power BI Reports using Canvas Apps
• Designing flows to update Real -Time Dashboards
• Triggering Flows using Power BI Dashboard Alerts
