How to Convert Text to Currency in Power Apps?

Are you currently developing a Power Apps form? If the form has a price field that accepts numerical inputs, it’s necessary to format the number as currency. Using the Power Apps Text() function, we can easily convert the text to currency in Power Apps.

This tutorial will teach you how to convert text to currency in Power Apps with different examples.

Also, this tutorial will show you how to format the number as currency in euro format.

How to Convert Text to Currency in Power Apps

Let’s check how to format the number as currency in Power Apps.

For Example, I created a Power Apps canvas app and added a Text-input and label control. Once the user provides the number in the text input, the label should display the value in dollars, formatted as currency.

Power Apps convert text to currency

Follow the below steps to achieve this:

  • Sign into Power Apps with your valid Microsoft 365 Credentials.
  • Create a Blank canvas app -> On the Power Apps screen, insert a Text input control as shown below:
How to convert text to currency in Power Apps
  • Insert a Text label control -> Set its Text property to:
Text(
    Value(txt_ProductCost.Text),
    "[$-en-US],$#,###.00"
)

Where,

  1. txt_ProductCost = Text input control name
Power Apps currency format with commas
  • Once your app is ready, Save, Publish, and Preview the app. When the user provides the value in the text-input control, the label will convert that number as currency, as shown below:
Convert text to currency in Power Apps

This is one way to convert text to currency in Power Apps [in dollars].

Convert Text to Currency in Power Apps [in Euro]

Next, we will see how to convert text to currency in Power Apps in an euro format.

  • To convert a number to the euro currency format, Select the Label control -> Set its Text property as:
Text(
    Value(txt_ProductCost.Text),
    "[$-en-US],€###,###.00"
)

txt_ProductCost = Text input control name

Power Apps format currency euro
  • Now, you can see that the value will be formatted as currency euro in Power Apps as shown below:
Format currency euro in Power Apps

I have shown you by formatting the number as currency manually. Now, let’s find out how to convert text to currency using a SharePoint list.

Power Apps Convert Text to Currency [Using SharePoint List]

I have a requirement: the Power Apps form has a cost field that accepts numerical inputs, but I need to format that number as currency; let’s see how to achieve it.

For example, I have a SharePoint list [Power Platform Training] that has various columns as:

Column NameData type
User IDTitle
User NameSingle line of text
CourseChoice [“Power Apps,” “Power Virtual Agent,” “Power Bi,” “Power Automate”]
Course CostCurrency
Power Apps format number as currency using SharePoint list

I have added an Edit form connected to the above SharePoint list on the Power Apps screen. The form contains a Text input control of the Course Cost field. It takes only the numerical value, but I need to display it in the currency format as shown below:

Power Apps format number as currency

To achieve it, follow the below steps:

  • On the Power Apps screen, insert an Edit form -> Set its DataSource property to:
'Power Platform Training'

Where,

  1. Power Platform Training = SharePoint list name
Format number into currency in Power Apps
  • Select the Text input control of the “Course Cost” field -> Set its OnChange property to:
Set(
    varCurrency,
    Text(
        RoundUp(
            Value(DataCardValue8.Text),
            2
        ),
        "[$-en-US]$#,###.00"
    )
)

Where,

  1. varCurrency = Provide the variable name
  2. DataCardValue8 = Text-input control name of the Course Cost field.
Power Apps Format number into currency
  • Select the Text input control -> Set its Text property to:
varCurrency

Where,

  1. varCurrency = Variable name
How to format number as currency in Power Apps
  • SavePublish, and Preview the app. When the user provides the numerical value in the Course Cost field, that numerical value will be converted to a currency, as shown below:
Format text as currency in Power Apps
  • Once the user submits the Power Apps form, the Course cost will be saved to a SharePoint list in a currency format as shown below:
Format number as currency using SharePoint list in Power Apps

I converted the text to currency using a SharePoint list in Power Apps.

Conclusion

We can easily format the number as currency using the Power Apps Text() function.

I hope this Power Apps helped you by converting the text to currency in a Power Apps form, and also, you have learned how to format the number as currency manually.

Lastly, you also learned about the Power Apps format currency euro.

Also, you may like some more Power Apps tutorials: