Power FX - Categories of Functions in Power FX Tutorial

Curious about Power FX? This video dives into the various categories of functions within Power FX, perfect for those familiar with Excel! From basic operations like SUM to advanced string manipulations and user actions, learn how to easily enhance your low-code applications. Join us to unlock the power of intuitive function usage!

01:51
435 views

Available in Microsoft365

00:00:01

we will explore the categories of functions available in Power FX.

00:00:06

If you know Excel,

00:00:07

you will find Power FXs easy to understand and use.

00:00:11

Let's start with the basic functions,

00:00:13

essential for performing common operations.

00:00:16

For example,

00:00:17

you can use the sum function to add numbers.

00:00:21

Text functions allow you to easily manipulate text strings.

00:00:25

For example,

00:00:25

with Concat,

00:00:26

you can combine two text strings,

00:00:28

and with upper,

00:00:30

you can convert text to uppercase.

00:00:33

Logical functions are used to handle conditions and boolean operations.

00:00:37

With if,

00:00:38

for example,

00:00:39

you can check if a field is empty and display a message accordingly.

00:00:44

Date and time functions simplify the management of dates and times,

00:00:48

now allows you to get the current date and time,

00:00:50

and date a can add days to a specific date.

00:00:55

Lookup functions help you find and filter data in tables.

00:00:59

Use lookup to find a specific record

00:01:02

or filter

00:01:03

to filter data based on certain criteria.

00:01:07

Calculation functions are perfect for

00:01:09

performing basic mathematical operations.

00:01:12

For example,

00:01:13

average allows you to calculate the average of

00:01:15

several values and round rounds a number.

00:01:19

String management functions offer advanced text manipulations.

00:01:23

Left can extract the first characters of a string,

00:01:26

and mid can extract a specific part of the text.

00:01:30

Action functions relate to user interactions and actions.

00:01:34

For example,

00:01:35

Navigate allows you to navigate to another screen

00:01:37

and reset resets of control.

00:01:41

As mentioned above,

00:01:42

you can see that Power FX is like to Excel functions.

00:01:45

In the following videos,

00:01:46

we will explore together the use of these functions through examples.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

455 Views

Video Training Microsoft Power FX : Master Power FX to optimize your applications in a low-code environment

Master Power FX to optimize your applications with powerful and flexible functions in a low-code environment.

ALL COURSES