Power Apps  

How to Convert Text into Currency ($) Format in Power Apps

Introduction

When building Canvas Apps in Power Apps, you may need to display numeric values in a currency format for better readability and a professional user experience. For example, a user may enter 12345.5, but you want it to appear as $12,345.50.

In this article, you'll learn how to convert text input into a currency format using the Text() function in Power Apps.

Prerequisites

  • Microsoft Power Apps

  • A Canvas App

  • Basic understanding of Power Apps controls

Create a Canvas App

  1. Sign in to Power Apps.

  2. Select Create > Blank canvas app.

  3. Choose your preferred layout (Tablet or Phone).

  4. Add the following controls:

    • Text Input (TextInput1)

    • Label (Label1)

The user will enter a numeric value in the text input, and the label will display the formatted currency.

Default Input

Suppose the user enters the following value:

12345.5

By default, the value appears exactly as entered.

Convert Text to Currency Format

Set the Text property of the label to the following formula:

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

Formula Explanation

  • TextInput1.Text – Reads the value entered by the user.

  • Value() – Converts the text into a numeric value.

  • Text() – Formats the number as currency.

  • [$-en-US] – Uses the English (United States) locale.

  • $#,###.00 – Displays:

    • Dollar symbol ($)

    • Thousands separator (,)

    • Two decimal places

Example

User InputOutput
100$100.00
1234$1,234.00
12345.5$12,345.50
1000000$1,000,000.00

Alternative Currency Formats

Indian Rupee (₹)

Text(
    Value(TextInput1.Text),
    "[$-en-IN]₹#,##,##0.00"
)

Output

₹1,23,456.00

Euro (€)

Text(
    Value(TextInput1.Text),
    "[$-de-DE]€#,##0.00"
)

British Pound (£)

Text(
    Value(TextInput1.Text),
    "[$-en-GB]£#,##0.00"
)

Output

After applying the formula, the label automatically displays the entered value in the selected currency format.

Example:

Input: 12345.5
Output: $12,345.50
Currency

Conclusion

Formatting numeric values as currency improves the readability and professionalism of your Power Apps applications. By combining the Value() and Text() functions, you can easily convert user-entered text into properly formatted currency values.

Whether you're building invoice management, expense tracking, sales, or finance applications, this simple approach helps present monetary values in a clear and consistent format.

If you found this article helpful, feel free to share your feedback. Your suggestions help improve future Power Apps tutorials and make them more useful for the community.