Flow - Format Number advanced tips and tricks
/I put together a video to celebrate the new update in Microsoft Flow (Power Automate) and Logic Apps - formatNumber()
The video explains 3 tips and 2 gotchas.
Tip 1: Use action in prod right now
Tip 2: Use ### and 000 patterns in formatNumber() expressions
Gotcha 2.1: May be don't use of $### - use $##0
Gotcha 2.2: May be don't use $ - use C or C2
Tip 3: Use formatNumber in collections with Select/Create HTML
If you want the clipboard paste of the Format Number action to use, use this.
{ "id": "c1fa8a84-e2c0-4be0-823e-3a45-1e6834aa", "brandColor": "#a098e6", "connectionReferences": {}, "icon": "https://psuxaustralia.azureedge.net/Content/Images/DesignerOperations/numberfunctions.png", "isTrigger": false, "operationName": "Format_number", "operationDefinition": { "type": "Expression", "kind": "FormatNumber", "inputs": { "number": 12345, "format": "C4" }, "runAfter": { "Compose": [ "Succeeded" ] } } }