Power Automate: Proper Case String Workaroud

There is Proper functions in Power Apps to converts any first letter of a word to Uppercase.

But there is no Proper case function in Power Automate yet. 

Reference to a blog post written by Paul Murana to achieve the same result.

Below is the Input.

and here is the Output.

Follow the steps below:

1. Create Data Operation – Compose to input the string.
   
2. Create Control – Apply to each and add Data Operation – Compose inside.
   
3. In Apply for Each, using referencing function to call Compose output. Enter Expression below:

   split(outputs(‘Compose’), ‘ ‘)

    

   

4. In Compose – Proper, enter Expression into Inputs as below:

   if(equals(length(item()), 1), toupper(item()), concat(first(toupper(item())), toLower(substring(item(), 1, sub(length(item()), 1)))))

    

   

5. Create Data Operation – Compose for Result.
   
6. In Compose – Result, enter Expression into Inputs as below:

   join(outputs(‘Compose_-_Proper’), ‘ ‘)

   

You have Proper Case function in Power Automate now.

This post first appeared on Ben's System Center Experience. Read the original article.