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.
  • Typical use cases within industrial and engineering organizations.
  • The concept of Low-Code / No-Code development and its strategic benefits for enterprises.
  • Understanding licensing models, environment architecture, and governance structures.

Power Apps Fundamentals

  • Differentiating between app types: Canvas versus Model-Driven.
  • Anatomy of a Canvas app: understanding screens, components, controls, and layout design.
  • Connecting to common data sources such as SharePoint, Excel, SQL Server, and Dataverse.
  • Integrating with existing data lists and document libraries.
  • Implementing data validation and conditional logic.

Practical exercises:

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

Automation with Power Automate

  • Exploring different flow types: automated, instant, and scheduled.
  • Configuring triggers and actions to initiate flows and connect various tools.
  • Integrating seamlessly with Power Apps via buttons and trigger forms.
  • Utilizing conditions, approval workflows, notifications, and automated record-keeping.
  • Adopting best practices for creating reusable and efficient flows.

Practical exercises:

  • Automating the testing request process (ST) with integrated approval steps.
  • Generating automatic alerts for equipment pending calibration.
  • Implementing automatic logging for stock movements.

Guided Development: Company Projects

  • Efficient requirements gathering sessions with participants.
  • Collaborative design of real-world company screens and workflow flows.
  • Constructing functional prototypes under instructor guidance.
  • Conducting validation, making necessary adjustments, and running simulated tests.

Best Practices, Governance, and Maintenance

  • Structuring environments effectively across Development, Testing, and Production phases.
  • Overseeing permissions and ensuring robust data security.
  • Maintaining comprehensive documentation and version control for apps and flows.
  • Following best practices for ongoing maintenance and system scalability.
  • Strategizing the evolution and future growth of solutions post-training.

Requirements

  • A solid grasp of business process workflows.
  • Proficiency with Microsoft 365 tools, such as SharePoint and Excel.

Target Audience

  • Process owners and analysts within industrial and engineering sectors.
  • IT support personnel and citizen developers.
  • Managers seeking to drive workflow automation and digital transformation.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories