Power Apps syntax error: semicolon vs comma
A Power Apps syntax error mentioning unexpected commas or semicolons usually comes from a mismatch between your studio’s language and the formula’s separators, not from the formula logic itself. Power Fx adapts syntax to your region: English studios separate function arguments with a comma and write decimals with a dot (If(x = 1, "a", "b"), 0.5); French (and similar) studios use a semicolon between arguments and a comma for decimals (If(x = 1; "a"; "b"), 0,5). Fix: match every separator to your studio’s language. When pasting a formula written in the other language, swap commas between arguments for semicolons (or vice versa).
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
- 1Match the separator to your studio language: use ";" between arguments if your Power Apps is in French.
- 2Write decimals with a comma in French (e.g. 0,5) and with a dot in English (0.5).
- 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).