This intensive two-day training program is designed for individuals already working with Power Apps who are committed to advancing their technical expertise and developing professional-grade business solutions. Specifically targeted at "citizen developers" (subject matter experts with limited formal IT training) who build applications independently or collaborate with professional development teams, this course elevates your Power Apps and Power Automate capabilities. Throughout the curriculum, you will master best practices for designing both Model-Driven applications utilizing Dataverse and canvas-based applications that integrate with diverse data sources, including Azure SQL databases, SharePoint Online repositories, Excel workbooks, and OneDrive for Business storage.
Required Prerequisites:
Participants should maintain practical working knowledge of Microsoft Excel, Microsoft Office 365 applications, and SharePoint Online environments. Additionally, attendance of ONLC's Power Apps: Introduction for End Users course, or equivalent hands-on experience developing Power Apps applications and Power Automate workflows, is strongly recommended before enrolling in this advanced offering.
Complete Course Curriculum:
Microsoft Power Platform Architecture and Foundation
- Microsoft Power Platform overview and ecosystem components
- Business value propositions and organizational benefits
- Data Connectors architecture and integration patterns
- Data loss prevention, regulatory compliance, privacy considerations, and accessibility requirements
Dataverse Table Creation and Data Storage
- Microsoft Dataverse introduction and platform capabilities
- Table structure and design characteristics
- Dual-write functionality versus virtual table implementation
- Dataverse auditing and change tracking
- Exercise: Creating Microsoft Dataverse tables with proper configuration
- Data import procedures and bulk data loading into Dataverse
- Exercise: Custom table creation and data migration from external sources
Dataverse Table Administration and Management
- Identifying standard tables and custom table types in Dataverse
- Custom table design and creation procedures
- File attachment enablement within tables
- Licensing requirements and cost implications by table type
- Lab: Custom table creation and attachment functionality configuration
Dataverse Column Definition and Data Modeling
- Column types and data type definitions in Microsoft Dataverse
- Adding columns to existing table structures
- Primary name column design and requirements
- Column restrictions and data validation constraints
- Auto-numbering column implementation for unique identifier generation
- Alternate key creation for unique record identification
- Hands-on exercises and configuration practice
Table Relationships and Relational Data Architecture
- Establishing relationships between multiple tables
- Available relationship types in Microsoft Dataverse
- One-to-many relationship configuration and use cases
- Many-to-many relationship design and implementation
- Editing and removing relationships from existing table structures
- Exercise: Multi-table architecture with one-to-many relationships
Dataverse Choice Columns and Dropdown Lists
- Choice column definition and configuration
- Standard choice column implementation
- Lab: Choice creation and modification of existing choice configurations
Dataverse Security Architecture and Role Management
- Environment role types and their organizational functions
- Environment role understanding and role hierarchy
- User provisioning, deprovisioning, and account management
- Dataverse security concepts and threat model
- User security role assignment and default role permissions
- Exercise: Custom security role creation and permission assignment
- User security role verification and auditing
- Dataverse team security configuration for group-based access control
- Dataverse group team setup for organizational security governance
Model-Driven Application Development in Power Apps
- Model-driven app architecture and design philosophy
- Model-driven application building blocks and components
- Application design principles and best practices
- Exercise: Application design and configuration
- Exercise: Model-driven app sharing and security implementation
- Business process flow integration and workflow automation
- Exercise: Complete model-driven application creation
Model-Driven App UI Configuration
- Form design and form element configuration
- Form component types and specialized form controls
- Multiple form configuration and conditional display
- Specialized form components and custom controls
- View design and view configuration methodology
- Grid configuration and data display options
- Specialized view types and custom views
- Chart configuration and data visualization
- Dashboard design and interactive dashboard components
- Interactive streams and tile components for user engagement
Power Automate Fundamentals and Flow Creation
- Power Automate introduction and automation benefits
- Exercise: Creating your first automated workflow
- Exercise: Designing recurring execution flows
- Exercise: Email trigger configuration and response automation
- Exercise: Flow sharing and collaborative development
- Flow troubleshooting and debugging techniques
Dataverse Integration with Power Automate
- Dataverse trigger types and available triggers
- Trigger configuration and event-based automation
- Work with Dataverse actions and action invocation
Advanced Dataverse Extension with Power Automate
- Integration architecture for Dataverse and Power Automate
- Flow trigger configuration and setup
- Email automation for Dataverse records
- Automated to-do item creation and task management
- Flow testing, validation, and execution
Power Automate Expression and Formula Development
- Expression language fundamentals and syntax
- Expression creation and evaluation
- Documentation best practices for maintainability
- Function types and function categories
- Complex expression composition and conditional logic
- Exercise: Manual workflow creation with expression implementation
