Logical.FromText Function in Power Query

The Logical.FromText function returns a logical value of “true” or “false” from a text value.

Syntax

Logical.FromText(text as nullable text) as nullable logical

This function only accepts "true" or "false" (case insensitive) as valid inputs.

Example: Create a logical value from the text string "true".

Power Query M

let
    Source = Logical.FromText("true")
in
    Source        

The output of the above code is TRUE.

Example:

Power Query M

let
    Source = Value.Type(Logical.FromText("true"))
in
    Source        

The output of the above code is logical.