Power Automate toLower() Function [How to Use]

In Power Automate, many string() functions which are used to manipulate the text during the flows. In that, toLower() function allows you to change the text to lowercase.

In this tutorial, I will explain an overview of the Power Automate toLower() function, its syntax, and a few examples of the toLower() function.

The toLower() function in Power Automate converts a string into lowercase. This function is part of the expression language used within Power Automate to convert and transform data.

Power Automate toLower() Function

The power Automate toLower() function will be mainly helpful 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, the characters will remain unchanged and return the same lowercase version without changing them.

Example:

After using Power Automate toLower() function,

Text InputOutput
[email protected][email protected]

Please refer to the below image.

Power Automate toLower() function expression

This is a brief description of a Power Automate toLower() function.

Power Automate toLower() Function Syntax

Let’s see the syntax of the toLower() function in Power Automate.

toLower('<text>')

Input parameter:

  • text (mandatory): The string in lowercase format to be returned.

Return value:

  • Returns a string in lowercase based on the given text.

Here is the syntax of the toLower() function in Power Automate.

How to use toLower() function in Power Automate

In this section, I will give you the different scenarios on how to use the Power Automate toLower() function.

Dive into the examples below!

Example 1:Power Automate toLower() function using SharePoint list

For this, I have taken a SharePoint list named “Employee Data,” with an Employee Email ID column and a few more columns.

In this scenario, I want to get the SharePoint list column values [Employee Email ID] into lowercase versions.

Power Automate toLower() function using SharePoint List

To work around this, follow the steps below.

1. Open the Power Automate home page in your browser, click + Create -> Select the Automated cloud flow -> Provide the flow name, and choose the trigger’s flow (When an item is created or modified) -> Click Create button.

In this trigger, set all the required details as shown below.

  • Site Address: Provide the specific SharePoint site address.
  • List Name: Select the name of the SharePoint List.
Power Automate toLower() function expression

2. To create and set the initial value of a variable, add the ‘Initialize variable’ flow action and set all the required fields.

  • Name: Enter the name of the initialized variable.
  • Type: Select the type of the variable as String.
  • Value: I have given ‘Employee Email ID‘ from dynamic content here.
How to use toLower function expression in Power Automate

3. Next, add the ‘Compose’ flow action to convert the Employee Email ID column values using the toLower function expression below.

toLower(variables('Employee EmailID'))
Power Automate toLower expression using SharePoint List

4. Then add the ‘Update item‘ flow action to update the SharePoint Employee Email ID column using the output of the compose flow action from dynamic content.

Set all the required details as shown below.

  • Site Address: Provide the SharePoint site address.
  • List Name: Select the name of the SharePoint list.
  • Id: Select the SharePoint item ID from dynamic content.
  • Title: Select the Title from dynamic content.
  • Employee Email ID: Here, I have given the ‘Outputs’ of the compose action.
How to use the toLower() format in Power Automate

5. Now, it’s time to Save and Test -> Then test it Manually. At this point, add or modify an item in the SharePoint list.

Microsoft Power Automate toLower() function

6. Open the SharePoint Online list then, it will display the output after updating the ‘Employee Email ID‘ in lowercase by applying the toLower expression as shown below.

Power Automate toLower() function format

This is how to use the toLower() function in Power Automate using SharePoint List.

Example 2:Power Automate toLower() function Manually

Let’s find out how to use the Power Automate toLower() function by creating the Instant cloud flow that gets triggered manually.

TextOutput
HARLEY DAVIDSONharley davidson
toLower('HARLEY DAVIDSON')
How to use toLower() expression in Power Automate

To work around this, follow the steps below.

1. Open the Power Automate home page by browsing https://make.powerautomate.com, click on + Create -> Select the Instant cloud flow -> Provide the flow name and choose your trigger’s flow (Manually trigger the flow) -> Click on Create.

2. Then add the ‘Initialize variable’ flow action to store the text value during the flow and set all the required fields.

  • Name: Provide the name of the variable.
  • Type: Select the type of the initialized variable as String.
  • Value: Here, I have given “HARLEY DAVIDSON” as the variable’s value.
toLower() function expression in Power Automate

3. Next, add the ‘Compose’ flow action and set the expression to convert the given string into lowercase.

toLower(variables('BikeBrand'))
How to get lowercase text in Power Automate

4. Once the flow is created, click Save and Test -> Then test it Manually -> The compose flow action will display the output below.

  • The Power Automate toLower() function output will give harley davidson.
How to use toLower() function format in Power Automate

This is how to use the toLower() function in Power Automate Instant cloud flow.

Conclusion

I hope this Power Automate tutorial helps you learn and understand a step-by-step guide on how to use the Power Automate toLower() function. I have also shown the syntax of the toLower() function in Power Automate.

Also, I have given examples of how to use the toLower() function in Power Automate.

Moreover, you may like some more Power Automate tutorials:

>