How to Use Power Apps Lower, Upper, and Proper Function? [With Examples]

In this Power Apps tutorial, I will explain how to use Power Apps Lower, Upper, and Proper functions with different examples like:

1. How to convert text to lowercase in Power Apps
2. Power Apps transform form text input to Upper
3. Power Apps Capitalize the first letter in a string

Let’s see the example below:

Message = "Power Apps is a Microsoft Tool"

Result= 
Lower Function = "power apps is a microsoft tool"
Upper Function = "POWER APPS IS A MICROSOFT TOOL"
Proper Function = "Power Apps Is A Microsoft Tool"

Let’s see the function details one by one in the section below.

Power Apps Lower() Function

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

Lower(String)

Example: Power Apps convert text to lowercase

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

• On the Power Apps screen, insert a Text-input control as shown below:

• Insert a Text label control -> Set its Text property to:

Lower(txt_Lower.Text)

Where,

1. txt_Lower = Text input control name

• Once your app is ready, save, publish, and preview it. When the user provides the text in the text-input control, the label will convert all the text string to lowercase, as shown below:

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)

Example – Power Apps transform form text input to Upper

Let’s see how to transform the Power Apps from user text input to upper case and save it to a SharePoint list.

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

Per my requirement, the Power Apps form is connected to the above SharePoint list, and the “Employee Name” field has been added. If a user enters the name in lowercase or proper format and submits the form, it converts to uppercase and saves it into the SharePoint list.

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

• Select the ‘Employee Name‘ DataCard -> Set its Update property to:

Upper(DataCardValue2.Text)

Where,

1. DataCardValue2 = Text-input control name

• Insert a Button Control -> Set its OnSelect property to:

SubmitForm(Form1);ResetForm(Form1);

Where,

1. Form1 = Form control name

•  Save, Publish, 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 the uppercase format as shown below:

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)

Example – Power Apps Capitalize the first letter in the 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:

• Insert a Text label control -> Set its Text property to:

Proper(txt_Power.Text)

Where,

1. txt_Power = Text-input control name

• Once your app is ready, save, publish, and preview it. When the user provides the text in the text-input control, the label will capitalize the first letter in a string, as shown below:

This is how I achieved this by capitalizing the Power App’s first letter in a string.

Conclusion

I hope this article helped you to learn how to use the Power Apps Lower() function, Upper() function, and Proper() function with various examples.

Also, you may like some more Power Apps articles:

• Power Apps Month() Function
• Navigate Function in Power Apps
• Power Apps Delegation Warnings
• Remove Last/LastN/First/FirstN Characters From String in Power Apps
• Check if Power Apps Combobox Has a Selected Value

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.