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

Recently, I got the requirement to work with the Power Apps Lower, Upper, and Proper functions. We can use these functions to manipulate the text strings according to our needs.

Follow this Power Apps tutorial to learn the Power Apps Lower, Upper, and Proper functions. Also, We will see what are the syntaxes of PowerApps Lower, Upper, and Proper functions.

In the last, we will cover how to use all these Power Apps functions using different examples.

Power Apps Lower Function

The Lower function in Power Apps converts all characters in a text string to lowercase. It also helps convert a string of text from uppercase to lowercase.

Power Apps Lower Function Syntax:

Lower(Text)

Where,

• Text = Specify the string that you want to convert to Lower case

Power Apps Lowercase

In Power Apps, there are two text input controls. Whenever the user adds the uppercase text in the first text input [Source Message], the second text input control [Result] displays the text in lowercase.

To achieve it, follow the below code to set the Text input’s Default property:

Default = Lower(txt_Message.Text)

Power Apps Upper Function

The Upper function converts all the characters in a text string to uppercase, and it also helps convert a string of text from lowercase to uppercase.

Power Apps Upper Function Syntax:

Upper(Text)

Where,

• Text = Specify the string that you want to convert in Upper case

Power Apps Text input Uppercase

In Power Apps, there are two text input controls. Whenever the user enters text in lowercase in the first text input control, the second text input displays it in uppercase.

Follow the code below:

Default = Upper(txt_Message.Text)

Power Apps Proper Function

The Proper function capitalizes the first letter of each word in a text string and converts the rest of the letters to lowercase.

Power Apps Proper Function Syntax:

Proper(Text)

Where,

• Text = Specify the string that you want to convert the first letter to Uppercase (If it is in Lowercase) or from Uppercase to Lowercase

Power Apps Capitalize Text input

In Power Apps, there are two text input controls. Whenever the user adds lowercase or uppercase to lowercase text in the first text input, the second text input control displays the text in the first letter in Uppercase.

Follow the code below:

Default = Proper(txt_Message.Text)

PowerApps Lower, Upper, and Proper Function Examples

Now, I will discuss the PowerApps’ Lower, Upper, and Proper function with simple examples.

Example-1:

I have a Data source named Gadget Details. It has two columns: Gadget Name and Gadget Brand. I want to convert the string from the Gadget Brand column of this data source. Below is the Gadget Details table data source.

Gadget Name	Gadget Brand
Mobile	Xiaomi Redmi Note 7 Pro
Laptop	Mi Notebook 14 Silver

Result:

Formula	Description	Result
Lower( ShowColumns( Gadget Details, “Gadget Brand” ) )	It helps to convert any letter that’s uppercase to lowercase.	xiaomi redmi note 7 pro mi notebook 14 silver
Upper( ShowColumns( Gadget Details, “Gadget Brand” ) )	It helps to convert any letter that’s lowercase to uppercase.	XIAOMI REDMI NOTE 7PRO MI NOTEBOOK 14 SILVER
Proper( ShowColumns( Gadget Details, “Gadget Brand” ) )	It helps to convert any first letter of a string (maybe from lowercase to uppercase or Uppercase to lowercase)	Xiaomi Redmi Note 7 Pro Mi Notebook 14 Silver

Example-2:

Suppose you have a Power Apps Edit Form connected to a Data source (Either Excel or SharePoint List data source). This form has some field inputs where the user can enter some inputs and save the form into the SharePoint list.

However, if you want to convert the user input to upper-case or lower-case while saving the form, you can convert that particular input field to upper-case or lower-case. Let us take an example to understand better.

I have a Power Apps Employee Registration Form, and it has some fields, like the screenshot below. Here, I want to make some fields (First Name and Last Name) to the Upper case, So that a user will enter those inputs with the Upper case and submit the Form.

To make those fields (First Name and Last Name) to the Upper case, we need to do the following things. Such as:

• Select the Data card (suppose, First Name) you want to convert to the Upper case.
• Unlock the Data card (Select the Data card -> Go to Advanced tab -> Unlock it).
• Next, go to Update property and set this below formula as:

Update = Upper(DataCardValue8.Text)

Where,

• DataCardValue8 = DataCardValue8 is the “First Name” data card.

In the same way, you will do the above steps for all fields to convert in the Upper, Lower, or Proper case.

Save, Publish, and Preview the app. Enter the field details as I have entered below. Then, click on the Submit button.

Once you submit the form, go to your specific Data source (SharePoint List), and you can see the input fields have been converted into the Upper case, as shown below.

This is how we can use the PowerApps Upper, Lower, and Proper functions.

Also, you may like:

• Power Apps Barcode Scanner
• Power Apps Value Function
• Power Apps Pen input
• Power Apps Employee Directory
• Power Apps Filter Gallery by Dropdown

I trust this Power APps tutorial explained in detail information about how to use the Power Apps Upper, Lower, and Proper functions with simple examples. If you have any requirements related to the Power Apps Upper, Lower, and Proper functions, you can follow the above examples to do it.