Power Fx function
Proper — Power Fx function reference
Title-case each word.
Syntax
powerfx
Proper( Text )
Examples
powerfx
Proper("jane doe")→ "Jane Doe"
powerfx
Proper(txtCity.Text)
powerfx
Proper(Lower(ThisItem.CompanyName))
Common mistakes & gotchas
- Proper capitalizes the letter after any non-letter character, so results like "O'Brien" often need manual correction — it is not true name-casing.
- Running Proper on already mixed-case text (like "USA" or "iPhone") can produce unwanted results ("Usa", "Iphone") — only apply it to genuinely lowercase input.
Related Power Fx functions
From Text