*We customize the course outline and content to your specific needs and relevant use cases.
Module 1: Introduction to Microsoft Power Apps and the Power Platform
- Understanding the role of Power Apps within Microsoft Power Platform
- Comparing Canvas apps and model-driven apps for different business scenarios
- Navigating Power Apps environments, solutions, apps, and connections
- Understanding how Power Apps connects with Power Automate, Dataverse, and Microsoft 365
Module 2: Building Canvas apps
- Creating a Canvas app from a blank app or existing data source
- Working with screens, forms, galleries, controls, and navigation
- Configuring properties and behavior for common interface components
- Structuring apps so screens and controls remain understandable and maintainable
Module 3: Power Fx fundamentals
- Understanding formulas, properties, functions, and expressions in Power Fx
- Working with variables, collections, records, and tables
- Using Filter, LookUp, Sort, If, Patch, and related functions
- Building validation, conditional behavior, and simple application logic
Module 4: Connecting Canvas apps to data
- Connecting to SharePoint, Excel, Dataverse, and other supported data sources
- Working with forms to create, edit, and view records
- Using galleries and filters to browse and search data
- Understanding delegation and basic considerations when working with larger datasets
Module 5: Dataverse foundations and data modeling
- Understanding Dataverse tables, columns, rows, relationships, and choices
- Creating custom tables and configuring common column types
- Designing one-to-many and many-to-many relationships
- Structuring data for reliable business applications rather than storing everything in a single table
Module 6: Building model-driven apps
- Creating model-driven apps based on Dataverse tables
- Configuring forms, views, navigation, and related records
- Using business rules for straightforward validation and behavior
- Understanding when a model-driven approach is more suitable than a Canvas app
Module 7: Integrating Power Apps with Power Automate
- Triggering Power Automate flows from Canvas and model-driven apps
- Passing parameters from an app to a flow and returning results
- Using flows for approvals, notifications, document generation, and external integrations
- Deciding whether logic belongs in Power Apps, Power Automate, or Dataverse
Module 8: Integrating Microsoft 365 and external services
- Connecting apps with SharePoint, Teams, Outlook, and other Microsoft 365 services
- Working with standard and premium connectors
- Understanding custom connector concepts for APIs not covered by standard connectors
- Designing integrations that keep application logic and credentials manageable
Module 9: Security and access control
- Understanding environment roles, app sharing, and Dataverse security roles
- Configuring table and record access based on user responsibilities
- Distinguishing application access from access to underlying data
- Applying least privilege principles when sharing apps and data connections
Module 10: Building maintainable applications
- Applying naming conventions and consistent screen, control, and formula structures
- Reducing duplicated logic with reusable formulas and components
- Managing variables, collections, and state without unnecessary complexity
- Improving user experience with validation, error handling, loading states, and clear navigation
Module 11: Solutions and application lifecycle management
- Understanding solutions as containers for Power Apps, flows, tables, and related components
- Distinguishing unmanaged and managed solutions
- Organizing components for development, testing, and production environments
- Managing connection references, environment variables, and dependencies
Module 12: Deployment and operational readiness
- Moving applications and supporting components between environments
- Reviewing security, connections, data sources, and settings before release
- Testing applications and integrations after deployment
- Building a practical checklist for publishing, ownership, support, and ongoing maintenance