Mastering PowerApps and Power Automate.
Course overview.
MASTERING POWERAPPS AND POWER AUTOMATE TRAINING MALAYSIAThis training program offers an in-depth exploration of Robotic Process Automation (RPA) using Microsoft’s Power Automate and Power Apps. Participants will learn to automate repetitive tasks, create complex business process flows, and develop custom applications that integrate seamlessly with existing data sources and workflows. The course is designed for professionals looking to enhance their skills in automation, application development, and data management, empowering them to transform business processes and improve operational efficiency.
Key takeaways.
MASTERING POWERAPPS AND POWER AUTOMATE TRAINING MALAYSIABy the end of the course, participants will:
- Comprehensive Understanding of RPA and Power Automate: Learn the fundamentals of RPA, how to choose the right automation tools, and gain a detailed understanding of Power Automate’s interface and capabilities.
- Flow Creation and Automation: Master the creation of automated and business process flows, including handling various data types, variables, and real-world case studies.Work with triggers, actions, conditions and approvals
- PowerApps Development: Develop your skills in creating powerful applications using PowerApps, from basic setups to advanced UI/UX design, and integrate these apps with data sources.Use different data connectors in flows
- AI Integration and Advanced Features: Explore the AI Builder in Power Automate, and learn how to apply AI models to enhance your workflows and applications.
- Administration and Security: Gain expertise in administering, securing, and maintaining Power Automate and PowerApps, ensuring robust and scalable solutions for your organization.
Who should attend.
Analysts, managers, reporting professionals, executives and business owners working with business workflows, including directors, general managers, finance, sales, HR and data analytics managers, business analysts and BI professionals.
Prerequisites.
No prior knowledge of programming is required.
The programme.
MASTERING POWERAPPS AND POWER AUTOMATE TRAINING MALAYSIASESSION 1Introduction To Robotic Process Automation (rpa) And Power Automate
This module will give a brief introduction to RPA. You will also understand when and why to choose RPA and a detailed view of its working and implementation. This module will also introduce you to how to start using Power Automate and the capabilities of Power Automate.
- Benefits of automation and the concept of RPA
- Introduction to Power Automate
- Understanding different Power Automate flows
- Understanding the different parts of the Power Automate interface
- How to trigger a flow in Power Automate?
- Creating a simple flow
SESSION 2Creating Automated Flows
In this module, participants will learn how to create regular automated flows. The following are some of the flows that the participants would be exposed to:
- Concept of actions, data types and variables case studies
- Sending email notifications
- Manipulating Excel files
- Copying and storing files (OneDrive, SharePoint)
SESSION 3Creating Business Process Flows
In this module, participants will learn how to create a business process flow for a sales process.
- Introduction to business process flows
- Difference between regular flows and business process flows
- Case study: Creating a sales process flow
- Using templates in Power Automate
SESSION 4Administrating Power Automate
In this module, understand the various ways of how to administer automate and secure your flow.
- Maintaining Power Automate
- Introduction to Power Automate security
- Sharing a Power Automate project/flow
- Data policies in Power Automate
SESSION 5AI Builder
In this module, participants will have a chance to look at how the AI builder works and the different models available to perform operations
- Introduction to AI Builder
- Various models available in the AI Builder
- Demo on how to use AI Builder with flows
SESSION 6Introduction To Powerapps
In this module, participants will understand the main components of application design, what PowerApps is all about and the high-level features of PowerApps.
- What is PowerApps?
- Pros and cons of using PowerApps
- Setting up PowerApps
- Understanding Canvas vs Model Driven Apps
SESSION 7Using Powerapps To Build Applications
In this module, the participants will learn how to create simple applications and understand the various operations available
- Looking at PowerApps templates
- Introduction to controls and formulas
- Using templates in Power Automate
- Basic App settings
- Saving Apps in Microsoft PowerApps
SESSION 8Creating A Better Ui/ux For Your Applications
In this module, participants will understand the best practices of front-end design and the UI/UX associated with an application
- Exploring fonts, screen colors and multiple screens
- Adding buttons and icons to your application
- Sizing and alignment
SESSION 9Powerapps Control
In this module, participants will have a chance to explore and use various categories of controls while building the application.
- Form controls – dropdown, radio buttons, dates and more
- Charts for information presentation
- Text controls and validations
- App Creation Milestone: At this point, create a simple application with all the knowledge gained thus far.
SESSION 10Connecting Apps To Data Sources
In this module, participants will understand the how to connect PowerApps to the different data sources available – files, databases and others. Participants will bring in and write to data sources.
- Data sources available in PowerApps
- Connecting to a data source to import data
- Dumping data from an app to a data sink
- Integrating with SharePoint and Web APIs
SESSION 11Model Driven Applications
In this module, participants will understand and explore model drive power apps
- What is a Model Driven App?
- Exploring Model Driven App Templates
- Creating a site map for the application
- Understanding flows in Model Driven Apps
SESSION 12Powerapps Administration And Integration
In this module, participants will learn how to administer and maintain PowerApps and integrate with downstream applications
- Integrate PowerApps with flows/other tools
- Access control in PowerApps
- Reviewing App usage and users
Throughout the workshop, participants will work through practical exercises to enhance their knowledge of the tools available to build PowerApps and Power Automate flows
Your trainer.
MASTERING POWERAPPS AND POWER AUTOMATE TRAINING MALAYSIAAlvin Yong is a UK-registered Fellow Chartered and Certified Accountant (FCCA). He obtained his Master of Science in Professional Accountancy (Merit) in 2017 from the University of London.
To bring.
MASTERING POWERAPPS AND POWER AUTOMATE TRAINING MALAYSIAReviews from our Malaysian clients.
MASTERING POWERAPPS AND POWER AUTOMATE TRAINING MALAYSIA“Content is very good, notes are sufficiently detailed, presentation is clear and pace is good. Alvin entertained questions calmly, clearly, and with sufficient depth. Very knowledgeable and qualified for the training subject.”
“Alvin is an excellent trainer. He led interesting, interactive and focused discussions during the workshop.”
“Alvin was well prepared, knowledgeable and easy to follow. Level of detail was where it needed to be and the documentation was very thorough. The course went quickly which was always a good sign.”
“Fantastic trainer in terms of knowledge and skills. Extremely friendly, helpful and patient.”
“Good understanding and knowledge of the subject. Attentive and responsive to participants' queries. Presented the subject very clearly.”
“The trainer is knowledgeable. He was helpful. He handled the class material well.”
“Very informative. Gave an excellent count of how-to's.”
“Alvin is a very people person. Sound knowledge in his area of expertise. He carried out the programme well.”
Related courses.
AUTOMATIONReady when your team is.
Public runs across the region and live online — or we scope an internal cohort around your actual reports.
Enquire about in-house training