Power Fx function
Value — Power Fx function reference
Text to number.
Syntax
powerfx
Value( TextOrNumber [, LanguageCode ] )
Examples
powerfx
Value("123.45")→ 123.45
powerfx
Value(txtQty.Text) * Value(txtPrice.Text)
powerfx
IfError(Value(txtAmount.Text), 0)
Common mistakes & gotchas
- Value() on unparseable text returns an error, not blank or zero — wrap user-typed input with IfError to avoid a hard error when a field is empty or non-numeric.
- Decimal-separator parsing is locale-dependent ("1,234.56" vs "1.234,56") — pass LanguageCode explicitly if the source format is fixed regardless of the running user's locale.
Related Power Fx functions
From Data conversion