Microsoft provides a list of functions to make Power Apps applications more flexible and responsive. One of the key functions within Power Apps is the “Value” function. The Value function is used to convert a text string into a number or date/time format.
In this tutorial, I will explore all the information about the PowerApps Value function, including its definition and properties.
Also, we will discuss how to convert PowerApps text to number, and how to convert PowerApps date to number.
Power Apps Value Function
Power Apps Value Function converts a string of text to a number value. It can be used to calculate numbers.
You can specify the value with a language tag that is returned by the Language function. The string of text is interpreted in the language of the current user. Different languages interpret “,” and “.” differently.
Below are some points that you need to remember while working with the Power Apps Value Function:
- If the string is in scientific notation with “15*10^2“, the value will be expressed as “15e2“.
- If the string contains a percentage symbol (%) at the end, it specifies as a percentage. The specific number will be divided by 100 before it is returned.
- You need to keep in mind that Percentages and Currency symbols can not be mixed.
- If a string contains a Currency symbol ($) for the current language, it will ignore it. However, the currency symbol is not ignored for other languages.
- If the number is not in a proper format, then a blank value will return.
- Similarly, you can convert the date and time values using the DateValue, TimeValue, or DateTimeValue functions.
Power Apps Value Function Syntax
The syntax of PowerApps Value Function is:
Value( String [, LanguageTag ] )Where,
- String = This is Required. Provide a text or string to convert it to a numeric value.
- LanguageTag = This is optional. It helps to parse the string. It will use the current user’s language if you do not specify a language. The Language function always returns “en-US. “
Power Apps Value Function Examples
Follow the table below that represents some Value function examples with different formulas and their results.
| Formula | Description | Result |
| Value( “789,123” ) | “es-ES” is the language tag for Spanish in Spain. In Spain, a period is a thousand separators | 789123 |
| Value( “789.123” ) | Here, the default language of “en-US” will be used, which uses a period as the decimal separator | 789.123 |
| Value( “789.123”, “es-ES” ) | “es-ES” is the language tag for Spanish in Spain. In Spain, a period is a thousand separators | 789123 |
| Value( “54e3” ) | This specifies the scientific notation for 54*10^3 | 54000 |
| Value( “78.19%” ) | Here the value represents a percentage symbol at the end of the string, so it is a percentage | 0.7819 |
| Value( “$ 78.19” ) | Here, the currency symbol is ignored for the current language | 78.19 |
| Value( “789,123”, “es-ES” ) | “es-ES” is the language tag for Spanish in Spain. In Spain, a Comma specifies with a Decimal separator | 789.123 |
Power Apps Convert Text to Number
Here, we will see how to convert text input to a numerical value or number in Power Apps with a simple scenario:
Scenario:
I have created a SharePoint Online list named “Products Details.” this list contains the below fields.
| Column Name | Data Type |
| Product Name | It is a default single line of text |
| Purchase Date | Date and time |
| Price | Number |
In Power Apps, there are two text input controls: a date picker and a button control. Whenever the user adds a new record and clicks on the button control, the new record will be saved with the product’s price, including the currency format.
Have a look at the below screenshot for the output.
To Work around this, follow the below steps. Such as:
1. On the Power Apps Screen -> Insert two text input controls [txt_ProductName and txt_Price], a date picker control [dte_Purchasedate], and a button control [btn_Submit].
2. Now, select the button control and set its OnSelect property to the code below.
OnSelect = Patch(
'Product Details',
Defaults('Product Details'),
{
Title:txt_ProductName.Text ,
'Purchase Date': dte_PurchaseDate.SelectedDate,
Price: Value(txt_Price.Text)
}
)Where,
- Product Details = SharePoint Online list
- Price: Value(txt_Price.Text) = We can use the Value() function to convert the text into a number
3. Once your app is ready