Course Outline
🔹 Module 1 – Introduction to Microsoft Power Platform
- Comprehensive review of the Power Platform components, including Power Apps, Power Automate, Power BI, and Dataverse
- Application scenarios relevant to industrial and engineering sectors
- Principles of low-code and no-code development and their operational benefits
- Licensing models, environment architecture, and governance standards for government
🔹 Module 2 – Power Apps Fundamentals
- Distinction between app types: Canvas versus Model-Driven
- Architectural elements of Canvas apps: screens, components, controls, and layout configuration
- Integration with common data sources: SharePoint, Excel, SQL Server, and Dataverse
- Procedures for connecting to existing data lists and libraries
- Implementation of data validation rules and conditional logic
Practical exercises:
- Development of an inventory management application featuring entry/exit tracking and critical level alerts
- Construction of an equipment control and calibration app with expiration date monitoring and status tracking
🔹 Module 3 – Automation with Power Automate
- Classification of flows: automated, instant, and scheduled
- Configuration of triggers and actions for flow initiation and tool connectivity
- Integration mechanisms with Power Apps, including buttons and trigger forms
- Use of conditions, approval workflows, notifications, and automated record-keeping
- Best practices for designing reusable flows
Practical exercises:
- Automation of the test request process (ST) incorporating multi-step approval workflows
- Establishment of automatic alert systems for equipment awaiting calibration
- Implementation of automatic logging for inventory movements
🔹 Module 4 – Guided Development: Company Projects
- Rapid requirements gathering sessions with participants
- Collaborative design of operational screens and workflows
- Construction of functional prototypes under instructor supervision
- Execution of validation, adjustment, and simulated testing protocols
🔹 Module 5 – Best Practices, Governance, and Maintenance
- Structuring environments: Development, Testing, and Production
- Administration of permissions and data security protocols
- Documentation and version control strategies for applications and flows
- Best practices for ongoing maintenance and system scalability
- Strategic planning for solution evolution post-training
Summary and Recommended Next Steps
Requirements
- Proficiency in understanding business process workflows
- Familiarity with Microsoft 365 tools, including SharePoint and Excel
Intended Audience
- Process owners and analysts in industrial and engineering organizations
- IT support personnel and citizen developers
- Managers responsible for workflow automation and digital transformation
Testimonials (3)
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
Sinzala Sichaanji - Bank of Zambia
Course - Mastering Power Platform: Power Apps, Power Automate, DataVerse, Power BI, and Power Virtual Agents
We did quite complex examples, so we could get a feeling of how the real work with Power Automate Desktop can look like in the real world scenario.
Michal Strnad - MicroNova AG
Course - Microsoft Flow/Power Automate
Dynamic, adaptive, and informative