Power Automate (WDL) function
formatNumber — Power Automate (WDL) function reference
Format a number as a string.
Syntax
wdl
formatNumber(number, format, [locale])
Examples
wdl
formatNumber(1234.5, 'C2', 'en-GB')
→ "£1,234.50"
wdl
formatNumber(variables('total'), 'N2')→ "1,234.50"
Locale changes the decimal/group separators.
wdl
formatNumber(item()?['Price'], '0.00', 'fr-FR')
→ "1234,50"
Common mistakes & gotchas
- format uses .NET numeric format strings ('C2', 'N0', '0.00'), not Excel-style number formats.
- Omitting locale uses the flow's default culture (usually en-US) — pass locale explicitly for anything customer-facing where the audience expects a different separator convention.
Related Workflow Definition Language functions
From Strings