Power Apps: Convert Text to Currency Format Easily

In many business applications, users frequently enter monetary amounts as text values. These inputs can come from various sources like forms, text inputs, Excel imports, SharePoint lists, or API integrations. To enhance readability and provide a polished user experience, these text values often need to be displayed in a currency format.

Fortunately, Power Apps offers the Value() and Text() functions, which make it straightforward to convert text into properly formatted currency values. The Value() function converts text into a numeric value, while the Text() function formats numbers into currency strings.

In this article, we will explore how to convert text into currency format in Power Apps.

Why Convert Text into Currency Format?

Converting text to currency format is essential in several common business scenarios:

• Invoice Amounts
• Sales Reports
• Purchase Orders
• Expense Management
• Financial Dashboards
• Budget Tracking

The benefits of implementing this conversion include:

• Professional Display: Presents financial data in a universally recognized format.
• Better Readability: Makes large numbers easier to understand at a glance.
• Consistent Formatting: Ensures all monetary values are displayed uniformly.
• Improved User Experience: Reduces cognitive load for users interacting with financial data.
• Financial Accuracy: Helps prevent misinterpretations of numerical values.

Business Scenario

Imagine a user enters the value 12500.75 into a TextInput control. The requirement is to display this as $12,500.75.

Understanding the Functions

Value()

This function converts text into a numeric value.

Example:

Value("12500.75")

Output:

12500.75

The Value() function is crucial for transforming strings that contain numeric characters into actual numbers that can be used in calculations or formatted for display.

Text()

This function formats numeric values for display.

Example:

Text(12500.75, "$#,##0.00")

Output:

$12,500.75

The Text() function is highly versatile and can format numbers using custom currency patterns, allowing for precise control over the output.

Currency Conversion Workflow

The typical workflow for converting text to currency in Power Apps involves the following steps:

1. TextInput: User enters text data.
2. Value(): Convert the text to a numeric value.
3. Convert to Number: The value is now a number.
4. Text(): Format the number into the desired currency string.
5. Currency Format: The number is displayed as currency.
6. Display Result: The formatted currency value is shown to the user.

Step 1: Create a Canvas App

Navigate to make.powerapps.com, go to Apps, and select Canvas app. Choose either the Tablet layout or Phone layout.

Step 2: Add Controls

Insert a TextInput control and rename it to txtAmount. Add a Label control and rename it to lblCurrency.

Step 3: Convert Text to Currency

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

Text( Value(txtAmount.Text), "$#,##0.00" )

When a user enters 12500.75 into txtAmount, the lblCurrency will display $12,500.75. This pattern is commonly used in Power Apps to display user-entered numbers as currency.

Examples of Currency Formatting

Example 1: USDollar Format

Formula:

Text( Value(txtAmount.Text), "$#,##0.00" )

Input: 5000

Output: $5,000.00

Example 2: Euro Format

Formula:

Text( Value(txtAmount.Text), "€#,##0.00" )

Input: 5000

Output: €5,000.00

Different currency symbols can be specified directly within the format string.

Example 3: British Pound

Formula:

Text( Value(txtAmount.Text), "£#,##0.00" )

Output: £5,000.00

Example 4: Locale-Based Currency

Power Apps supports locale-specific formatting through an optional language parameter.

Formula:

Text( Value(txtAmount.Text), "$#,##0.00", "en-US" )

Output: $12,500.75

Example 5: SharePoint Currency Value

When working with SharePoint lists that have a Currency column (e.g., named 'Amount'), you can format it directly:

SharePoint Column: Amount

Formula:

Text( ThisItem.Amount, "$#,##0.00" )

Output: $25,000.00

Example 6: Gallery Currency Display

In a gallery control, to display a currency field (e.g., 'TotalAmount'):

Inside Gallery Label:

Text( ThisItem.TotalAmount, "$#,##0.00" )

Result: A professional financial display within each gallery item.

Example 7: Form Currency Field

For currency fields within a Power Apps form, you often set the DataCardValue's Default property:

DataCard Default:

Text( Parent.Default, "[$-en-US]$#,##0.00" )

This approach is frequently used when displaying currency fields in Power Apps forms to ensure correct formatting.

Real-World Example: Invoice Management App

Consider an invoice management app where a user enters the amount 35000. The Power App should display this as $35,000.00.

The workflow is simple:

1. User Input: 35000
2. Value(): Converts to the number 35000.
3. Text(): Formats the number to $35,000.00.
4. Currency Display: The formatted value is shown.

This leads to a professional invoice system.

Expense Approval Example

For an employee expense of 1250.5:

Employee Expense: 1250.5

Formula:

Text( Value(txtExpense.Text), "$#,##0.00" )

Output: $1,250.50

This is incredibly useful for:

• Expense Reports
• Approvals
• Finance Apps

Common Currency Formats

Here are some commonly used currency formats:

• Standard Currency: "$#,##0.00"
  Output: $1,250.00
• No Decimals: "$#,##0"
  Output: $1,250
• Three Decimals: "$#,##0.000"
  Output: $1,250.123

Common Functions Used

• Convert Text to Number: Value()
• Format Number: Text()
• Round Values: Round()
• Convert to Integer: Int()
• Calculate Totals: Sum()

Best Practices

To ensure robust and user-friendly currency formatting:

• Always Validate User Input: Ensure values contain numbers before attempting conversion.
• Use Value() Before Text(): Convert text properly to a number first.
• Use Locale Settings: Support international users by leveraging locale-specific formatting.
• Standardize Currency Format: Maintain consistency across all screens and components.
• Format at Display Time: Keep stored values numeric and format them only when displayed.

Common Challenges

• Invalid Text Value: Input like ABC123 cannot be converted to currency. Implement error handling.
• Empty TextInput: An empty input might return blank values. Handle this case gracefully.
• Wrong Currency Symbol: Verify the format string and currency symbol used.
• Decimal Issues: For two decimal places, ensure you use "$#,##0.00".

Benefits of Proper Currency Formatting

• Better Financial Reporting: Professional formatting leads to clearer reports.
• Improved User Experience: Easy-to-read values reduce user confusion.
• Consistent Data Presentation: Standardized currency display builds trust.
• Better Dashboards: Clear financial metrics are crucial for decision-making.
• Enterprise Ready: Suitable for critical business applications.

Workflow Summary

The complete workflow looks like this:

TextInput → Value() → Number Conversion → Text() → Currency Format → Display Result

Conclusion

Converting text into currency format in Power Apps is a common and essential requirement for financial and business applications. By effectively combining the Value() and Text() functions, developers can easily transform user-entered text into professional currency displays.

Whether you are building invoice systems, expense trackers, sales dashboards, approval applications, or financial reports, proper currency formatting significantly improves readability, consistency, and the overall user experience. Power Apps provides flexible formatting options that support multiple currencies, decimal precision, and regional settings, making it a powerful tool for any financial application development.