Text.Lower
Converts all letters in a text value to lower case.
Text.Lower(text as nullable text, optional culture as nullable text) as nullable textReturns: The text in lower case, or null when the input is null.
What it does
Text.Lower puts every letter in lower case. It is most useful for values that people type by hand, such as email addresses and web domains, where "Billing@Acme.com" and "billing@acme.com" are the same address but compare as different text. Lowering both sides before a comparison removes that noise.
Syntax and arguments
- text: the value to convert.
- culture (optional): a culture name, used for languages with special casing rules. Leave it out for English data.
Example
An accounts receivable team has two lists of customer emails, one from the CRM and one from the billing system. The emails are lowered on both sides before the merge, so a customer typed twice with different capitals is found once.
let
Crm = #table(type table [Email = text], {{"Billing@Acme.com"}, {"ap@Blue-Harbor.com"}}),
Billing = #table(type table [BillingEmail = text], {{"billing@acme.com"}}),
CrmKey = Table.TransformColumns(Crm, {{"Email", Text.Lower, type text}}),
BillingKey = Table.TransformColumns(Billing, {{"BillingEmail", Text.Lower, type text}}),
Matched = Table.Join(CrmKey, "Email", BillingKey, "BillingEmail", JoinKind.Inner)
in
Matched
The Acme address matches after both sides are lowered, so the result has one row. The Blue Harbor address has no match and drops out of an inner join.
Example: a second, different use
Lower the case of a file name before checking it against an expected name such as "bank_statement_2026_09.csv".
Things to watch
- Lowering the case of both sides is how you get a case-insensitive match. Lowering one side only will still fail.
- Text.Contains and the comparison operator "=" are case sensitive by default, so the lowered copy is what you compare.
- Keep the original column if the report needs the original capitals. Add the lowered version as a new column for the key.
- Null in gives null out.
In business terms
Email addresses, vendor domains and file names arrive with mixed capitals from many sources. A lower case key column is the usual way to merge them without losing records to capitalization.