Unanswered

Numbers showing with 10 decimal places

(0) Share

Report

Posted on by simonsnell

Hi,

I'm passing float values through from Dynamics to an Email record. They should be coming through with 2 decimal places (that is what the decimal is set to in the field in Dynamics), but they are coming through with 10 decimal places.

I've tried setting a number format for one of the values but it is still coming through with 10dps. Short of converting them to strings

I'm stumped!

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

Ellis Karim 12,336 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @simonsnell ,

Your format number function appear to be correct. You need to use the output of the format number function in your table or email:

Here is another example. The second format number function below, C2, was entered as a custom value value, but both are exactly the same:

See Reference guide for expression functions - Azure Logic Apps | Microsoft Docs | formatNumber

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
simonsnell 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your suggestion. Here is what I tried, and here is the result:-
Here is the result from the flow:-
Unfortunately although I'm passing the value from the formatted number, it still appears with all the zeros.

I suspect that the issue is that when it is passed to our email template system (ClickDimensions), it is the raw data without the formatting, so the zeros get added automatically.

Any further ideas?
Ellis Karim 12,336 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Can you try one of the default formats:

We can also use an expression to convert the number format:

formatNumber(variables('TotalVouchers'),'C2', 'en-GB')

Does the above fix the issue?

Ellis
simonsnell 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
Thanks. I think the fundamental issue was that I was passing these through a "decimal" field, rather than a string. I'm trying it now with a string field.
This works with the Currency (C2) format as suggested.
Thank you