Display thousands separators in numbers

Power Automate Desktop can handle numeric data as variables, but as numbers get more digits, they become harder to read at a glance.

This article explains how to display thousands separators in numbers.

Implement by copying and pasting

As an example, here’s a scenario that defines the elevation of Mount Fuji as numeric data and then creates a string with thousands separators added.

Copy the following code and paste it into the Power Automate Desktop flow designer to add the actions.

SET Elevation TO 3776
Text.FromNumber Number: Elevation DecimalPlaces: 0 UseThousandsSeparator: True FormattedNumber=> FormattedNumber
SET Result TO $'''The elevation of Mount Fuji is %FormattedNumber% m.'''

Implement in Power Automate Desktop

1. In “Search actions”, type “Convert number to text”.

2. Set the parameters as follows.

   Parameter	Value
   Number to convert	The target numeric data
   Decimal places	For example, “0” outputs “3,776” and “2” outputs “3,776.00”
   Use thousands separator	Turn on to use thousands separators (on by default)

3. When you run the flow, the numeric data is output as text with thousands separators. In this sample, the variable Result stores the string “The elevation of Mount Fuji is 3,776 m.”