Course Outline
🔹 Module 1 – Introduction to Microsoft Power Platform
- Overview of the Power Platform (Power Apps, Power Automate, Power BI, and Dataverse).
- Common use cases within industrial and engineering companies.
- The low-code/no-code concept and its corporate advantages.
- Licensing, environment structure, and governance.
🔹 Module 2 – Power Apps Fundamentals
- Application types (Canvas vs. Model-Driven).
- Structure of a Canvas app: screens, components, controls, and layout.
- Common data sources: SharePoint, Excel, SQL Server, Dataverse.
- Connecting to existing data lists and libraries.
- Data validation and conditional logic.
Hands-on exercises:
- Creating an inventory management application with entries, outputs, and critical level alerts.
- Developing an equipment control and calibration application featuring expiration dates and status tracking.
🔹 Module 3 – Automation with Power Automate
- Types of flows: automated, instant, and scheduled.
- Triggers and actions: initiating flows and connecting tools.
- Integration with Power Apps (buttons and trigger forms).
- Conditions, approvals, notifications, and automated record creation.
- Best practices for creating reusable flows.
Hands-on exercises:
- Automating the test request process (ST) with approval steps.
- Setting up automatic alerts for equipment pending calibration.
- Automatically logging stock movements.
🔹 Module 4 – Guided Development: Company Projects
- Rapid requirements gathering with participants.
- Collaborative design of real company screens and flows.
- Building functional prototypes under instructor supervision.
- Validation, adjustments, and simulated testing.
🔹 Module 5 – Best Practices, Governance, and Maintenance
- Organizing environments (Development, Testing, Production).
- Managing permissions and data security.
- Documentation and versioning of apps and flows.
- Best practices for maintenance and scalability.
- Planning for solution evolution post-course.
Summary and Next Steps
Requirements
- A working knowledge of business process workflows.
- Experience using Microsoft 365 tools (e.g., SharePoint, Excel).
Audience
- Process owners and analysts in industrial and engineering sectors.
- IT support staff and citizen developers.
- Managers seeking to automate and digitize workflows.
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
