🛠️ 10 Ways to Format Names Dynamically in PowerApps!

Download Demo-App here:

10-Ways-to-Format-Names-Dynamically/ at main · einfachKim/10-Ways-to-Format-Names-Dynamically

📌 1️⃣ First Name Only: "Peter"

Use Case: Display the first name for a personal greeting.

Formula:

Trim(Last(Split("Hansen, Peter", ",")).Value)

📌 2️⃣ Full Name: "Peter Hansen"

Use Case: Standard full name format for emails, reports, and documents.

Formula:

Trim(Last(Split("Hansen, Peter", ",")).Value) & " " & First(Split("Hansen, Peter", ",")).Value

📌 3️⃣ Abbreviated Name: "P. Hansen"

Use Case: Suitable for professional name displays and formal documents.

Formula:

Left(Trim(Last(Split("Hansen, Peter", ",")).Value),1) & ". " & First(Split("Hansen, Peter", ",")).Value

📌 4️⃣ Initials Only: "P. H."

Use Case: Used for profile avatars, ID cards, or user icons.

Formula:

Left(Trim(Last(Split("Hansen, Peter", ",")).Value),1) & ". " & Left(Trim(First(Split("Hansen, Peter", ",")).Value),1) & "."

📌 5️⃣ Username-Style Format: "p.hansen"

Use Case: Ideal for creating usernames dynamically.

Formula:

Lower(Left(Trim(Last(Split("Hansen, Peter", ",")).Value),1) & "." & First(Split("Hansen, Peter", ",")).Value)

📌 6️⃣ Last Name First: "Hansen, Peter"

Use Case: Common in official documents, employee directories, and reports.

Formula:

Trim(First(Split("Hansen, Peter", ",")).Value) & ", " & Trim(Last(Split("Hansen, Peter", ",")).Value)

📌 7️⃣ First Name & Last Name Initial: "Peter H."

Use Case: Good for informal name displays, chats, or team lists.

Formula:

Trim(Last(Split("Hansen, Peter", ",")).Value) & " " & Left(First(Split("Hansen, Peter", ",")).Value,1) & "."

📌 8️⃣ Email-Style Format: "peter.hansen@example.com"

Use Case: Useful for email automation or user account creation.

Formula:

Lower(Trim(Last(Split("Hansen, Peter", ",")).Value) & "." & Trim(First(Split("Hansen, Peter", ",")).Value) & "@example.com")

📌 9️⃣ Reversed Order (First Name Last Initial): "Peter H"

Use Case: Great for casual name displays or team applications.

Formula:

Trim(Last(Split("Hansen, Peter", ",")).Value) & " " & Left(First(Split("Hansen, Peter", ",")).Value,1)

📌 🔟 Shortened Formal Name: "P Hansen"

Use Case: Great for professional but minimalistic name displays.

Formula:

Left(Trim(Last(Split("Hansen, Peter", ",")).Value),1) & " " & Trim(First(Split("Hansen, Peter", ",")).Value)

📢 Wrapping It Up

PowerApps provides powerful string manipulation functions like Split(), Trim(), Left(), and Lower() to dynamically format names.

✅ Whether for reports, emails, user interfaces, or automation, these formulas help ensure a consistent and professional presentation of names.

🔎 Which name format do you use most often? Have a unique format that I didn’t cover? Let’s discuss in the comments! 🚀