Power Apps Lower, Upper, and Proper Function [With Examples]

Power Apps offers useful tools that allow us to modify the case of a text string. By using Power App’s Upper, Lower, and Proper functions, we can easily standardize the capitalization of your text strings and make them easier to read.

In this Power Apps tutorial, I will explain Power App’s Lower, Upper, and Proper functions with different examples:

  1. Power Apps convert text to lowercase
  2. Power Apps transform form text input to Upper
  3. Power Apps Capitalize the first letter in a string
Message = "Can You Feel Software"

Result= 
Lower Function = "can you feel software"
Upper Function = "CAN YOU FEEL SOFTWARE"
Proper Function = "Can You Feel Software"

Power Apps Lower Function

The Power Apps Lower function converts all letters in a text string to lowercase. Below reprsents the Power Apps Lower() function syntax:

Lower(String)

For example, if you have a text string as “HELLO WORLD,” applying the Lower function will result in “hello world.”

Power Apps Convert text to lowercase

Power Apps convert text to lowercase

Lets check how to convert the Power Apps text to lowercase:

Power Apps Lower Function
  • Insert a Text label control -> Set its Text property to:
Lower(txt_Lower.Text)

Where,

  1. txt_Lower = Text-input control name
Power Apps change text uppercase to lowercase
  • Once your app is ready, SavePublish, and Preview the app. When the user provides the text in the text-input control, the label will convert all the text string to lowercase, as shown below:
Power Apps convert to lowercase

This is about the Lower() function. Now, let’s check about the Power Apps Upper() function.

Power Apps Upper Function

The Power Apps Upper function converts all letters in a text string to uppercase. The Power Apps Upper() function syntax is:

Upper(String)

For example, if you have a text string “hello world”, applying the Upper function to it will result in “HELLO WORLD”.

Power Apps Upper Function

Power Apps transform form texts input to Upper

Let’s see how to transform the Power Apps from user text input to upper.

Example,

I have a SharePoint list [Employee Details], that has various columns like:

Column NameData type
Employee IDTitle
Employee NameSingle line of text
Employee Department[“HR,” “Finance,” “Marketing,” “IT”]
Transform form texts input to Upper in Power Apps

As per my requirement, the Power Apps form is connected to the above SharePoint list, which includes an “Employee Name” field. Suppose a user enters the name in lowercase or proper format and submits the form.

Power-Apps transform form texts-input to the Upper

Follow the below steps to achieve this:

  • On the Power Apps screen, insert an Edit form -> Set its DataSource property to:
'Employee Details'

Where,

  1. Employee Details = SharePoint list name
Power Apps Convert text to Uppercase
  • Select the ‘Employee Name‘ DataCard -> Set its Update property to:
Upper(DataCardValue2.Text)

Where,

  1. DataCardValue2 = Text-input control name
Power Apps change text lowercase to uppercase
  • Insert a Button Control -> Set its OnSelect property to:
SubmitForm(Form1);ResetForm(Form1);

Where,

  1. Form1 = Form control name
How to transform Power Apps form texts input to Upper
  •  SavePublish, and Preview the app. When the user enters the name in lowercase or proper format and submits the form, the employee name field in the SharePoint list will take in uppercase format as shown below:
Transform Power Apps form texts input to Upper

This is how I transformed the Power Apps text input to the upper.

Power Apps Proper Function

Power Apps Proper function is used to capitalize the first letter of each word in a text string. Below is the Power Apps Proper() function syntax:

Proper(String)

For example, if you have a text string “the quick brown fox“, applying the Proper function to it will result in “The Quick Brown Fox“.

Power Apps Proper Function

Power Apps Capitalize the first letter in string

Let’s check how to capitalize the Power App’s first letter in a string.

  • On the Power Apps screen, insert a Text-input control as shown below:
Capitalize the Power Apps first letter in string
  • Insert a Text label control -> Set its Text property to:
Proper(txt_Power.Text)

Where,

  1. txt_Power = Text-input control name
Power Apps Capitalize the first letter in string
  • Once your app is ready, SavePublish, and Preview the app. When the user provides the text in the text-input control, the label will capitalize the first letter in a string, as shown below:
Proper function in Power Apps

This is how i achieved by captilzing the Power Apps first letter in a string.

Conclusion

By following our Power Apps tutorial, I hope you have know about:

  1. Power Apps Lower() function converts the text to lowercase.
  2. Power Apps Upper() function transforms the text value to an uppercase.
  3. Power Apps Proper() function: Users can use this function to capitalize the first letter in the string.

Also, you may like some more Power Apps articles: