Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours (3 days)
Course Outline
Introduction to the Microsoft Power Platform
- An overview of the Power Platform, including Power Apps, Power Automate, Power BI, and Dataverse.
- Typical use cases within industrial and engineering companies.
- The concept of Low-Code / No-Code development and its benefits for corporate efficiency.
- Licensing models, environment structures, and governance frameworks.
Power Apps Fundamentals
- Differentiating between app types (Canvas vs. Model-Driven).
- The structure of a Canvas app, covering screens, components, controls, and layout.
- Common data sources such as SharePoint, Excel, SQL Server, and Dataverse.
- Methods for connecting to existing data lists and libraries.
- Implementing data validation and conditional logic.
Hands-on exercises:
- Building an inventory management app featuring entries, outputs, and critical level alerts.
- Developing an equipment control and calibration app with expiration date tracking and status monitoring.
Automation with Power Automate
- Understanding flow types: automated, instant, and scheduled.
- Managing triggers and actions to initiate flows and connect various tools.
- Integrating with Power Apps through buttons and trigger forms.
- Incorporating conditions, approvals, notifications, and automated record-keeping.
- Best practices for creating reusable flows.
Hands-on exercises:
- Automating the test request process (ST) with defined approval steps.
- Setting up automatic alerts for equipment awaiting calibration.
- Implementing automatic logging of stock movements.
Guided Development: Company Projects
- Rapid requirements gathering directly with participants.
- Collaborative design of real-world company screens and flows.
- Construction of functional prototypes under instructor supervision.
- Validation, adjustments, and simulated testing procedures.
Best Practices, Governance, and Maintenance
- Organizing environments into Development, Testing, and Production stages.
- Managing permissions and ensuring data security.
- Documentation and versioning strategies for apps and flows.
- Best practices for ongoing maintenance and scalability.
- Planning for solution evolution and future enhancements after the course.
Requirements
- A solid understanding of business process workflows.
- Practical experience with Microsoft 365 tools, such as SharePoint and Excel.
Target Audience
- Process owners and analysts within industrial and engineering sectors.
- IT support staff and citizen developers.
- Managers seeking to automate and digitize their 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