PROPER

Use the PROPER function to capitalise the first letter of each word in a text value and converts all other letters to lowercase letters.

Use

PROPER( text )
Capitalizes the first letter in each word in the text.

Parameter	Required	Description
text	Yes	the text to capitalise

Returns

Text

Examples

Standardizing Requester Names (Input Mapping)

In an Input Mapping formula, you can use PROPER to ensure that a person's name is formatted correctly before it is displayed to an approver in an Activity step.

• Scenario: A user submits a "Travel Request" via a Teams Trigger, but they enter their name in all lowercase (e.g., "john doe") or all uppercase (e.g., "JOHN DOE").
• Formula: PROPER(@Trigger.out.RequesterName)
• Logic:
  • @Trigger.out.RequesterName: This identifies the specific output data from the trigger form.
  • Result: The function automatically reformats the text to "John Doe". This ensures consistency regardless of how the user typed it.

Cleaning Project Titles (Variable Update)

You can use PROPER within a Variable Update formula to clean up descriptive titles before they are sent to a reporting connector or used in a final End step.

• Scenario: A "Project Initiation" workflow requires a project title. A user enters "ANNUAL budget PLAN 2025." You want to store a "clean" version of this title in a variable called $StandardizedTitle.
• Formula: PROPER(@Trigger.out.ProjectTitle)
• Update Point: Set this to trigger "Before step starts" on the first review activity.
• Logic:
  • The function looks at each word in the string.
  • Result: It converts the messy input into "Annual Budget Plan 2025". This formatted text can then be used in Display Data elements on subsequent forms to maintain a professional appearance.