Get in Touch
 Duration 21 hours

Course Outline

Introduction to 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 organizations.
  • The Low-Code / No-Code paradigm and its benefits for enterprises.
  • Licensing models, environment architecture, and governance frameworks.

Power Apps Basics

  • Differentiating between app types (Canvas vs. Model-Driven).
  • Anatomy of a Canvas app: screens, components, controls, and layout design.
  • Integrating with common data sources: SharePoint, Excel, SQL Server, and Dataverse.
  • Linking to existing data lists and libraries.
  • Implementing data validation rules and conditional logic.

Practical 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.

Workflow Automation with Power Automate

  • Flow categories: automated, instant, and scheduled.
  • Configuring triggers and actions to initiate flows and connect disparate tools.
  • Seamless integration with Power Apps via buttons and trigger forms.
  • Utilizing conditions, approval chains, notifications, and automated record-keeping.
  • Strategies for designing reusable flows.

Practical exercises:

  • Automating the ST test request process with integrated approval steps.
  • Setting up automatic alerts for equipment requiring calibration.
  • Implementing automated logging for stock movements.

Guided Development: Real-World Projects

  • Streamlined requirements gathering with participating team members.
  • Collaborative design of actual company screens and workflow flows.
  • Constructing functional prototypes under instructor guidance.
  • Conducting validation, refinements, and simulated testing.

Governance, Best Practices, and Maintenance

  • Structuring environments across Development, Testing, and Production stages.
  • Overseeing permissions and data security protocols.
  • Maintaining documentation and version control for apps and flows.
  • Adopting best practices for ongoing maintenance and system scalability.
  • Planning the future evolution of solutions post-course.

Requirements

  • Familiarity with business process workflows.
  • Practical experience with Microsoft 365 applications (such as SharePoint and Excel).

Target Audience

  • Process owners and analysts working in industrial or engineering sectors.
  • IT support teams and citizen developers.
  • Managers aiming to digitize and automate their operational workflows.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories