Is there any possibility for adding thousand separator inside an Azure Logic App Expression?

Question

I'm creating an Azure Logic App which sends an JSON to an REST Service. The JSON is build inside the Logic App with a Compose. The Data for the JSON comes from different REST Services.

The Services deliver me numbers like "13251", "11231543.3" etc.

I need to transform and send the numbers with thousand separator like "13.251", "11,231,543.3" etc.

My code looks like:

{
  "Item": {
    "nr": "@{body('current')?['nr']}",
    "amount": "@{body('current')?['amount']}",
  }
}

So I basically need something like: .ToString("#,##0.00")

"13251" => "13.251"

"11231543.3" => "11,231,543.3"

Thanks for your help!

rickvdbosch rickvdbosch · Accepted Answer · 2019-10-29T13:23:57

You cannot send numbers with thousand separators in Json, since it will invalidate the Json.

Consider this Json:

{
    "age": 123,456.0
}

This will be seen as:

{
    "age": 123,
    456.0
}

Which is invalid Json.

If you wish to format it as a string: there doesn't seem to be a conversion available to format numbers. There are several format-enabled conversions for DateTime.

More info: Reference guide to using functions in expressions for Azure Logic Apps and Microsoft Flow

Is there any possibility for adding thousand separator inside an Azure Logic App Expression?

3 Answers