Get in Touch
 Duration 21 hours

Course Outline

Introduction to Microsoft Power Platform

  • Overview of the Power Platform components (Power Apps, Power Automate, Power BI, and Dataverse).
  • Typical use cases in industrial and engineering contexts.
  • The Low-Code / No-Code paradigm and its benefits for corporations.
  • Licensing models, environment structure, and governance frameworks.

Power Apps Fundamentals

  • Differences between app types (Canvas vs. Model-Driven).
  • Architecture of a Canvas app: screens, components, controls, and layout design.
  • Common data sources including SharePoint, Excel, SQL Server, and Dataverse.
  • Methods for connecting to 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 that tracks expiration dates and status.

Automation with Power Automate

  • Categories of flows: automated, instant, and scheduled.
  • Triggers and actions: initiating flows and connecting external tools.
  • Integration techniques with Power Apps (buttons and trigger forms).
  • Utilizing conditions, approvals, notifications, and automated record-keeping.
  • Best practices for designing reusable flows.

Practical Exercises:

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

Guided Development: Company Projects

  • Rapid requirements gathering sessions with participants.
  • Collaborative design of real-world company screens and flows.
  • Construction of functional prototypes under instructor supervision.
  • Validation, adjustment, and execution of simulated tests.

Best Practices, Governance, and Maintenance

  • Structuring environments (Development, Testing, Production).
  • Managing permissions and ensuring data security.
  • Documentation and version control for apps and flows.
  • Strategies for maintenance and scalability.
  • Planning for solution evolution post-course.

Requirements

  • A fundamental understanding of business process workflows.
  • Familiarity with Microsoft 365 tools, such as SharePoint and Excel.

Target Audience

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories