Get in Touch

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 sectors
  • The Low-Code and No-Code paradigm and its benefits for the enterprise
  • Licensing models, environment architecture, and governance frameworks

Power Apps Fundamentals

  • Differentiating between app types (Canvas vs. Model-Driven)
  • The architecture of Canvas apps: screens, components, controls, and layout design
  • Common data sources: SharePoint, Excel, SQL Server, and Dataverse
  • Establishing connections to existing data lists and libraries
  • Implementing data validation and conditional logic

Practical exercises include:

  • 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

Automation with Power Automate

  • Flow types: automated, instant, and scheduled
  • Triggers and actions: initiating flows and integrating various tools
  • Integration with Power Apps through buttons and triggered forms
  • Utilizing conditions, approvals, notifications, and automated record keeping
  • Best practices for designing reusable flows

Practical exercises include:

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

Guided Development: Company Projects

  • Efficient requirements gathering with participants
  • Collaborative design of actual company screens and workflows
  • Construction of functional prototypes under instructor supervision
  • Validation, refinement, and simulated testing

Best Practices, Governance, and Maintenance

  • Organizing environments for Development, Testing, and Production
  • Managing permissions and ensuring data security
  • Documentation and version control for apps and flows
  • Best practices for ongoing maintenance and scalability
  • Planning for solution evolution following the course

Requirements

  • A solid understanding of business process workflows
  • Practical experience with Microsoft 365 tools (such as SharePoint and Excel)

Target Audience

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

Testimonials (3)

Related Categories