Get in Touch
 Duration 21 hours (3 days)

Course Outline

Introduction to Microsoft Power Platform

  • Overview of the Power Platform (including Power Apps, Power Automate, Power BI, and Dataverse).
  • Common use cases within industrial and engineering companies.
  • Understanding Low-Code and No-Code concepts and their corporate benefits.
  • Insights into licensing, environment structure, and governance.

Power Apps Fundamentals

  • Types of apps (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 with input/output handling and critical level alerts.
  • Creating an equipment control and calibration app with expiration date tracking and status monitoring.

Automation with Power Automate

  • Flow types: automated, instant, and scheduled.
  • Triggers and actions: Initiating flows and integrating tools.
  • Integration with Power Apps (via buttons and trigger forms).
  • Utilising conditions, approvals, notifications, and automated record-keeping.
  • Best practices for developing reusable flows.

Practical exercises:

  • Automating the test request process (ST) with defined approval steps.
  • Setting up automatic alerts for equipment pending calibration.
  • Implementing automatic logging for stock movements.

Guided Development: Company Projects

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

Best Practices, Governance, and Maintenance

  • Organisation of environments (Development, Testing, and Production).
  • Management of permissions and data security.
  • Documentation and version control for apps and flows.
  • Best practices for ongoing maintenance and scalability.
  • Strategic planning for solution evolution post-training.

Requirements

  • Familiarity with business process workflows.
  • Proficiency with Microsoft 365 tools (such as SharePoint and Excel).

Target Audience

  • Process owners and analysts in industrial and engineering sectors.
  • IT support personnel and citizen developers.
  • Managers seeking to automate and digitise their workflows.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories