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
Course Outline
Introduction to the Microsoft Power Platform
- An overview of the Power Platform ecosystem (including Power Apps, Power Automate, Power BI, and Dataverse)
- Typical use cases in industrial and engineering sectors
- The Low-Code and No-Code paradigms and their corporate benefits
- Licensing models, environment architecture, and governance frameworks
Power Apps Fundamentals
- Distinctions between app types (Canvas vs. Model-Driven)
- Anatomy of a Canvas app: screens, components, controls, and layout design
- Common data sources: SharePoint, Excel, SQL Server, and Dataverse
- Connecting to existing data lists and libraries
- Implementing data validation and conditional logic
Practical Exercises:
- Developing an inventory management app featuring entries, outputs, and critical stock level alerts
- Creating an equipment control and calibration app with expiration date tracking and status monitoring
Automation with Power Automate
- Categories of flows: automated, instant, and scheduled
- Understanding triggers and actions: initiating flows and integrating tools
- Synchronizing with Power Apps (via buttons and trigger forms)
- Incorporating conditions, approval chains, notifications, and automated record-keeping
- Best practices for developing reusable flows
Practical Exercises:
- Automating the test request (ST) process with integrated approval steps
- Setting up automatic alerts for equipment awaiting calibration
- Implementing automatic logging for stock movements
Guided Development: Corporate Project Application
- Efficient requirements gathering with participants
- Collaborative design of real-world company screens and workflows
- Constructing functional prototypes under instructor guidance
- Validation, iterative adjustments, and simulated testing
Best Practices, Governance, and Maintenance
- Structuring environments (Development, Testing, Production)
- Managing permissions and ensuring data security
- Documenting and versioning applications and flows
- Best practices for ongoing maintenance and scalability
- Planning for solution evolution post-training
Requirements
- A solid grasp of business process workflows
- Familiarity with Microsoft 365 tools (such as SharePoint and Excel)
Target Audience
- Process owners and analysts within industrial and engineering organizations
- IT support personnel and citizen developers
- Managers seeking to automate and digitalize 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