PowerBlocks
GuidesPower Apps syntax error: semicolon vs comma
Power Apps

Power Apps syntax error: semicolon vs comma

In French (and some other) regions, Power Apps uses ";" to separate function arguments and "," as the decimal separator. Mixing them up causes syntax errors.

Why the separator changes

Power Apps (Power Fx) adapts its formula syntax to your authoring language/region. In en-US, arguments are separated by commas and decimals use a dot. In fr-FR, arguments are separated by semicolons and decimals use a comma.

So the same formula is written If(x = 1, "a", "b") in English and If(x = 1; "a"; "b") in French.

How to fix the error

  1. 1Match the separator to your studio language: use ";" between arguments if your Power Apps is in French.
  2. 2Write decimals with a comma in French (e.g. 0,5) and with a dot in English (0.5).
  3. 3When you copy a formula from an English source, swap commas between arguments for semicolons (PowerBlocks tools let you copy in EN or FR directly).