Lower, Upper, and Proper functions
Applies to: 
Canvas apps
Dataverse formula columns
Desktop flows
Model-driven apps
Power Pages
Power Platform CLI
Converts letters in a string of text to all lowercase, all uppercase, or proper case.
Description
The Lower, Upper, and Proper functions convert the case of letters in strings.
- Lower converts any uppercase letters to lowercase.
- Upper converts any lowercase letters to uppercase.
- Proper converts the first letter in each word to uppercase if it's lowercase and converts any other uppercase letters to lowercase.
All three functions ignore characters that aren't letters.
If you pass a single string, the return value is the converted version of that string. If you pass a single-column table that contains strings, the return value is a single-column table of converted strings. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.
Syntax
Lower( String )
Upper( String )
Proper( String )
- String - Required. The string to convert.
Lower( SingleColumnTable )
Upper( SingleColumnTable )
Proper( SingleColumnTable )
- SingleColumnTable - Required. A single-column table of strings to convert.
Examples
Single string
The examples in this section use a text-input control, named Author, as their data source. The control contains the string "E. E. CummINGS".
| Formula | Description | Result |
|---|---|---|
| Lower( Author.Text ) | Converts any uppercase letters in the string to lowercase. | "e. e. cummings" |
| Upper( Author.Text ) | Converts any lowercase letters in the string to uppercase. | "E. E. CUMMINGS" |
| Proper( Author.Text ) | Converts the first letter of each word to uppercase if it's lowercase, and converts any other uppercase letters to lowercase. | "E. E. Cummings" |
Single-column table
The examples in this section convert strings from the Address column of the People data source, which contains this data:
| Name | Address |
|---|---|
| "Jean" | "123 Main St NE" |
| "Fred" | "789 SW 39th #3B" |
Each formula returns a single-column table that contains the converted strings.
| Formula | Description | Result |
|---|---|---|
| Lower( ShowColumns( People, "Address" ) ) | Converts any letter that's lowercase to uppercase. | A single-column table with a Value column containing the following values: "123 main st ne", "789 sw 39th #3b" |
| Upper( ShowColumns( People, "Address" ) ) | Converts any letter that's lowercase to uppercase. | A single-column table with a Value column containing the following values: "123 MAIN ST NE", "789 SW 39TH #3B" |
| Proper( ShowColumns( People, "Address" ) ) | Converts any first letter of a word that's lowercase to uppercase, and converts any other letter that's uppercase to lowercase. | A single-column table with a Value column containing the following values: "123 Main St Ne", "789 Sw 39th #3b" |
Step-by-step example
- Add a Text input control, and name it Source.
- Add a label, and set its Text property to this function:
Proper(Source.Text) - Press F5, and then type WE ARE THE BEST! into the Source box.
The label shows We Are The Best!