Power Apps Format Number With Commas and Decimal Places [6 Best Approaches]

If you’ve ever built a Power Apps canvas app and wondered why your numbers look like plain digits instead of something like 1,250,000.00, you’re not alone. This is one of the most common questions I see from Power Apps makers — and honestly, it’s easier to fix than it looks.

In this tutorial, I’ll walk you through everything you need to know about formatting numbers with commas (thousand separators) and decimal places in Power Apps. I’ll cover multiple methods, show you real formula examples, and help you pick the right approach for your situation.

Let’s get into it.

Why Number Formatting Matters in Power Apps

When you display a number like 1500000 in a label, it’s technically correct — but it’s hard to read at a glance. Your users won’t appreciate squinting at a wall of digits. Formatting it as 1,500,000.00 makes it instantly clear, especially for finance apps, inventory tools, or any app where numbers matter.

Power Apps doesn’t automatically apply formatting as Excel does. You have to tell it exactly how you want numbers displayed. The good news is there’s a built-in function that handles this beautifully — the Text() function.

Power Apps Text() Function — Your Main Tool

The Text() function in Power Apps converts a number (or date/time) into a formatted string. Think of it like Excel’s TEXT() function — same concept, just Power Apps flavor.

Here’s the basic syntax:

Text( NumberOrValue, "FormatString" )

The format string is where all the magic happens. You define exactly how many digits, where commas go, and how many decimal places to show.

Key format placeholders to know:

• # — Shows a digit, but ignores insignificant zeros (won’t show trailing zeros)
• 0 — Shows a digit, and pads with zeros if needed (great for decimal places)
• , — When placed between # or 0 symbols, adds a thousand separator (comma)
• . — Represents the decimal point

Power Apps Format Number with Commas and Decimal Places

Now, let me show you how to actually use these in practice.

Method 1: Power Apps Format a Number with Commas Only (No Decimals)

This is the simplest use case — you just want thousand separators and nothing after the decimal.

Formula:

Text( 1500000, "#,###" )

Output: 1,500,000

Use this in a Label control’s Text property, or inside any formula where you’re displaying a number.

Real-world example:
Say you have a SharePoint list column called TotalSales and you’re showing it in a label:

Text( ThisItem.TotalSales, "#,###" )

This will format whatever value is in that column with commas. Clean and simple.

Method 2: Power Apps Format with Commas AND Decimal Places

This is the one most people actually need — the full 1,250,000.00 format.

Formula:

Text( 1250000, "#,###.00" )

Output: 1,250,000.00

The .00 at the end forces two decimal places. If your number is 1250000, it’ll show as 1,250,000.00. If it’s 1250000.5, it becomes 1,250,000.50.

Why use 0 instead of # for decimals?
Because # won’t pad with zeros. So Text(5000, "#,###.##" ) would give you 5,000 with no decimal part at all — skipping the .00. If you want consistent two-decimal output, always use 0 after the decimal point.

Here’s a quick comparison:

Method 3: Power Apps Add a Currency Symbol

Want to display numbers as currency like $1,250.00? Just add the currency symbol directly into the format string.

Formula:

Text( 1250, "$#,###.00" )

Output: $1,250.00

You can swap $ for any currency symbol — €, £, ₹, whatever fits your app’s audience.

Indian Rupee example:

Text( 1250000, "₹#,##,###.00" )

Note: For Indian number formatting (where you group in 2,xx,xxx style), you’ll need to adjust the comma placement pattern in the format string as I did above.

Method 4: Locale-Aware Formatting with Language Tags in Power Apps

Here’s something a lot of people miss: Power Apps Text() function is globally aware. If your app users are in different countries, the decimal and thousands separators may differ. For example:

• US/UK: 1,250,000.00 (comma = thousands, period = decimal)
• France/Germany: 1.250.000,00 (period = thousands, comma = decimal)

To lock in a specific locale, use the language tag inside your format string:

Formula for US formatting:

Text( 1250000, "[$-en-US]#,###.00" )

Formula for German formatting:

Text( 1250000, "[$-de-DE]#.###,00", "de-DE" )

The [$-en-US] part inside the format string tells Power Apps how to interpret the separators. The optional third argument "de-DE" controls what language the output text uses.

If you’re building apps that’ll be used across regions — say a global SharePoint-connected Power App — this is worth knowing. It prevents situations where your formatting looks different depending on the user’s device locale.

Method 5: Format Numbers in a Text Input (Edit Mode) in Power Apps

Displaying a formatted number in a label is straightforward. But what about when your user is typing a number into a Text Input control, and you want it to format as they go (or when they move to the next field)?

This is a bit trickier because Text Input controls work with text, not numbers. Here’s the cleanest approach I’ve found.

Step 1: Set the OnChange Property of your Text Input:

Set(
    FormattedNum,
    Text(
        Value(TextInput1.Text),
        "[$-en-US]#,###.00"
    )
)

Step 2: Set the Default Property of the same Text Input to:

FormattedNum

What’s happening here:

• Value() converts the text the user typed into an actual number (stripping any existing formatting)
• Text() then reformats that number with commas and decimals
• The result is stored in a variable FormattedNum
• Setting Default to that variable updates the field’s display

Watch out for circular references! If you set both Default and OnChange carelessly, you might run into a circular reference warning. The trick is to use a variable as the bridge (like FormattedNum above) — don’t reference the Text Input’s own .Text property directly in Default.

Method 6: Displaying Formatted Numbers from SharePoint

If you’re pulling data from a SharePoint list into a Gallery or Form, you’ll typically format the numbers in a Label control within the Gallery, not in the data source itself.

Inside a Gallery — Label Text property:

Text( ThisItem.Budget, "[$-en-US]$#,###.00" )

In a Display Form — DataCard Default:

Text( Parent.Default, "#,###.00" )

For Edit Forms, you’d want to format the displayed value but still save the raw number back to SharePoint. In that case, keep your editable Text Input storing the raw number, and use a separate Label to show the formatted version. When saving, use Value() to convert the formatted text back to a number before patching to SharePoint:

Patch(
    'YourList',
    Defaults('YourList'),
    {
        Budget: Value(TextInput1.Text)
    }
)

Quick Reference: Common Format Strings

Here’s a cheat sheet you can bookmark:

Common Mistakes to Avoid

• Using Text() output directly in calculations — Text() returns a string, not a number. If you try to add or multiply the result, you’ll get an error. Always wrap it back in Value() before doing math.
• Forgetting Value() on user input — When a user types 1,250 in a text box, Power Apps sees that as a string. Use Value(TextInput1.Text) to convert it before formatting.
• Using # for decimals when you want consistent zero padding — As I mentioned earlier, # will drop trailing zeros. Use 0 if you always want two decimal places shown.
• Not accounting for locale differences — If your app is global, always add the [$-en-US] (or your target locale) tag to your format string to avoid unexpected behavior on users’ devices.

Putting It All Together — A Practical Example

Let’s say you’re building a budget tracker app connected to a SharePoint list. You have a column called ProjectBudget (a Number column in SharePoint).

In a Gallery label, to display formatted:

Text( ThisItem.ProjectBudget, "[$-en-US]$#,###.00" )

In an Edit Form Text Input, OnChange event:

Set(
    varBudget,
    Text(
        Value(BudgetInput.Text),
        "[$-en-US]$#,###.00"
    )
)

Default property of that Text Input:

varBudget

When saving back to SharePoint:

Patch(
    Projects,
    BrowseGallery1.Selected,
    { ProjectBudget: Value(Substitute(BudgetInput.Text, "$", "")) }
)

Note: I used Substitute() here to strip the dollar sign before converting to a number — Value() can’t handle currency symbols directly.

Number formatting in Power Apps is one of those things that looks complicated at first but follows a simple pattern once you understand the Text() function. Start with "#,###.00" , for most cases, layer in a currency symbol if needed, and add a locale tag if your app goes global.

Conclusion

I hope you found this article helpful. In this post, I explained how to format numbers in Power Apps using commas and decimal places with simple examples.

At first, number formatting might feel a bit confusing, especially with different formats and functions. But once you try it out, it becomes much easier to understand.

You can start with basic formatting using Text() and then adjust it as needed, such as adding commas or controlling the number of decimal places. From there, you can handle different scenarios as your app grows.

Also, you may like:

• 2 Best Methods to Create a Simple Form in Power Apps
• Power Apps App.StartScreen
• 3 Simplest Ways to Create a Navigation Menu in Power Apps Canvas App
• Create a QR Code in Power Apps
• Power Apps Hover Popup

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.