LOWER

Use the LOWER function to convert all uppercase letters in a Text value to lowercase letters.

Use

LOWER( text )
Converts text to lowercase.

Parameter	Required	Description
text	Yes	the text to convert

Returns

Text

Examples

Normalizing Email Addresses for Consistency

When capturing user information in a Teams Trigger, people often enter email addresses with inconsistent capitalization (e.g., "John.Doe@Acme.com"). You can use the LOWER function in a Variable Update formula to standardize this data for easier searching and reporting later in the process.

• Scenario: You want to update a variable called $SubmitterEmail with a standardized version of the email address provided in the trigger.
• Formula: LOWER(@Trigger.out.EmailAddress)
• Logic: This formula takes the "EmailAddress" output from the trigger and converts it entirely to lowercase.
• Result: An input of "User.Name@COMPANY.com" is transformed and stored as "user.name@company.com".

Facilitating Case-Insensitive Comparisons

While some functions in GoApprove, like SEARCH, are naturally case-insensitive, others, such as EXACT, are case-sensitive. If you need to verify that a specific word was entered regardless of how it was capitalized, you can use LOWER to "level the playing field" before the comparison.

• Scenario: In an Output Validation Formula, you want to ensure a user has typed the word "Confirmed" in a text box, but you want to accept "CONFIRMED," "confirmed," or "Confirmed".
• Formula: EXACT(LOWER(this), "confirmed")
• Logic:
  • this: Refers to the text the user is currently typing in the field.
  • LOWER(this): Converts the user's input to lowercase.
  • EXACT(..., "confirmed"): Compares the now-lowercase input against the lowercase literal "confirmed".
• Result: If the user enters "CONFIRMED," the function converts it to "confirmed," matches it exactly, and returns TRUE.

---

Pro Tip: Using LOWER is a best practice for data "robustness and reliability". By normalizing text to a single case, you prevent logic errors that occur when a workflow fails to recognize a value simply because of a capital letter.