Power Query
Search…
Logical.FromText

Logical.FromText

Creates a logical value from the text values "true" and "false".
function (optional text as nullable any) as nullable any

Description

Creates a logical value from the text value text, either "true" or "false". If text contains a different string, an exception is thrown. The text value text is case insensitive.

Category

Logical

Examples

Create a logical value from the text string "true".
1
Logical.FromText("true")
Copied!
true
Create a logical value from the text string "a".
1
Logical.FromText("a")
Copied!
[Expression.Error] Could not convert to a logical.