While working on a Power Automate project, I had to convert a string to upper case. It’s stunning that Microsoft Power Automate has a function named toUpper() that can transform any character to upper case.
This Power Automate article assists you in learning about the Power Automate toUpper() function and Power Automate toLower() function, its syntaxes, and how to use it with various scenarios like:
- How to use the Power Automate toUpper() function manually
- Working with Power Automate toUpper() function using a SharePoint list
Power Automate toUpper() Function
toUpper() function in Power Automate converts all items in a string to uppercase, which means it sets all the characters of a provided string to capital letters.
If the given string contains uppercase letters, the characters will remain unchanged and return the same letters without changing them in Power Automate.
This function is a counterpart of the Power Automate Lower() function, which converts all the characters in a given string to lowercase characters.
Power Automate toUpper() Function Syntax
The syntax of the toUpper() function in Power Automate is as follows:
toUpper([string])Example:
toUpper(‘Lidia Holloway’) // Output – ‘LIDIA HOLLOWAY’
How to Use Power Automate toUpper() Function Manually
Let’s discuss how we can manually work with the toUpper() function in Power Automate. Follow the steps below:
1. Navigate to Power Automate in the browser to open a Power Automate page. Click on +Create -> Select Instant cloud flow. In the next window, Give the flow name, select Manually trigger a flow, and click on Create.
- Add a text box to provide input value to the trigger.
2. In the next step, add an “Initialize variable” flow action to store the text string value. Set the details below:
- Name: Add a name for an initialized variable.
- Type: Select the datatype as ‘String’.
- Value: Take text value from the dynamic content.
3. Then, add the “Compose” data operation to provide a toUpper() expression and see the output of a string.
- Inputs: Add value generated from the initialized variable with toUpper expression.
toUpper(variables('Text'))
4. Now, it’s time to save and test the flow. Click on Save. Test it Manually.
5. Observe the outputs of the compose flow action, which will display the upper case characters of a string as shown below.
This way, we can manually convert a string from lower to upper case using the Power Automate toUpper function.
Power Automate toUpper() Function Using a SharePoint List
Next, we will see how to convert a string to upper case using a SharePoint list in Power Automate.
We have been working on a SharePoint list recently, and my manager gave me a task: when a new item is created in a list, convert text column values to upper-case characters and update those values in a SharePoint list.
In a flow, I will use one of the SharePoint lists, ‘Resume Collection Form,’ to perform the toUpper() function.
Here, I will convert values in the text column “User Profile Name” to an upper case version of characters using a toUpper() function in Power Automate.
Let’s build a Power Automate flow that will trigger automatically when a new item is created in a SharePoint list.
Follow the below steps to implement the Power Automate toUpper() string function inside a flow.
1. Open a Power Automate home page, click on + Create -> Select Automated cloud flow -> Provide flow name, and choose a trigger as When an item is created -> click on Create. Set details below in a trigger.
- Site Address: Select a specific list name from a drop-down.
- List Name: Choose a SharePoint list name from the drop-down.
2. After that, add an Initialize variable to store the values of a text column. Set the details below in the variable.
- Name: Provide the name for a variable.
- Type: Select datatype by clicking on drop-down.
- Value: Take the SharePoint list column from dynamic content.
3. Next, add the ” Compose” data operation to set the toUpper() expression and the variable.
- Inputs: Add the below-given value in the inputs.
toUpper(variables('User Profile'))
4. Finally, add the ‘Update item flow action and select parameters like Site Address, List Name, ID, and Title.
- User Profile Name: Add the value of outputs of the compose flow action.
4. Now, the flow is ready to save and test. So, click on Save and then Test it. Test the flow Manually.
5. Now add an item to the SharePoint list, then the newly created SharePoint list item will get updated with the upper case version of characters as below:
This way, we can use the Power Automate toUpper() function with a SharePoint list.
Power Automate toLower() Function
Microsoft Power Automate toLower() function converts all the characters in a given string to lowercase letters, which means it sets all the letters of a provided string to the small letters.
If the given string contains lowercase letters, the characters will remain unchanged and return the same lowercase version without changing them.
Example:
Just take a string with the name Lidia Holloway. Then, after using the Power Automate toLower() function, the output returned will be “lidia holloway“.
This is the introduction to the Power Automate toLower() function.
Power Automate toLower() Syntax
The code below will indicate the syntax format for the Power Automate toLower() function.
toLower('<text>')Input Parameters:
- text (mandatory): The text input string that needs to be changed to lowercase.
Return value:
- Returns the exact text string in lowercase based on the given text.
This is the syntax of the toLower() function in Power Automate.
How to Convert Text to Lowercase in Power Automate?
By using the toLower() function of Power Automate, we can transform the text string to lowercase text.
Let’s look at the example of the Power Automate toLower() function done in an Instant cloud flow.
Example:
Suppose we take the text input string value ” South America.” My requirement is that text values be represented in lowercase characters.
After applying the Power Automate toLower() function, the return output will be like south america.
To achieve this example, follow the below example:
1. Navigate to the Power Automate Home page -> Select + Create -> Select Automated cloud flow -> Provide a name for the flow and choose a trigger -> Click Create button.
2. Select an Initialize variable flow action under the trigger to initialize the string variable. Set the details like:
- Name: Give a name for the string variable manually.
- Type: Select String datatype for the variable.
- Value: Take the value as you wish, like [South America].
3. Then, add a Compose flow action, and, in the Inputs property, provide the expression for the tower () function of Power Automate, which will convert the text string to lowercase.
toLower(variables('Name'))
4. Now, let’s save and Test the flow. Click on Save. Test it Manually.
5. The result will be displayed in the compose flow action. Just open it to check the output received.
- The returned output will be like south america.
This is how we can convert the text into lowercase using the Power Automate toLower() function.
How to use Power Automate toLower() Function Expression
I will show you how to transform text string to lowercase text in a SharePoint list column using the Power Automate toLower() function.
Example:
While working on a SharePoint list, I got a requirement to convert the SharePoint list column value [Email Address ] to a lowercase version and update those converted values in a SharePoint list.
I have taken a SharePoint list named “Resume Collection Form” with an Email Address as a text column.
| Column Name | Datatype |
| User Profile Name | It is a single line of text – Title column |
| Experienced? | Yes/No column |
| Email Address | Single line of text column |
After using the Power Automate toLower() expression, it will return the value like [[email protected] => [email protected]].
To work with this, follow the given steps:
1. Click on the App Launcher -> Select Power Automate -> Click on + Create -> Select “Automated cloud flow” -> Provide flow name, choose a trigger ” When an item is created” -> Click on Create button.
Set details inside a trigger.
- Site Address: Select a specific SharePoint site.
- List Name: Choose a SharePoint list from the drop-down.
2. In the second step, initialize a variable by adding an Initialize variable flow action to store the information of that text column.
- Name: Take the name for the variable as Email Address.
- Type: Select the data type as a String from the drop-down.
- Value: Take the SharePoint list column Email Address from the dynamic content.
3. Next, add the Compose flow action to provide the toLower() expression in the Inputs section, as shown below:
- Inputs: Select field -> Click Expression -> Insert the below code.
toLower(variables('Email Address'))
4. Finally, add the Update item flow action and provide properties like Site Address, List Name, ID, and Email Address.
- Email Address: Take the outputs of compose flow action here from dynamic content.
5. Once the flow has been created, save and run the flow. Click on Save and Test -> Test it Manually.
6. When the flow is running, create a new item in the SharePoint list as shown below:
7. The SharePoint list item will be updated with lowercase characters, as shown in the screenshot below.
This is how to use the Power Automate toLower() expression using a SharePoint Online list.
Conclusion
With the above examples, I hope you can easily understand the Power Automate toUpper() function and Power Automate toLower() function with examples.
Also, we saw how to convert a string from lower case to upper case manually in Power Automate. Furthermore, we discussed using the Power Automate toUpper() function with a SharePoint list.
You may like the following tutorials:
- Power Automate Contains() Function
- Power Automate IndexOf() Function
- Power Automate LastindexOf() Function
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.
