Get in Touch
 Duration 21 hours (3 days)

Course Outline

Introduction to the Microsoft Power Platform

  • An overview of the Power Platform components (Power Apps, Power Automate, Power BI, and Dataverse)
  • Common use cases within industrial and engineering contexts
  • The Low-Code / No-Code concept and its corporate benefits
  • Licensing structures, environment architecture, and governance

Power Apps Fundamentals

  • Differentiating app types (Canvas versus Model-Driven)
  • The structure of a Canvas app: screens, components, controls, and layout
  • Common data sources including SharePoint, Excel, SQL Server, and Dataverse
  • Connecting to existing data lists and libraries
  • Data validation techniques and conditional logic

Practical exercises:

  • Developing an inventory management app featuring entries, outputs, and critical level alerts
  • Building an equipment control and calibration app with expiration dates and status tracking

Automation with Power Automate

  • Categorising flow types: automated, instant, and scheduled
  • Triggers and actions: initiating flows and connecting tools
  • Integration with Power Apps (buttons and trigger forms)
  • Implementing conditions, approvals, notifications, and automated records
  • Best practices for creating reusable flows

Practical exercises:

  • Automating the test request process (ST) with built-in approval steps
  • Generating automatic alerts for equipment pending calibration
  • Implementing automatic logging of stock movements

Guided Development: Company Projects

  • Rapid requirements gathering with participants
  • Collaborative design of real company screens and flows
  • Constructing functional prototypes under instructor supervision
  • Validation, adjustments, and simulated testing

Best Practices, Governance, and Maintenance

  • Organising environments (Development, Testing, Production)
  • Managing permissions and data security
  • Documentation and versioning of apps and flows
  • Best practices for ongoing maintenance and scalability
  • Planning solution evolution post-training

Requirements

  • A foundational understanding of business process workflows
  • Familiarity with Microsoft 365 tools (e.g., SharePoint, Excel)

Audience

  • Process owners and analysts within industrial and engineering enterprises
  • IT support staff and citizen developers
  • Managers seeking to automate and digitise workflows

Testimonials (3)

Upcoming Courses

Related Categories