Diese Seite gibt es auch auf Deutsch.
Power Fx Translator
Switch Power Fx formulas between en-US and de-DE regional formats: decimal separator, list separator and chaining operator.
When you paste English Power Fx code from docs, blogs or colleagues into an environment that uses a comma as decimal separator, Power Apps reports a syntax error. The translator converts the separators. Function names always stay English in Power Apps (If, Filter, Collect, LookUp). Auto-detect no longer takes RGBA(255,0,0,1) for German, and Text() with a format string without a language prefix gets a note.
Free. You enter your email address once, then all tools are unlocked. Your data is processed locally in your browser.
How it works
- Paste the formula into the input field.
- Pick a direction or let the tool detect it.
- Copy the converted formula and paste it into Power Apps.
Example: en-US to de-DE
// en-US (original)
If(Slider1.Value > 12.59, Notify("Valid", Success); Navigate(Screen2), Notify("Invalid", Error))
// de-DE (output)
If(Slider1.Value > 12,59; Notify("Valid"; Success);; Navigate(Screen2); Notify("Invalid"; Error))The rules at a glance
Switching the regional format changes exactly three characters, and all of them depend on the decimal separator of the language:
| Meaning | en-US (dot) | de-DE (comma) |
|---|---|---|
Decimal separator (e.g. 1.5) | . dot | , comma |
| List separator (arguments, record fields, table rows) | , comma | ; single semicolon |
| Chaining operator (several actions in a row) | ; single semicolon | ;; double semicolon |
Watch out: a comma becomes a single semicolon. The double semicolon ;; only comes from the English single ; (chaining), because in de-DE the single semicolon is already the list separator.
What stays the same: function names (If, Filter, Collect), property names (Screen1.Fill), enum values (Color.Aqua), text in quotes, names in single quotes ('Price, CHF') and comments. In string interpolation $"..." only the expressions in curly braces are converted.
Frequently asked questions
Is the Power Fx translator free?
Yes.
Are my formulas uploaded?
No. The conversion runs entirely in your browser.
Are function names translated (e.g. If to Wenn)?
No. Function names are always English in Power Apps, only separators and the chaining operator change.
What exactly changes?
The decimal separator (dot or comma), the list separator for arguments and records (comma or semicolon) and the chaining operator (semicolon or double semicolon).
Do text and names in quotes stay unchanged?
Yes. Strings, names in single quotes such as 'Price, CHF' and comments are left alone.
What about Text() and format strings?
A format such as "#,##0.00" without [$-en-US] is read in the author's language. Put [$-en-US] in front and it formats the same everywhere.