Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Logical.From
Logical.FromText
Logical.ToText
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
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.
Previous
Logical.From
Next
Logical.ToText
Last modified 3yr ago
Copy link
Contents
Logical.FromText
Description
Category
Examples