Classroom/ Online: Yes/ No
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
2-Day Advanced Automation - Mastering Power Apps and Power Automate
Elevate your Power Platform capabilities. This advanced-level course is designed for professionals who are ready to go beyond the basics and build resilient, high-performing business solutions. You'll gain hands-on experience in crafting complex apps and automating critical workflows—without writing traditional code.
Across two immersive days, you'll dive into advanced topics such as component libraries, custom connectors, dynamic data processing, and integrating external APIs. With a focus on real-world applications, you'll learn how to design, troubleshoot, and deploy scalable Power Apps and automated flows that meet enterprise standards.
Whether you're driving operational efficiency, integrating systems across your organization, or scaling up your automation strategy, this course equips you with the advanced skills and confidence to deliver impactful, production-ready solutions using Microsoft’s Power Platform.
This is an advanced Power Platform course:
Across two immersive days, you'll dive into advanced topics such as component libraries, custom connectors, dynamic data processing, and integrating external APIs. With a focus on real-world applications, you'll learn how to design, troubleshoot, and deploy scalable Power Apps and automated flows that meet enterprise standards.
Whether you're driving operational efficiency, integrating systems across your organization, or scaling up your automation strategy, this course equips you with the advanced skills and confidence to deliver impactful, production-ready solutions using Microsoft’s Power Platform.
This is an advanced Power Platform course:
- Have completed the " Create and Automate - Power Apps and Power Automate for Everyday Users" course
- Be familiar with Power Apps or Power Automate
- Participants are required to
- Bring an Internet enabled laptop for hands-on exercises, and
- Require WEB BASED "https://office.com"access to Microsoft 365 apps, including SharePoint, Power Apps, Power Automate, Outlook Email, Teams, Forms – no software installation is required
- Microsoft 365 account will be provided during training period for all trainees
Objective
- Build and manage reusable UI elements: Using Power Apps Component Libraries and custom components to streamline app development and ensure consistency across solutions.
- Integrate Power Automate flows with Microsoft Teams: Post approval requests and updates to Teams bots, enhancing collaboration and decision-making in real-time.
- Implement robust data validation techniques: Ensure accurate data entry and reduce errors in form submissions in Power Apps.
- Leverage dynamic data in flows: Create adaptable, context-aware automation that responds intelligently to varying inputs and business scenarios.
- Use advanced expressions and functions in flows: manipulate data, perform calculations, and drive complex logic without writing traditional code.
- Connect securely to external APIs: Use Power Automate to retrieve or send data, enabling seamless integration with third-party systems and services.
- Apply error handling and troubleshooting techniques: Leverage Power Apps and Power Automate to identify issues, handle runtime exceptions, and ensure stable, production-ready deployments.
Outline
Day 1
Day 2
- Component Libraries & Custom Components
- Creating and managing component libraries
- Designing reusable components
- Sharing and reusing components across apps
- Best practices for maintainability and scalability
- Power Automate and Microsoft Teams Integration
- Sending messages and approvals to Teams bots
- Creating approval workflows that notify Teams channels
- Triggering flows from Teams messages or commands
- Advanced Data Handling in Power Apps
- Data validation strategies and logic implementation
- Conditional formatting and dynamic control behavior
Day 2
- Advanced Power Automate Concepts
- Using expressions and functions in flows
- Dynamic content handling and manipulation
- Structuring complex logic with conditions and loops
- Working with External APIs in Flows
- Making HTTP requests in Power Automate
- Parsing API responses using JSON
- Securing and managing API connections
- Error Handling and Troubleshooting Techniques
- Common flow and app failure scenarios
- Adding error-handling branches and fallback
- Logging, alerts, and monitoring tools
Who should attend
This course is intended for:
- Power Platform users with prior experience in Power Apps and Power Automate who are ready to deepen their technical expertise and take on more complex automation challenges
- IT professionals, solution architects, and developers looking to design, implement, and maintain scalable, enterprise-grade Power Platform solutions
- Business analysts and citizen developers who have built basic apps or flows and now want to incorporate advanced logic, external integrations, and reusable components into their solutions
Methodology
Participants engage in immersive learning experiences, where they apply advanced development techniques and workflow design principles in simulated business scenarios. Instructors provide personalized guidance and feedback, fostering an environment conducive to skill mastery and knowledge retention.
Profile of Peter Goh
Peter Goh embarked on his illustrious teaching journey in 1990, assuming the role of an IT Instructor in secondary schools. His commitment to education led him to serve at Tanjong Katong Girls' School and subsequently Anderson Secondary School, where he imparted fundamental IT and internet skills to students. Throughout his evolving career, Peter has donned multiple hats in the IT domain, holding positions such as Systems Administrator, Programmer, Systems Architect, IT Project Manager, and Chief Technology Officer.
Peter's extensive expertise is underscored by a plethora of certifications, including Certified Scrum Product Owner (CSPO) and Certified Scrum Master (CSM) from the Scrum Alliance, Certified Cloud Practitioner from Amazon Web Services (AWS), and Certified Azure Fundamentals from Microsoft. Additionally, he boasts a WSQ ACTA certification, demonstrating his prowess as a trainer.
Demonstrating his prowess as a seasoned developer, Peter has contributed to diverse projects for prominent entities like the Peoples' Association and ST Engineering, as well as small to medium-sized businesses such as Fancl, Olam, Heinz, Watsons, KBox, and Sakae Sushi. His portfolio encompasses the development of web-based applications and native mobile apps for both Android and iOS platforms. Leveraging his proficiency, Peter has also conducted training sessions on various programming languages, including Java, C#, Swift, Angular, React, and Flutter, along with courses on systems and cloud topics. He imparts knowledge at Authorized Training Organizations (ATOs) and serves as an adjunct faculty member at Ngee Ann Polytechnic.
