icon icon

Microsoft PowerApps and Power Automate – automation and integration of business applications

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

Build apps on your own - You will learn how to create business apps in PowerApps from the ground up, so you can build practical tools for entering, browsing, and updating data without outside help.

icon

Design forms efficiently - You will master creating and modifying forms, which will help you prepare screens for adding, deleting, and reviewing records faster and align them with real business tasks.

icon

Create a better interface - You will learn how to adjust control properties, format text, and choose colors and layouts, so the apps you create are clearer, easier to use, and more effective for end users.

icon

Use formulas in practice - You will learn to apply PowerApps formulas to display values dynamically, respond to user input, and automatically control the appearance and behavior of app elements.

icon

Make apps more accessible - You will understand how to design accessible apps, allowing you to build solutions that work better with keyboards, screen readers, and thoughtfully planned layouts and colors.

icon

Connect data and services - You will understand how to connect PowerApps and Power Automate with different data sources, cloud services, SharePoint, Teams, and on-premises resources using connectors and gateways.

icon

Automate work processes - You will learn to build flows in Power Automate with triggers, conditions, loops, and approvals, so you can automate repetitive tasks and bring more structure to business processes.

icon

Publish and manage solutions - You will master saving, sharing, monitoring, and maintaining apps and flows, including mobile use, which will make it easier for you to deploy solutions across your organization.

Training programme

1. Comprehensive overview of the PowerApps platform

At the platform level, Power Apps is introduced through the basics of application creation and everyday navigation. Participants learn the core concepts used to build apps and use keyboard shortcuts that speed up movement across the environment and common tasks.

  • learning the basics of creating applications in PowerApps,
  • using keyboard shortcuts for faster navigation.

2. Discussion of the functions and capabilities of forms in PowerApps

Forms organize how records are displayed and edited in a Power Apps application. This section covers available form types, their modification, viewing existing records, and performing basic data operations such as creating and deleting entries within the app.

  • different types of forms available in PowerApps,
  • modification of forms,
  • viewing records,
  • creating and deleting records.

3. Explanation of how to perform various operations in PowerApps applications

Working with a Power Apps screen involves both interface design and functional configuration. Participants modify control properties, format text, choose themes and layouts, navigate between screens, add multimedia, and use additional data sources inside the application.

  • editing control properties,
  • text formatting,
  • selecting a color theme and interface layout,
  • switching between screens,
  • adding multimedia,
  • using additional data sources.

4. Detailed guide to writing and using formulas in PowerApps

Formulas in Power Apps drive how values are shown and how the interface reacts to input. Participants write expressions for displaying data, changing output dynamically based on entered values, and controlling visual elements such as colors through formula logic.

  • displaying values,
  • dynamic change of the output value based on input data,
  • modification of colors.

5. Introduction to PowerApps features that ensure application accessibility for all users

Accessibility in Power Apps affects how different users interact with the same application. The section addresses interface layout and color adjustments, keyboard operation, and screen reader support so apps remain usable for people with varying access needs.

  • adjustment of interface layout and colors,
  • keyboard support,
  • support for screen readers.

6. Application lifecycle management instruction

Once an app is ready, it must be saved, distributed and controlled throughout its use. This section explains how to store the created application, share it with other users, and manage permissions for individual units responsible for access and ongoing use.

  • saving the created application,
  • sharing the application with other users,
  • managing permissions for individual units.

7. Explanation of administrative functions in PowerApps

Administrative work in Power Apps includes maintaining existing applications and adjusting key presentation settings. Participants edit or delete apps, change the name and icon, and configure screen size and orientation so the application fits its intended usage context.

  • editing existing applications,
  • deleting applications,
  • modifying the application icon and name,
  • adjusting the screen size and orientation.

8. Practical tips on connecting PowerApps with various services

Practical integration work in Power Apps depends on choosing services that match the app’s purpose and data model. The section focuses on how such connections are approached in real use, so external services can support app behavior without unnecessary complexity.

9. Introduction to the Power Automate tool

Power Automate is presented as a service for building automated workflows between applications and services. Participants review its core functions, the operational benefits of using flows, and the structure of the interface needed to navigate and start working with the tool.

  • description of the Power Automate service and its functions,
  • benefits resulting from the use of flows,
  • Power Automate program interface.

10. A guide to the process of creating workflows in Power Automate

From template selection to publication, the workflow creation process is presented as a sequence of practical design decisions. The section includes choosing and adapting ready-made templates, defining triggers and actions, specifying the starting event, and managing the finished flow.

  • using ready-made flow templates,
  • selecting the appropriate template,
  • customizing the flow,
  • defining triggers and actions,
  • specifying the event that starts the flow,
  • defining actions in the flow,
  • publishing the flow,
  • managing the flow.

11. Automation logic – building flows

Building flow logic starts with defining the intended outcome and structuring decision paths. Participants work with conditions, switches, variables, expressions and loops, then learn how flow control and proper termination affect the behavior of automated processes.

  • defining the purpose of the flow,
  • flow conditions,
  • switches,
  • variables,
  • expressions,
  • loops,
  • flow control,
  • ending the flow.

12. Button-triggered flows

A single tap can trigger a process directly from a mobile context. This section focuses on installing and managing the app, creating button-triggered flows, using trigger tokens and user inputs, and sharing these flows with others who need the same manual action.

  • downloading and managing the application,
  • creating a button-triggered flow,
  • button flows with trigger tokens,
  • button flows with user inputs,
  • sharing button-triggered flows.

13. Scheduled flows

Running automation on a timetable is useful when tasks must happen without a direct user action. Participants define the data and actions used in scheduled flows, set execution times, and review the available flow elements needed to build recurring jobs correctly.

  • data used in flows,
  • defining actions in a flow,
  • running a flow based on a schedule,
  • list of available flow elements.

14. Other types of flows

Beyond basic automation, Power Automate supports several flow patterns matched to different process needs. The section covers business process flows with branching, roles and approvals, as well as recurring flows for data collection and validation, plus team-oriented flow scenarios.

  • business process flows:
  • process standardization,
  • branching in flows,
  • assigning roles to users,
  • building flows with decision approval,
  • cyclical flows:
    • data collection,
    • checking data correctness,
    • cyclical execution of flows,
  • team flows.

15. Detailed discussion of methods for connecting applications with various data sources

Connectors determine how applications reach cloud and on-premises data. This part explains standard and premium connectors, connection management, and data gateways, then shows how web-based sources and local resources can be used within the same integration approach.

  • available connectors,
  • premium connectors,
  • connection management,
  • data gateways,
  • use of data from the web,
  • use of local data.

16. Explanation of how to monitor, manage and optimize workflows in Power Automate

Keeping flows reliable requires visibility into their execution and clear ownership. Participants learn to review flow history, share solutions in a local network context, handle import and export, and carry out maintenance tasks that support ongoing operation and optimization.

  • overview of flow history,
  • sharing the flow on the local network,
  • import and export of the flow,
  • maintenance of the flow.

17. Discussion of the functions of the mobile version of Power Automate

Using the mobile app, participants work with Power Automate away from the desktop. The section covers installation and sign-in, then moves to creating flows on a phone and using available communication channels to start or manage automation in everyday work.

  • downloading the mobile application,
  • logging in to the mobile application,
  • creating flows using the mobile application,
  • use of various communication channels.

18. Description of the possibilities of integrating Power Automate with other applications and services

Power Automate can be connected with collaboration and app-building services used across Microsoft 365. The section shows how flows work with Teams and SharePoint Online, and how Power Apps can trigger or extend automation scenarios built in Power Automate.

  • Power Automate app for Teams,
  • SharePoint Online,
  • Power Apps + Power Automate integration.

What are the prerequisites for participating in the training?

icon

Basic computer skills - You should be comfortable using Windows, working in a web browser, managing files, and switching between multiple windows so you can complete the hands-on exercises smoothly.

icon

Familiarity with Microsoft 365 - You should know the basics of working with Microsoft 365, especially signing in, using Teams or SharePoint, and navigating Microsoft web interfaces during the training.

icon

Understanding tabular data - You should understand what records, columns, forms, and data lists are, so you can build apps more easily, connect data sources, and design workflows correctly.

icon

Process-oriented thinking - You should be able to describe a simple business process step by step, identify the starting event and expected result, so you can design automation logic more effectively.