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

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?

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.

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.

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.

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.

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.

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.

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.

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

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

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

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

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

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

6. Application lifecycle management instruction

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

7. Explanation of administrative functions in PowerApps

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

9. Introduction to the Power Automate 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

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

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

12. Button-triggered flows

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

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

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

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

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

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 app for Teams,
SharePoint Online,
Power Apps + Power Automate integration.

What are the prerequisites for participating in the training?

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.

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.

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.

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.