🧠 Automating Name Formatting with Power Automate — From “KRIsh KANAkiya” to “Krish Kanakiya”

Introduction

While working with business data, one common issue we often face is inconsistent text formatting — especially names. Users might enter names in all caps, random casing, or mixed styles like “KRIsh KANAkiya.”

Such inconsistencies can make data look unprofessional and difficult to process in reports or applications. To address this, I decided to automate the name formatting process using Power Automate , ensuring every name is stored in a clean, standardized format automatically.

Flow Objective

The main goal of this Power Automate flow is to:

• Take an input name (e.g., KRIsh KANAkiya)

• Convert it into proper case (e.g., Krish Kanakiya)

• Save or return the formatted result for further use in PowerApps, SharePoint, or email notifications.

Flow Design Steps

1. Trigger

You can start the flow in multiple ways:

• From PowerApps using a button click

• When an item is created or modified in SharePoint

• Or even manually from Power Automate

For this demo, I used a manually trigger a flow.

2. Initialize a Variable

Next, initialize a string variable to store the formatted name:

• Name: varFinalName

• Type: String

• Value: Leave blank

3. Apply to Each

• Select an output from trigger:

  
    split(toLower(trim(triggerBody()?['text'])), ' ')
  

This expression first trims any extra spaces from the input text, converts it to lowercase, and then splits the name into individual words based on spaces — preparing it for proper case formatting in the next step.

• Add "Append to string array" inside Apply to Each:

  • Name: varFinalName

  • Value:

  
    concat(concat(
  toUpper(substring(item(), 0, 1)),
  toLower(substring(item(), 1, sub(length(item()), 1)))
), ' ')
  

This expression capitalizes the first letter of each word, converts the remaining letters to lowercase , and adds a space after each word — helping build the properly formatted full name.

4. Compose

• Inputs:

  
    trim(variables('varFinalName'))
  

This removes any extra spaces at the beginning or end of the formatted name, ensuring the final output looks clean — for example,
"Krish Kanakiya" instead of " Krish Kanakiya ".

Conclusion

This simple yet effective Power Automate flow demonstrates how easily we can enhance data quality through automation. By converting inconsistent name formats like “KRIsh KANAkiya” into clean, standardized formats such as “Krish Kanakiya,” we not only improve readability but also ensure uniformity across systems like PowerApps, SharePoint, and Dataverse.

Automating small tasks like this can have a big impact — reducing manual corrections, saving time, and keeping your business data consistent and professional. It’s a great example of how Power Automate can simplify everyday data challenges with smart logic and expressions.