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.
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.
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.
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.
4. Now, let’s save and Test the flow. Click on Save. Test it Manually.
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”.
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.
|User Profile Name||It is a single line of text – Title column|
|Email Address||Single line of text column|
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.
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.
3. Next, add the “Compose” data operation to provide toLower() expression along with the variable inputs, as shown below.
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 Test the flow. Click on Save and Test -> Test it Manually.
6. Then, the SharePoint list item will get updated with lowercase characters, as represented in the screenshot below.
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:
- Power Automate IndexOf() Function
- Power Automate LastindexOf() Function
- Power Automate startswith Function
- Power Automate Contains() Function
Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book Microsoft Power Platform A Deep Dive. She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.