Edit

Lower, Upper, and Proper functions

  • Article

Applies to: Canvas apps Dataverse formula columns Desktop flows Model-driven apps 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

  1. Add a Text input control, and name it Source.
  2. Add a label, and set its Text property to this function:
    Proper(Source.Text)
  3. Press F5, and then type WE ARE THE BEST! into the Source box.
    The label shows We Are The Best!