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 Input | Output |
| [email protected] | [email protected] |
Please refer to the below image.
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.
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.
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.
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'))
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.
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.
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.
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.
| Text | Output |
| HARLEY DAVIDSON | harley davidson |
toLower('HARLEY DAVIDSON')
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.
3. Next, add the ‘Compose’ flow action and set the expression to convert the given string into lowercase.
toLower(variables('BikeBrand'))
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.
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:
- Power Automate toUpper() Function
- How to Use Power Automate trim() Function
- Power Automate Trigger Conditions Examples
After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.
