icon icon

PowerApps Intermediate

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Faster app building - You will learn how to design and develop more advanced PowerApps solutions using templates and proven practices, so you can move from idea to a working app much more efficiently.

icon

Better form handling - You will master EditForm, DisplayForm, and NewForm, along with record management and form customization, making it easier for you to build clear, practical, and reliable data screens.

icon

More intuitive interface - You will learn how to create clean layouts, custom styles, and consistent color themes, so your apps become easier to use, more readable, and more professional for end users.

icon

Smooth screen navigation - You will learn to build interactive navigation and pass data between screens, allowing you to create apps that guide users through tasks in a logical, user-friendly, and efficient way.

icon

Effective data integration - You will practice connecting PowerApps with SharePoint, SQL Server, and Dynamics 365, and explore custom connectors, so you can build apps that work with real business data sources.

icon

Stronger formula skills - You will learn to write more advanced formulas and work with collections, tables, and both global and context variables, helping you implement more complex business logic with confidence.

icon

Smarter use of media - You will discover how to optimize media and use assets from external sources, so you can enrich your apps with images, video, and other content without hurting performance.

icon

Higher performance and security - You will learn how to monitor app behavior, improve performance, troubleshoot issues, and apply security best practices, so you can build solutions that are stable and better protected.

Training programme

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.

What are the prerequisites for participating in the training?

icon

PowerApps basics - You should be comfortable navigating the PowerApps editor, know the main controls, and be able to build a simple app with at least one screen and straightforward logic.

icon

Working with data - You should understand the basics of working with data sources in PowerApps, be able to connect a list or table, and know how to read and write records at a basic level.

icon

Basic formulas - You should know the core formula concepts in PowerApps, including simple functions, conditions, and references to control properties used within an application.

icon

Interface basics - You should have experience creating simple screens, arranging controls, and configuring their properties so you can move smoothly into more advanced layouts.