Capitalize first letter in string

(0) Share

Report

Posted on by Community Power Pla...

Hi I have a Question:

What is the best/simplest way to capitalize the first letter in a string

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Community Power Pla... on at

Like (4)

Report
alright, after about one hour trial and error I found a solution:

concat(first(toupper('susanne')),substring('susanne',1,sub(length('susanne'),1)))
If anyone has an easyer solution I would much appreciate it 🙂

Was this reply helpful? Yes No
umakanta84 8 on at

Like (3)

Report

There are different ways to make it :
if you want to make first letter of a word to Capitalized then you can use Proper.
ex : Proper("umakanta swain") output : Umakanta Swain

if you want to Capitalize only first character of the string/sentence then
ex: mystring = what is your name umakanta ? Left(mystring,1) & Right(mystring, Len(mystring)-1)
output : What is your name umakanta ?

Was this reply helpful? Yes No
Bram 8 on at

Like (3)

Report

for PowerApps:
Replace("text", 1, 1, Upper(Left("text"), 1)))

Was this reply helpful? Yes No
TurraWorku 2 on at

Like (0)

Report

Easy way to do it it by power query. Go to transform and select Capitalize Each Words in format tab.

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (4)

Report

Proper() is not a PowerAutomate string function !

Was this reply helpful? Yes No
Dunksta 25 on at

Like (0)

Report
You can use Proper() in powerapps but it only converts the text when saving. If like me, you want to see the capitalization happen as the user types, you can use some simple trickery.

Add your text field as per normal, but set it's text colour to transparent. We'll call this text field myTextField
Place a Label over the text field, and set it's Text value to Proper(myTextField) function
Set the labels On Select property to SetFocus(myTextField)
Set the Update property of the card, assuming you're using a form, to Proper(myTextField)

Was this reply helpful? Yes No
jony_19 40 on at

Like (1)

Report

I found a much simpler way.

concat(toUpper(take(<string>, 1)), toLower(skip(<string>, 1)))

https://tomriha.com/making-the-first-character-upper-case-using-power-automate-flow/

Was this reply helpful? Yes No
PA_Forum_User 71 on at

Like (0)

Report

This also works!

Thank you for your post!

Was this reply helpful? Yes No