PowerApps Intermediate

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?

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.

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.

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.

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.

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.

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.

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.

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

review of basic functions,
overview of new, more advanced tools.

2. Guide to designing and building more advanced applications

working with templates,
creating and managing applications.

3. Detailed discussion of working with forms

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

dynamic setting of properties,
use of functions and formulas in controls.

5. Guidelines for creating aesthetic and readable interfaces

creating custom styles,
using CSS in PowerApps.

6. The process of creating a visually consistent interface through modification of available color themes

creating custom themes,
layout techniques (Grid, Flex).

7. Explanation of how to create applications with interactive navigation

dynamic navigations,
passing data between screens.

8. Instructions for using multimedia in applications

optimization of multimedia,
use of multimedia from external sources.

9. Discussion of methods for integrating PowerApps with various data sources

working with SharePoint, SQL Server, Dynamics 365,
using custom connectors.

10. Introduction to creating complex formulas in PowerApps

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

creating your own keyboard shortcuts,
task automation using shortcuts.

12. Practical tips on increasing application performance

best practices for application management,
performance optimization,
monitoring application operation.

13. Discussion of best practices for securing applications

permission management,
integration with Azure Active Directory,
data security.

14. Methods for detecting and resolving problems in PowerApps applications

application testing tools,
debugging techniques,
automatic application testing.

What are the prerequisites for participating in the training?

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.

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.

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

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