PowerApps Lower, Upper, and Proper function

In this Powerapps tutorial, We will discuss the PowerApps Lower function, PowerApps upper function, and what is Proper function in Powerapps.

Also, We will see what are the syntaxes of Powerapps Lower, Upper, and Proper function. By taking a simple scenario, We will discuss how and where we can use all these functions in a Powerapps screen and as well as in a Powerapps Form.

You can also check out PowerApps functions and PowerApps AddColumns Function with Examples.

Powerapps Lower Function

Powerapps Lower function helps to convert a string of text from uppercase to lowercase.

Powerapps Lower Function Syntax

Lower(Text)

Where, Text = Specify the string that you wants to convert it Lower case.

Powerapps Upper Function

Powerapps Upper function helps to convert a string of text from lowercase to uppercase.

Powerapps Upper Function Syntax

Upper(Text)

Where, Text = Specify the string that you wants to convert it Upper case.

Powerapps Proper Function

Powerapps Proper function helps to convert the first letter in each word of a string to uppercase (if it is in lowercase) and coverts from uppercase to lowercase.

Powerapps 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.

Example:

Here let’s take a simple example of how you can use this Powerapps Lower, Upper, and Proper function.

In this example, there is a Data source named Gadget Details. It has two columns as Gadget Name and Gadget Brand. I want to convert the string from the Gadget Brand column of this data source. Below represents the Gadget details table data source.

Gadget NameGadget Brand
MobileXiaomi Redmi Note 7 Pro
LaptopMi Notebook 14 Silver

Result:

FormulaDescriptionResult
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

Upper Lower and Proper functions in Powerapps

  • Sign in the PowerApps app with your credentials.
  • Create a blank new Canvas app and choose any one Layout either Tablet or Phone.
  • On the Powerapps Blank screen, Add these below Powerapps input controls as:
  1. Insert one Text input control (Insert -> Input -> Text input) and rename it to Message. Then, set its Default property to blank.
  2. Add one Label control (Insert -> Label) and set its Text property to “Source Message”.
  3. Add another Label control and set its Text property to “Result”.
  4. To display the result, Insert one Label control and apply this below formula on its Text property as:
Text = Proper(Message.Text)

Where,

  • Proper = It is the Powerapps function that helps to convert any first letter of a string as Uppercase or Lowercase.
  • Message = Text input control name

NOTE:

Not only you can use the Powerapps Proper function, but also, you can use the Upper and Lower function that you want to convert.

Refer the below screenshot.

Powerapps proper function
Powerapps proper function

Now, Save and Preview (F5) the app. Enter some text into the Source Message field like “WELCOME TO POWERAPPS !!!“. Then at the same time, in the Result field, the text will convert by using the Proper function and the result will appear as: “Welcome To Powerapps !!!

Powerapps Lower Upper and Proper function
Powerapps proper function example

Upper, Lower and Proper functions in Powerapps Form

Suppose, you have a Powerapps Edit Form and that has connected with a Data source (Either Excel or SharePoint List data source). This form has some field inputs where the user can enter some inputs over there and save the form.

But, you want to convert the user input to be Upper case or lower case while saving the form. Then, in that case, you can convert that particular input field to the Upper case or Lower case. Let us take an example for better understanding.

I have a Powerapps Registration form and it has some fields like the below screenshot. 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.

powerapps upper function
powerapps upper function

To make those fields (First Name and Last Name) to Upper case, we need to do these below things as:

  • Select the Data card (suppose, First Name) that you want to convert 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(DataCardValue1.Text)

Where,

DataCardValue1 = First Name field control name that you want to convert it in the Upper case.

powerapps lower function
powerapps lower function

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

  • Now, Save and Preview (F5) the app. Enter the field details as I have entered below. Then, click on the Submit button.
Powerapps Upper Lower and Proper functions
powerapps lower upper and proper function

Once you will 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.

Lower, Upper, and Proper functions in PowerApps
Lower, Upper, and Proper functions in PowerApps

Also, you may like these below Powerapps Tutorials:

In this Powerapps Tutorial, we discussed what is Powerapps Lower, Upper, and Proper functions. Also, We saw these things as:

  • Powerapps lower function
  • Powerapps upper function
  • Powerapps proper function
  • How to use the Lower, Upper, and Proper function in Powerapps screen
  • Upper, Lower and Proper functions in Powerapps Form
>