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
  • 17 views
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.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

Reminder

Show