← Back to Logical functions

Logical.FromText

Generates a boolean result based on the input text value, which can only be either "true" or "false". If any other string is detected in the text, an error is triggered. The input text value is not af...

Syntax

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

About

Generates a boolean result based on the input text value, which can only be either "true" or "false". If any other string is detected in the text, an error is triggered. The input text value is not affected by upper or lower case variations.

Explanation

Generate a logical value based on the text string "true". Instructions: Power Query MLogical.FromText("true") Result: true Produce a logical value from the text string "a". Instructions: Power Query MLogical.FromText("a") Result: [Expression.Error] Unable to convert to a logical value.