cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Capitalize first letter in string

Hi I have a Question:

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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 🙂

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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 🙂

View solution in original post

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 ?

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (24,941)