Power FX - Logical Function Tutorial

Unlock the power of interactive applications with the "Logical Function" video! Dive into essential Power FX functions like if, and, or, not, and switch to learn how to create dynamic responses in your apps. Perfect for anyone interested in advanced, low-code solutions. Discover practical examples that bring your projects to life!

03:14
578 views

Available in Microsoft365

00:00:04

which enable you to create interactive and dynamic applications.

00:00:08

In this guide,

00:00:09

we'll explore five essential logical functions

00:00:12

if

00:00:13

and

00:00:13

or

00:00:14

not and switch.

00:00:16

First,

00:00:17

the if function is similar to the if

00:00:19

statement in Excel and other programming languages.

00:00:23

It allows you to test a condition

00:00:25

and execute different actions based on the result of that condition.

00:00:29

For example,

00:00:30

if you want to display a personalized welcome message based on the user's role,

00:00:35

you can use the if function as follows.

00:00:38

Here,

00:00:38

if the user types manager in the text box,

00:00:41

the message displayed will be

00:00:43

welcome

00:00:44

project manager.

00:00:45

Otherwise,

00:00:46

the message displayed will be welcome collaborator.

00:00:50

Next,

00:00:50

the and function is used to check if multiple conditions are all true.

00:00:55

This is particularly useful

00:00:56

when you want to ensure that several criteria are met before proceeding.

00:01:01

For example,

00:01:01

in a customer feedback form,

00:01:03

you want to ensure that the name and

00:01:05

email fields are filled before submitting the form.

00:01:09

Here's how to do it.

00:01:11

If both fields are completed,

00:01:13

meaning neither text input is left empty,

00:01:15

the message displayed will read,

00:01:17

thank you for your feedback.

00:01:19

Conversely,

00:01:20

if any field is incomplete,

00:01:21

the message displayed will be,

00:01:23

please fill in all fields.

00:01:26

The or function allows you to check if at least one of the conditions is true.

00:01:31

It is handy for scenarios where a single

00:01:33

true condition is sufficient to trigger an action.

00:01:36

For example,

00:01:37

if you want to check if an employee is either on leave or working remotely,

00:01:40

you can use the your function as follows.

00:01:43

If the employee's status is leave or remote work,

00:01:47

the message displayed will be the employee is not in the office.

00:01:51

Otherwise,

00:01:52

the message displayed will be

00:01:54

the employee is in the office.

00:01:57

The knot function inverts the result of a condition.

00:02:00

It is useful when you want to check that something is not true.

00:02:04

For example,

00:02:05

in a security application,

00:02:06

you want to ensure that the password field is not left empty.

00:02:10

Here's how to do it.

00:02:12

If the password field is not empty,

00:02:14

the message displayed will be password validated.

00:02:17

Otherwise,

00:02:18

the message displayed will be please enter a password.

00:02:22

Finally,

00:02:23

the switch function is used to compare an expression to multiple

00:02:26

values and execute the code corresponding to the first match found.

00:02:29

For example,

00:02:30

in a customer service application,

00:02:32

you can display a specific message based on the nature of the user's request.

00:02:37

If the user types technical support,

00:02:40

the message displayed will be,

00:02:42

we will connect you with technical support.

00:02:45

If the user types inquiries,

00:02:47

the message displayed will be,

00:02:49

our inquiry team will contact you shortly.

00:02:52

For any other input,

00:02:53

the message displayed will be,

00:02:55

please specify your request.

00:02:58

In summary,

00:02:58

logical functions and power effects make

00:03:00

Power App's applications more dynamic and interactive

00:03:04

by intelligently responding to user actions.

00:03:06

We've seen how to use the if,

00:03:08

and,

00:03:09

or not and switch functions through practical examples.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

449 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