In this post, I will discuss all the Logical functions that can be used in Microsoft Flow.

Function

Description

if

This function returns a specified value based on whether the expression resulted in true or false. This function requires three parameters: the expression to check; the value to return if the expression is true; and the value to return if the expression is false.

**Function**: if(expression, valueIfTrue, valueIfFalse)

**Example**: if(equals(10, 10), ‘Yes’, ‘No’)

**Output**: Yes

**Additional Examples**: Coming soon

equals

This function checks if two values, expressions, or objects are equal. If they are, the function returns true, and if they are not, it returns false. This function requires two parameters: the values, expressions, or objects to compare. The output is Boolean (true or false).

**Function:**equals(object1, object2)

**Example:**equals(10, 10)

**Output:**true

**Additional Examples:**Coming soon

and

This function checks if all the expressions are true. If they are, the function returns true, and if they are not, it returns false. This function requires two parameters: the expressions to check. The output is Boolean (true or false).

**Function**: and(expression1, expression2)

**Function**: and(equals(10, 10), equals(20, 20))

**Output**: true

**Additional Examples**: Coming soon

or

This function checks if at least one expression is true. It returns true if one expression is true, and false if all the expressions are false. This function requires two parameters: the expressions to check. The output is Boolean (true or false).

**Function**: or(expression1, expression2)

**Function**: or(equals(10, 10), equals(20, 30))

**Output**: true

**Additional Examples**: Coming soon

not

This function checks if an expression is false. It returns true if the expression is false, and false if the expression is true. This function requires one parameter: the expression to check. The output is Boolean (true or false).

**Function:**not(expression)

**Example:**not(equals(10, 20))

**Output:**true

**Additional Examples:**Coming soon

less

This function checks if the first value is less than the second value. It returns true if the first value is less, and false if the first value is more. This function requires two parameters: the first value to check if less than the second value, and the item to compare. Both parameters can be the following types: Integer, Float, or String. The output is Boolean (true or false).

**Function:**less(value, compareTo)

**Example:**less(10, 20)

**Output:**true

**Additional Examples**: Coming soon

lessOrEquals

This function checks if the first value is less than or equal to the second value. It returns true if the first value is less than or equal, and false if the first value is more. This function requires two parameters: the first value to check if less than or equal to the second value, and the item to compare. Both parameters can be the following types: Integer, Float, or String. The output is Boolean (true or false).

**Function:**lessOrEquals(value, compareTo)

**Example:**lessOrEquals(10, 10)

**Output:**true

**Additional Examples**: Coming soon

greater

This function checks if the first value is greater than the second value. It returns true if the first value is more, and false if the first value is less. This function requires two parameters: the first value to check if more than the second value, and the item to compare. Both parameters can be the following types: Integer, Float, or String. The output is Boolean (true or false).

**Function:**greater(value, compareTo)

**Example:**greater(20, 10)

**Output:**true

**Additional Examples**: Coming soon

greaterOrEquals

This function checks if the first value is greater than or equal to the second value. It returns true if the first value is greater than or equal, and false if the first value is less. This function requires two parameters: the first value to check if greater than or equal to the second value, and the item to compare. Both parameters can be the following types: Integer, Float, or String. The output is Boolean (true or false).

**Function:**greaterOrEquals(value, compareTo)

**Example:**greaterOrEquals(20, 20)

**Output:**true

**Additional Examples**: Coming soon

Hi Fausto,

I attended the recent MVP webinar held on 12/12/2018.

I am a user of MS flow and SharePoint.

I have one question regarding the concerning material topic that you discussed in the webinar.

How can we export version history of SharePoint list item to excel sheet? I know how to export the SharePoint list to excel sheet but version history doesn’t come along with the items.

I want to export the SharePoint list item with the version history.

or

One other way if we copy the original SharePoint list item to a new list on SharePoint, version history doesn’t come as well. We want the version history for audit tracking and want to track the changes done the particular item.

Can you suggest, please?

You can reach out to me at amanpreetwahla@outlook.com

LikeLike