Logical Functions(Power Automate Cloud flows)

02/22/2024

Japanese version.

The two main types of functions are as follows

  • Functions that determine whether a value is True or False based on its numeric or textual status.
  • Functions that create logical expressions from the judgment results.

Basically, the function that makes the judgment first is used to produce True or False, and then additional logical expressions are created as needed.

Logical Functions

Determination functions

FunctionOverview
equalsIt compares the two values of the argument and determines True if they are the same and False if they are different.
greaterCompares the two values of the argument; True if the first is greater than the second, False otherwise.
greaterOrEqualsCompares two values of the argument, True if the first value is greater than or equal to the second value, False otherwise.
lessCompares the two values of the argument; True if the first is less than the second, False otherwise.
lessOrEqualsCompares two values of the argument, True if the first value is less than or equal to the second value, False otherwise.

Functions to create logical expressions.

FunctionOverview
andA function whose result is True only if all the logical functions or Boolean values specified in the argument are True.
If any of the arguments is False, the result is False.
orSpecify multiple logical functions, boolean variables, or boolean values as arguments.
If any one of them is True, the result of the function is True.
Only if all of them are False, the result of the function will be False.
notThis function inverts a boolean value.
Because negation often makes expressions difficult to read, It is a function that should be avoided whenever possible.

Other functions

FunctionOverview
ifThis function changes the value returned depending on whether the result of the expression is True or False.

It works similar to the IF function in Excel.

When multiple actions are to be executed depending on the result of the judgment, or when the actions to be executed are different, "Condition" is used, but if the actions are only different numbers or text, the if function is more appropriate in many cases because it is more concise.

For those who want to learn Power Automate Cloud flow effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Cloud flow to streamline your workflow.

Links

Functions