Video Training Microsoft PowerApps : Mastering advanced features with variables, named formulas, and automation

Training Theme 

​This module is intended for users who want to go further in designing professional applications with Power apps. You will learn to structure your business logic using named formulas, centralize color management, create dynamic filters, control conditional visibility of elements, and modify or add data via the Patch() function. The course also includes integration with Outlook to automate email sending from your applications. Each section is based on practical case studies to make learning immediately applicable in a corporate environment. 

Training Objectives 

By the end of this training, you will able to :

• ​Use global variables, local variables, and collections to manage dynamic states within the application 
• ​Create and leverage named formulas to centralize calculations and strategic values 
• ​Define a dynamic color palette to standardize and simplify visual maintenance 
• ​Apply centralized visibility rules based on user profile 
• ​Dynamically filter data from Excel or SharePoint using conditional formulas 
• ​Modify or insert data into a SharePoint list via the Patch() function 
• ​Send automated emails with the Outlook connector, integrating dynamic fields 

Prerequisite and Target Audience 

​Target audience: Users already familiar with Power apps who wish to develop more robust and professional applications 
​Starting Level: Advanced
Prerequisites: Basic knowledge of Power apps, interface manipulation, and data integration 

Means and Methods 

• Tutorial Videos: A selected series of videos will help you achieve the defined educational objectives.
• Evaluation Quiz: A quiz will be provided at the end to validate your understanding.

Training Content 

7 tutorial videos covering PowerApps 

• First Steps with variables 
• Introduction to named formulas 
• Dynamic color palette with named formulas 
• Define centralized visibility rules 
• Create dynamic filters with named formulas 
• First steps with the patch function 
• Send an email with power apps and Outlook 

1 Course Knowledge Validation Quiz 

Learn more about Microsoft PowerApps

Power Apps revolutionizes the creation of business applications by enabling anyone—even without technical skills—to design powerful, user-friendly tools integrated into the Microsoft ecosystem. Thanks to its Power Fx language, which is similar to Excel formulas, you can automate actions, customize interactions, and build professional interfaces. This training is an ideal gateway to the world of low-code development, helping you gain agility in your projects and modernize your internal processes.