Power Automate toLower() Function

Have you ever tried using the toLower () function in a Power Automate? In this tutorial, I will explain to you in detail how to use the Power Automate toLower() function.

The Power Automate toLower() function is a transformative tool designed to convert text within your workflows to lowercase. This function is particularly useful for standardizing data inputs and ensuring consistency across your automated processes. By integrating toLower() into your Power Automate routines, you can efficiently handle text variations and maintain a uniform data structure.

Power Automate toLower() Function

The power Automate Lower() function will be mainly useful to convert all the characters in a given string to a lowercase version, which means it sets all the letters of a provided string to the small letters.

If the given string contains lowercase letters, then the characters will remain unchanged and return the same lowercase version without changing them.

The Power Automate Lower() function is a counterpart of the Upper() function, which converts all the characters in a given string to the uppercase characters.

toLower() Function Syntax

The below-provided code will contain the Power Automate lower function syntax used inside a flow.

Syntax: toLower([string])

Example: toLower(‘LIDIA HolloWay’) => Returns the output as ‘lidia holloway’; the string ‘LIDIA HolloWay’ has uppercase characters that will be converted into small letters.

The output data type returned from this function will be in the form of a string.

toLower() Function Examples in Power Automate

Now, I will explain how this function works by implementing it in a Power Automate flow.

So, Let’s create a flow in a step-by-step way:


First, let us begin with a Power Automate “Instant cloud flow” that will be triggered manually.

1. Open the Power Automate home page by make.powerautomate.com -> Select +Create -> Click on “Instant cloud flow”. Set Flow name -> Choose “Manually trigger a flow” and click on Create.

  • Click on +Add an input -> Select Text to add input value in it.
Power Automate toLower() function

2. Next, add an “Initialize variable” flow action to store the value of a string during the flow and set parameters like Name, Type, and Value.

  • Value: Add the value from the dynamic content taken in the text input of a trigger.
power automate tolower

3. Then, add the “Compose” data operation to check the output result returned from the function.

  • Inputs: Add the value as provided in the below code.
power automate tolower dynamic content

4. Now, let’s save and Test the flow. Click on Save. Test it Manually.

power automate lower case function

5. The outputs of the compose flow action will show the results of the Power Automate toLower() function.

  • LIDIA HolloWay -> Converted to lowercase characters ” lidia holloway”.
Power Automate Convert to Lowercase

This is how to work with the Power Automate toLower() function.


Similarly, I will use a SharePoint list to discuss one more example of the Power Automate Lower() function.

While I was working on a SharePoint list, I got a task to convert the text column value to a lowercase version and update those converted values in a SharePoint list by using a Power Automate flow.

I have taken a SharePoint list named “Resume Collection Form” with different columns, as given in the table below.

Column NameDatatype
User Profile NameIt is a single line of text – Title column
Experienced?Yes/No column
Email AddressSingle line of text column
toLower() function in Power Automate

Now, I will take the “Email Address” column as a reference to convert values inserted in the email address column to a lowercase version by using the toLower() function inside a flow.

Follow the steps to see how toLower() works in a Power Automate automated cloud flow.

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. Set details like Site Address and a List Name inside a trigger.

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.

  • Set the parameters of the variable like Name, Type, and Value.
 Power Automate toLower() function

3. Next, add the “Compose” data operation to provide toLower() expression along with the variable inputs, as shown below.

toLower(variables('Email Address'))
power automate tolower

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

5. Once the flow has been created, Save and Test the flow. Click on Save and Test -> Test it Manually.

Power Automate Lower() function

6. Then, the SharePoint list item will get updated with lowercase characters, as represented in the screenshot below.

Power Automate Lower Function example

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


I hope you know now how to use the Power Automate tolower() function. I have explained how to use the tolower() function in Power Automate with two examples. Easily we can convert text to lowercase using the tolower() function in Power Automate.

You may also like: