Power Automate toLower() Function [With Examples]

Recently, I got a requirement to convert the characters in a string to lowercase equivalent. Power Automate has a string function called the toLower() function to change the characters into lowercase equivalents.

This tutorial will help you learn how to use the Power Automate toLower() function with various examples. Below are the topics that I will cover in this tutorial:

  • Introduction to Power Automate toLower() function
  • Power Automate toLower() function syntax
  • Power Automate toLower() expression in Instant cloud flow
  • Power Automate toLower() function using 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“.

Power Automate toLower() Function

This is the introduction to the Power Automate toLower() function.

Power Automate toLower() Expression 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 as ” South America.” My requirement is to represent text values in lowercase characters.

After applying the Power Automate toLower() function, the return output will be like south america.

How to change text to Lowercase in Power Automate

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].
Power Automate toLower() function syntax

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'))
toLower() function in Power Automate

4.  Now, let’s save and Test the flow. Click on SaveTest 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.
Power Automate toLower() format

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 NameDatatype
User Profile NameIt is a single line of text – Title column
Experienced?Yes/No column
Email AddressSingle line of text column
How to Convert Text to Lowercase in Power Automate

After using the Power Automate toLower() expression, it will return the value like [HENIRETTA@szg52.onmicrosoft.com => heniretta@szg52.onmicrosoft.com].

Converting text to Lowercase in Power Automate

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.
How to use Power Automate toLower() function

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.
Microsoft Power Automate toLower() function

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'))
toLower() function in Microsoft Power Automate

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.
Power Automate toLower() Function Expression using SharePoint list

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:

How to use toLower() expression in Power Automate

7. The SharePoint list item will be updated with lowercase characters, as shown in the screenshot below.

Microsoft Power Automate toLower() Expression

This is how to use the Power Automate toLower() expression using a SharePoint Online list.

Conclusion

Power Automate flows have various case-sensitive scenarios where we only need the lowercase letters. This can be done with the help of the Power Automate toLower() function.

This tutorial will help you convert the text string into lowercase text. Also, I have covered the below topics on Power Automate toLower() Function:

  • Power Automate toLower() function introduction
  • The syntax for the Power Automate toLower() function
  • Example on Power Automate toLower() function using a SharePoint list

Additionally, you may like some more Power Automate tutorials: