Skip to main content

How to Convert Text to Lower Case in Power Apps with Lower

· 5 min read
Jagdish Kumawat
Founder @ Dewiride

The same email address can be written with capitals in one place and without them in another. Lower writes every letter in lower case, so the same address always looks the same before the app counts, groups or compares it.

Syntax​

Syntax
Lower(Text)
PartWhat it is
TextThe text to convert. A table with one column of texts works too.

From Microsoft's Lower, Upper, and Proper reference:

  • Lower converts any capital letters to lower case, and ignores characters that aren't letters. In Microsoft's example, E. E. CummINGS becomes e. e. cummings.
  • Given a one-column table of texts, it returns a one-column table of converted texts.
  • Upper converts to capitals, and Proper gives each word a capital first letter and lower-cases the rest.

The example is the Reports screen of the Overtime Timesheet app. A flow returns a month's approved entries as JSON text, and the app turns them into a table with each person's name, email, department and hours. The screen counts people and groups their hours by email, so each email should be written one way.

Step 1: Convert the Text Where the Table Is Built​

Convert the email once, where each record is made, so every formula that uses the table gets it in lower case:

Part of btnRefreshRS → OnSelect
locRowsRS: ForAll(
ParseJSON(response.entries),
{
Employee: Text(ThisRecord.employee),
Email: Lower(Text(ThisRecord.email)),
Department: Text(ThisRecord.department),
Hours: Value(ThisRecord.hours)
}
)
  • Text(ThisRecord.email) turns the JSON value into text: values from ParseJSON have no type until they're converted.
  • Lower(...) writes that text in lower case.

In Studio, Format text lays the loader out with one argument per line (How to Format a Formula in Power Apps Studio):

The formula bar with the OnSelect property of the Refresh button, showing the loader down to the record of each entry: Employee as Text of ThisRecord.employee, Email as Lower of Text of ThisRecord.email, Department as Text of ThisRecord.department, and Hours as Value of ThisRecord.hours

Step 2: Use the Converted Column​

Every formula on the screen now uses the lower-case Email: the count of people with Distinct (How to Count Unique Values in Power Apps with Distinct), and the list of people, grouped by email (How to Group Records in Power Apps with GroupBy).

The Result​

Six entries from four people, each person counted once:

The lines Approved hours in November 2026: 20.25 and 6 entries from 4 people

Common Mistakes​

MistakeWhat happensDo this instead
Converting one side of a comparison onlyThe two texts can still differ in caseConvert both sides, or convert once where the data comes in
Converting in every formula that uses the columnThe same conversion repeated in many placesConvert once, where the table is built
Lower on a name to showAisha Khan becomes aisha khanKeep names as they are, or use Proper

Troubleshooting​

SymptomLikely causeFix
A value still has capitalsIt was converted in another formula, not where the table is builtConvert once where the table is built, and use that column everywhere
A name shows in lower caseLower was used on a nameKeep names as they are, or use Proper

FAQ​

Lower or Upper?​

Either, as long as every value you compare goes through the same one. Lower is the usual choice for email addresses.

Does Lower change the data source?​

No. It returns new text. To store it, save the result with Patch.

Does Lower change numbers or symbols?​

No. The reference says it ignores characters that aren't letters, so @, dots and digits stay as they are.

Conclusion​

Lower(Text) writes every letter in lower case. Convert values such as email addresses once, where the app builds its table, and every count, group and comparison sees them the same way.

Additional Resources​