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.
Powerapps Lower Function
Powerapps Lower function helps to convert a string of text from uppercase to lowercase.
Powerapps Lower Function Syntax
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
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
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.
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 Name||Gadget Brand|
|Mobile||Xiaomi Redmi Note 7 Pro|
|Laptop||Mi Notebook 14 Silver|
|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:
- Insert one Text input control (Insert -> Input -> Text input) and rename it to Message. Then, set its Default property to blank.
- Add one Label control (Insert -> Label) and set its Text property to “Source Message”.
- Add another Label control and set its Text property to “Result”.
- To display the result, Insert one Label control and apply this below formula on its Text property as:
Text = Proper(Message.Text)
- 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.
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 !!!“
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.
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)
DataCardValue1 = First Name field control name that you want to convert it in the Upper case.
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.
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.
Also, you may like these below Powerapps Tutorials:
- PowerApps Popup message Box with Examples
- Get users from SharePoint Group in PowerApps
- PowerApps camera control + Save captured image in SharePoint
- PowerApps role based security SharePoint example (SharePoint Groups)
- PowerApps: Submit data to two SharePoint Lists
- PowerApps Patch Function with examples
- Show hide fields based on dropdown selection PowerApps
- Embed PowerApps in SharePoint modern page
- PowerApps toggle control + How to use with example
- PowerApps Search Function + How to use with example
- PowerApps Sum function (Get sum of a column PowerApps)
- PowerApps Cascading Dropdown
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
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com