Driver FixRecommendedSound, Wi-Fi or graphics acting up? Check drivers firstFind missing or outdated drivers fast.Check DriversHalloween DealsAmazon USHalloween week deals: useful picks before month-endAmazon US: current deals, useful picks and tech finds.Check DealsWindows FixRecommendedWindows errors stealing your time? Find the fix fastScan stability, cleanup and performance issues.Fix Now×
Skip to content
World desk3 min

Power Fx Formulas for Everyday App Tasks—and How French Separators Change Them

Power Fx uses locale-dependent punctuation: French-style formulas use commas for decimals, semicolons for arguments, and double semicolons to chain actions.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Power Fx formulas can look different in French-style comma-decimal authoring even when they express the same logic. The key is to distinguish argument separators from action chaining: in that locale, a single semicolon separates function arguments, while a double semicolon chains actions. A dot in a property reference such as Slider1.Value remains a dot.

Why the same Power Fx formula can use different punctuation

Power Fx follows the author’s locale for decimal and list separators. Microsoft says the underlying formula does not change across author locales; the separators are displayed and edited according to each author’s language settings. Its overview puts the French case plainly: “To be as approachable as possible for makers at all levels, it’s important that 3,14 is a decimal number for a person in France who has used that syntax all their lives.” Microsoft’s Power Fx overview explains the broader principle.

As an Amazon Associate I earn from qualifying purchases.

Authoring convention Decimal marker Function and list separator Action chaining
Dot-decimal (Microsoft’s examples include UK and Japan) . , ;
Comma-decimal (Microsoft’s examples include France and Spain) , ; ;;

The mapping applies beyond function arguments: separators also distinguish record fields and records in tables. Microsoft’s global support documentation describes the locale-dependent syntax.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Do not change the property-access dot

The dot in Slider1.Value means “the Value property of Slider1.” It is not a decimal marker or list separator, so it stays a dot in both authoring conventions. Microsoft’s operator reference documents property access separately from separators.

#1 Best Overall
Microsoft Surface Pro 2-in-1 Laptop/Tablet (2025), Windows 11 Copilot+ PC, 12" Touchscreen Display, Snapdragon X Plus (8 Core), 16GB RAM, 256GB Storage, Platinum
  • [This is a Copilot+ PC] — The fastest, most intelligent Windows PC ever, with built-in AI tools that help you write, summarize, and multitask — all while keeping your data and privacy secure.
  • [The Power of a Laptop, the Flexibility of a Tablet] — Surface Pro 12” is a 2-in-1 device that adapts to you. Use it as a tablet for on-the-go tasks, prop it up with the built-in kickstand, or attach the Surface Pro Keyboard (sold separately) to turn it into a full laptop.
  • [Incredibly Fast and Intelligent] — Powered by the latest Snapdragon X Plus processor and an AI engine that delivers up to 45 trillion operations per second — for smooth, responsive, and smarter performance.
  • [All Day Battery Life] — Up to 16 hours of battery life[1] means you can work, stream, and create wherever the day takes you — without reaching for a charger.
  • [Brilliant 12” Touchscreen Display] — The PixelSense display delivers vibrant color and crisp detail in a sleek design — perfect for work, entertainment, or both.

Single semicolon versus double semicolon

In comma-decimal authoring, a single semicolon separates arguments in a function such as If, and can also separate record fields or table records. A double semicolon, ;;, chains actions. In dot-decimal authoring, commas separate function arguments and a single semicolon chains actions. Mixing these roles is a common reason a formula that looks familiar will not parse.

Choose a result and give feedback with If and Notify

If selects a result based on a condition; an action formula can use Notify to show feedback. For example, this pattern notifies the user and navigates only when a save condition succeeds. The punctuation shown here is for comma-decimal authoring:

Rank #2
Microsoft Surface Pro 7+ Tablet, 12.3in(2736 x 1824) Touchscreen, Core i5-1135G7 2.4GHz, 8GB RAM, 256GB SSD, CAM, Windows 11 Pro(Renewed)
  • Laptop Size: This renewed Microsoft Surface Pro 7+ Tablet, has a screen size of 12.3 " and touch display. The 2736 X 1824 Pixel anti-glare screen, mostly reduces fatigue when using it, allowing you to focus on work. With a light weight, this Microsoft Surface refurbished laptop is a great choice for your Business and entertainment.
  • Processor: This Renewed Surface Pro 7 Plus Tablet is installed with Intel Core i5-1135 G7 (2.4GHz-4.2GHz, 4Cores, 8Threads, 8 MB Intel Smart Cache), meeting the fast and stable operation of most programs.
  • Powerful Memory: This refurbished Tablet has installed 8GB of RAM running memory and 256GB of Solid State Drive for you, allowing you to run multiple software and browsers at the same time with confidence, the Microsoft Surface powerful hard drive gives you enough space to download files!
  • Multiple Ports:USB 3.0, microSD card reader(Optional), Headphone jact, Mini DisplayPort, Cover port, Charging port, this Microsoft SurfaceTablet allows you to fully enjoy the pleasure brought by technology.
  • System: Windows 11 Pro is recognized as the most stable operating system, which is mostly for both commercial and professional users. Windows 11 Pro provides more security and management features for this used Surface Pro 7 (+) Tablet, as well as supporting virtualization and remote access. Meanwhile, it supports multiple languages, including English, French, Spanish, German, etc.
If( SaveSucceeded; Notify( "Saved" );; Navigate( DetailsScreen ) )

Here, the semicolons between the three If arguments are list separators. The ;; between Notify and Navigate chains the two actions. In dot-decimal authoring, the equivalent punctuation pattern is:

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
If( SaveSucceeded, Notify( "Saved" ); Navigate( DetailsScreen ) )

These are syntax illustrations, not a claim about formula popularity. Use the separators shown by your authoring locale, and adapt the condition, notification text, and destination to your app. Microsoft’s global support page demonstrates the same locale-dependent distinction with conditional feedback and navigation.

Rank #3
Sale
Microsoft Surface Pro (2026), 13-inch Premium Performance 2-in-1 Laptop, Snapdragon X2 Plus Processor, Touchscreen Display, 16GB RAM, 512GB SSD Storage, Windows 11 Copilot+ PC Built for AI, Black
  • A PREMIUM PERFORMANCE 2-IN-1 LAPTOP & TABLET — Ready for work, school, and creativity. Built for busy days, big projects, and nonstop multitasking. Run video calls, school and work apps, 20+ browser tabs, and AI tools at the same time without slowing down.
  • WITH AI BUILT IN — With a dedicated AI chip (Qualcomm Snapdragon X2 Plus), this Copilot+ PC[5] on Windows 11 helps you work smarter and faster. Prompt, create, and automate with ease — ready for even your most demanding tasks.
  • A STUNNING 13" OLED TOUCHSCREEN — Sharp colors, real detail, and smooth 120Hz scrolling on the PixelSense touchscreen[1] with LCD display[2]. Tap, scroll, draw, or pinch to zoom — whichever feels right for streaming, sketching, or daily work.
  • 15.5 HOURS OF BATTERY (LEAVE THE CHARGER) — Up to 15.5 hours of video playback[3] on a single charge. Work from a coffee shop, take it to class/work, or binge a season on a long flight — it'll keep up.
  • THE PORTS YOU NEED — Two USB-C / USB4[4] ports for fast charging, big file transfers, or hooking up to three 4K monitors when you want a full desktop. Wi-Fi 7 keeps you online and fast wherever you are.

Format numbers and dates for the person using the app

Use Text when a value needs a particular display format or language, rather than assuming the maker’s locale is the right one for every user. Microsoft documents custom number and date formats and an optional language tag. For French formatting, it shows the [$-fr-FR] language tag; in comma-decimal authoring, function arguments are separated by semicolons.

Text( 1234,56; "[$-fr-FR]#,##0.00 €" )

This illustrates the French language tag and a number format with grouping, two decimal places, and a euro symbol. Formatting controls how a value is displayed; it does not change the authoring rules for separators. An explicit language tag can also determine the language used for date names. See Microsoft’s Text function reference for format-string details and examples.

Rank #4
Microsoft Surface Pro 7 12.3in Intel Core i5 10th Gen 8GB RAM 128GB SSD Platinum (Renewed)
  • Intel Core i5-1035G4 3.70GHz processor, 128GB SSD Drive
  • 8GB RAM, Wireless: 802.11a/b/g/n/ac Wi-Fi, Bluetooth 4.0
  • Ports: Full-size USB 3.0; microSD card reader; Headphone jack; Mini DisplayPort; Cover port; Charging port, Camera: 5MP front-facing and 8MP rear-facing cameras with 1080p HD video recording
  • Display: 12.3-inch PixelSense touchscreen display; 2736 x 1824 resolution, Stereo speakers with Dolby Audio-enhanced sound
  • Operating System: Windows 10 Home, Intel Iris Plus Graphics
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Parse imported numeric text using its source convention

Value and Decimal convert text to numeric values, and locale information can affect how they interpret decimal and grouping marks. A string that represents a number under one country’s conventions may not mean the same thing under another’s. At an import boundary, specify the source language where needed instead of assuming the text follows the maker’s locale.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

For instance, when imported text uses French number conventions, a comma-decimal formula can pass an explicit language tag:

Best Value
Microsoft Surface Pro 7 Plus Tablet 2-in-1 Intel Core i3 8GB RAM 128GB SSD 12.3 Inch Touchscreen Platinum Silver Windows 11 PRO (Renewed)
  • Microsoft Surface Pro 7+ 12.3" Tablet 2-in-1 Laptop, Amazon Renewed, Core i3 with 128GB SSD and 8GB RAM
  • More ways to connect, with both USB-C and USB-A ports for connecting to displays, docking stations and more, as well as accessory charging, Platinum Silver Color
  • Standout design that won’t weigh you down — ultra-slim and light Surface Pro 7+ starts at just 1.70 pounds. Aspect ratio: 3:2
  • Intel Core i3-1114G5 (1.70-3.0Ghz) | 128GB SSD | 8GB RAM | Windows 11 Professional Installed
  • Screen: 12.3” PixelSense Display | Resolution: 2736 x 1824 (267 PPI) | Faster than Surface Pro 6, with a 10th Gen Intel Core Processor – redefining what’s possible in a thin and light computer. Wireless : Wi-Fi 6: 802.11ax compatible. Bluetooth Wireless 5.0 technology
Value( ImportedAmount; "fr-FR" )

Confirm the expected input format against the data source’s contract, including its decimal and grouping marks; a language tag is not a substitute for validating what the external system actually sends. Microsoft also cautions that locale formats matter when exchanging data with external systems. See the Value and Decimal function reference.

Localize the app at display and input boundaries

Internationalization is not just about changing labels. Microsoft’s global guidance identifies Language, Text, Value, and DateValue as relevant when adapting what users see and how values are interpreted across languages. Use display formatting for output and locale-aware parsing for incoming text; keep the data contract explicit where the app exchanges values with another system. The authoring punctuation still follows the maker’s locale, independently of the language tag used to format or parse a value. Microsoft’s global support documentation covers these localization concerns.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More from the Wire

  1. World desk4 min
    How to Spot an AI Voice Scam Before Sending MoneyDon’t rely on how a caller sounds. Pause, call back through a known number, and verify the emergency with another trusted person before sending money.
  2. Mountain View desk4 min
    Google’s SynthID Detector: How to Check AI-Generated Images, Video and AudioGoogle’s SynthID Detector looks for an embedded watermark in supported images, video and audio. Here is what its results do—and do not—show.
  3. Redmond desk20 min
    How to create a link to File or Folder in Windows 11Windows 11 gives you several ways to point to a file or folder without moving or duplicating it. You can create a desktop shortcut,…
Recommended PC Tool
Recommended PC Tool
Crashes, No Sound, or Screen Glitches?Free driver scan
Windows Errors? Fix Them Before They SpreadFree repair scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.