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, including Power Apps, Power Automate, Power BI, and Dataverse
- Typical use cases in industrial and engineering organizations
- The concept of Low-Code / No-Code development and its benefits for corporations
- Details on licensing, environment architecture, and governance
Essentials of Power Apps
- Distinguishing between app types (Canvas vs. Model-Driven)
- Analyzing the structure of Canvas apps: screens, components, controls, and layout
- Connecting to common data sources: SharePoint, Excel, SQL Server, and Dataverse
- Linking to pre-existing data lists and document libraries
- Implementing data validation and conditional logic
Practical exercises:
- Building an inventory management application featuring input entries, output displays, and critical level alerts
- Developing an equipment control and calibration app with expiration date tracking and status monitoring
Workflow Automation via Power Automate
- Categories of flows: automated, instant, and scheduled
- Configuring triggers and actions: initiating flows and connecting disparate tools
- Integrating with Power Apps through buttons and trigger forms
- Utilizing conditions, approvals, notifications, and automatic record creation
- Strategies for designing reusable and efficient flows
Practical exercises:
- Streamlining the test request process (ST) with integrated approval steps
- Generating automatic alerts for equipment awaiting calibration
- Automating the logging of inventory movements
Supervised Development: Corporate Projects
- Efficient requirements gathering sessions with participants
- Collaborative design of screens and flows for actual company scenarios
- Constructing functional prototypes under instructor guidance
- Conducting validation, refinement, and simulated testing
Best Practices, Governance, and Maintenance
- Structuring environments (Development, Testing, and Production)
- Oversight of permissions and data security protocols
- Maintaining documentation and version control for applications and flows
- Adhering to best practices for ongoing maintenance and scalability
- Strategizing the evolution of solutions following the course completion
Requirements
- A solid grasp of business process workflows
- Proficiency with Microsoft 365 tools (such as SharePoint and Excel)
Target Audience
- Process owners and analysts within industrial and engineering sectors
- IT support personnel and citizen developers
- Managers aiming 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