1. Description of the wide range of functions offered by PowerApps
PowerApps offers a broad function set, and effective work depends on knowing where basic capabilities end and advanced tools begin. The section refreshes core functions, then positions newer features in a practical context to support more capable application development.
- review of basic functions,
- overview of new, more advanced tools.
2. Guide to designing and building more advanced applications
From templates to ongoing management, advanced app design involves both structure and operational decisions. This section shows how predefined patterns can accelerate development, while also addressing how applications are created, organized, and maintained over time.
- working with templates,
- creating and managing applications.
3. Detailed discussion of working with forms
Working with forms requires selecting the right form type for the task and adjusting it to the record lifecycle. The material covers EditForm, DisplayForm, and NewForm, along with form customization, record management, and conditional formatting in data entry scenarios.
- types of forms (EditForm, DisplayForm, NewForm),
- modifications of forms and record management,
- application of conditional formatting.
4. Presentation of advanced settings and properties of controls in PowerApps
Control behavior in PowerApps can be shaped at runtime through properties tied to formulas. This section examines advanced control settings, with emphasis on dynamically configuring properties and using functions to make interface elements react to data and user input.
- dynamic setting of properties,
- use of functions and formulas in controls.
5. Guidelines for creating aesthetic and readable interfaces
Readable interfaces rely on consistent styling decisions rather than ad hoc formatting. Participants learn how to define custom styles and how CSS can be applied in PowerApps-related scenarios to improve clarity, visual hierarchy, and overall interface maintainability.
- creating custom styles,
- using CSS in PowerApps.
6. The process of creating a visually consistent interface through modification of available color themes
A visually consistent interface is achieved by aligning theme settings with layout structure. This part covers creating custom color themes and applying Grid and Flex techniques to organize content, helping screens remain coherent across different use cases and resolutions.
- creating custom themes,
- layout techniques (Grid, Flex).
7. Explanation of how to create applications with interactive navigation
Building intuitive movement between screens requires more than simple links. The section explains dynamic navigation patterns and shows how data can be passed between views, so user actions lead to context-aware transitions and more consistent application flow.
- dynamic navigations,
- passing data between screens.
8. Instructions for using multimedia in applications
Multimedia can enrich an app, but it also affects load time and runtime behavior. Here the focus is on optimizing media assets and using resources from external sources so that images, audio, or video support the interface without creating unnecessary overhead.
- optimization of multimedia,
- use of multimedia from external sources.
9. Discussion of methods for integrating PowerApps with various data sources
When an application must combine information from multiple systems, connector strategy becomes critical. This section explains integration with SharePoint, SQL Server, and Dynamics 365, then extends the model to custom connectors for sources not covered by standard options.
- working with SharePoint, SQL Server, Dynamics 365,
- using custom connectors.
10. Introduction to creating complex formulas in PowerApps
Complex formulas in PowerApps connect business logic with application behavior and data processing. The material covers advanced expressions, work with collections and data tables, and the use of global and context variables to control state and screen-level logic.
- creating complex formulas,
- working with collections and data tables,
- using global and context variables.
11. A set of keyboard shortcuts and techniques allowing faster and more efficient work with the PowerApps editor
Faster work in the PowerApps editor comes from reducing repetitive actions and standardizing common operations. The section focuses on keyboard shortcuts, including custom combinations, and shows how shortcut-based workflows can support small-scale task automation.
- creating your own keyboard shortcuts,
- task automation using shortcuts.
12. Practical tips on increasing application performance
Improving app performance starts with how the solution is managed and observed over time. Participants work through optimization practices, learn what affects responsiveness, and use monitoring to detect bottlenecks before they impact users or connected services.
- best practices for application management,
- performance optimization,
- monitoring application operation.
13. Discussion of best practices for securing applications
Application security depends on correctly assigned permissions, identity integration, and protection of business data. This part addresses access management in PowerApps, the role of Azure Active Directory, and methods for reducing the risk of unauthorized data exposure.
- permission management,
- integration with Azure Active Directory,
- data security.
14. Methods for detecting and resolving problems in PowerApps applications
Testing tools in PowerApps are used to trace errors, verify logic, and assess application behavior under different conditions. The section combines debugging techniques with automated testing approaches, showing how to identify issues early and validate changes in a controlled way.
- application testing tools,
- debugging techniques,
- automatic application testing.