Get in Touch

Course Outline

Introduction to the Microsoft Power Platform

  • Overview of the Power Platform ecosystem (Power Apps, Power Automate, Power BI, and Dataverse)
  • Typical use cases within industrial and engineering organizations
  • The Low-Code / No-Code paradigm and its organizational benefits
  • Licensing models, environment architecture, and governance frameworks

Foundations of Power Apps

  • Distinguishing app types (Canvas vs. Model-Driven)
  • Canvas app architecture: screens, components, controls, and layout design
  • Common data sources: SharePoint, Excel, SQL Server, and Dataverse
  • Integrating with existing data lists and libraries
  • Implementing data validation 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 tracking and status monitoring

Workflow Automation with Power Automate

  • Categorizing flow types: automated, instant, and scheduled
  • Understanding triggers and actions to initiate flows and connect tools
  • Integrating Power Apps with automation (via buttons and trigger forms)
  • Leveraging conditions, approvals, notifications, and automated record-keeping
  • Strategies for developing reusable flow templates

Practical exercises:

  • Automating the test request process (ST) including approval stages
  • Generating automatic alerts for equipment requiring calibration
  • Implementing automated logging for stock movements

Guided Development: Enterprise Projects

  • Efficient requirements gathering sessions with participants
  • Collaborative design of authentic company screens and workflows
  • Constructing functional prototypes under instructor guidance
  • Conducting validation, adjustments, and simulated testing

Best Practices, Governance, and Maintenance

  • Structuring environments (Development, Testing, Production)
  • Administering permissions and data security protocols
  • Documenting and versioning apps and flows
  • Strategies for effective maintenance and scalability
  • Planning for solution evolution post-training

Requirements

  • Familiarity with business process workflows
  • Proficiency with Microsoft 365 tools (e.g., SharePoint, Excel)

Target Audience

  • Process owners and analysts within industrial and engineering sectors
  • IT support personnel and citizen developers
  • Managers seeking to automate and digitize their workflows
 21 Hours

Testimonials (3)

Related Categories