Course

Advanced Automation Techniques with Power Apps and Power Automate

Overview

Elevate your automation expertise with this advanced course, tailored for learners who already possess a foundational knowledge of the Power Platform. Dive deeper into building sophisticated, scalable, and secure solutions that drive greater impact and efficiency across your organization.

Who Should Attend

This course is intended for

  • Analysts and managers who want to replace a paper-based or excel business process into an application-driven process and to quickly create an application for their business without any code
  • People who are interested to build their own web and phone based apps, with minimal coding

Pre-requisites

  • Has completed A Beginner’s Guide To Automation with Power Apps and Power Automate course – ESSENTIAL REQUIREMENT.
  • Participants are required to bring their own laptop PC or MacBook for the practical hands-on portions of the workshop.
  • Participants will require access to Power Apps, Power Automate, Outlook Email and SharePoint through licenses in their corporate/enterprise Microsoft 365 accounts.

Advanced Automation Techniques with Power Apps and Power Automate

Enroll Now

3 Days

24 Hours

Course Fee

Entry Requirements

Ideal for working professionals who wants to automate processes in the company of department

Certificate Completing the Course

You will be receiving the course completion certificate upon completing the course.

What You Will Learn

Leverage Dynamic Data And Advanced Functions

Use dynamic content and expressions to create responsive, data-driven solutions and utilize built-in and custom functions to manipulate data, drive logic, and enhance app and flow behavior.

Create and Use Custom Controls

Build reusable, dynamic components to standardize UI elements and streamline development.

Implement Robust Data Validation Techniques

Ensure data integrity and accuracy through advanced validation rules and conditional logic within Power Apps.

Publish and Use Power Apps Directly Within Microsoft Teams

Seamlessly deploy applications to Teams for enhanced collaboration and accessibility.

Implement Error Handling and Troubleshooting Techniques

Develop resilient apps and flows by capturing, logging, and managing errors effectively during runtime.

Connect to External APIs

Set up and use custom connectors to integrate third-party APIs, extending the capabilities of your apps and flows.

Apply Responsive Design Techniques in Power Apps

Design applications that adapt gracefully to different screen sizes and devices for an optimal user experience across platforms.

Integrate Microsoft Forms with Power Automate

Automatically trigger flows from Microsoft form.

Monitor and Optimize App and Flow Performance

Analyze performance metrics and apply optimization strategies to improve speed, efficiency, and scalability.

Course Outline

Day 1
  • Advanced Functions and Dynamic Data
    • Using expressions and formulas
    • Using dynamic content
    • Data manipulation techniques
  • Creating and Using Custom Components
    • Understanding custom components and custom properties
    • Building reusable components with component libraries
    • Parameterizing components for flexibility
  • Data Validation and Business Logic
    • Implementing field-level and form-level validations
    • Using conditional logic and error messages
    • Real-time validation vs. post-submission validation
Day 2
  • Responsive Design in Power Apps
    • Principles of responsive UI design
    • Importance of responsive design
    • Enabling responsive layout
    • Working with layout containers and screen size breakpoints
    • Designing for desktop, tablet, and mobile
  • Publishing to Microsoft Teams
    • Integrating within Teams
    • Deployment options and permissions
    • Managing app access and updates
  • Integration with Microsoft Forms
    • Triggering flows from Forms submissions
    • Parsing and storing Forms data
Day 3
  • Connecting to External APIs
    • Introduction to custom connectors
    • Authentication methods (API keys, OAuth)
    • Using HTTP actions in flows
  • Error Handling and Troubleshooting
    • Error detection and handling in flows
    • Using Try-Catch pattern with scopes
    • Logging and notification techniques
  • Performance Monitoring and Optimization
    • Performance best practices in Power Apps
    • Optimizing data sources and queries
    • Monitoring tools

Professional Certificates

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Bronze

Get a Bronze Certificate for students who takes up to 4 courses

Silver

Get a Silver Certificate for students who takes up to 6 courses

Gold

Gain a Gold Certificate for students who takes up to 9 courses

Trainers Profile

Peter goh

Peter Goh

Peter Goh is an experienced system administrator, developer, trainer, and consultant with over 20 years of expertise in cutting-edge software development. He specializes in creating and deploying customized applications for desktop, web, and mobile platforms. Additionally, he is an ACTA certified trainer.