Trailing zeros from calculated currency column in a ShrePoint list

(0) Share

Report

Posted on by WillPage

2,339 Super User 2026 Season 1

Hello,

I have a calculated column in SharePoint, which is a currency with 2 decimal places. It displays OK in SharePoint but when I use it in a Flow as dynamic content in an email, it has a load of trailing zeros after the decimal point, 12 decimal places to be precise.

I'm only interested in displaying the two most significant of these.

I expect I need to initialise a variable then use an expression to set it, but I can't figure out what I need to do exactly.

Categories:

General topics

All responses (4)

Answers (1)

Sort by

v-zhos-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,@WillPage ,
Could you share more details of your flow?
Could show us the difference when the data display in sharepoint and in a Flow? Then I can make a test,
and help figure out a reasonable flow for you.
Best regards,
Zhongys
Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @WillPage,

Thanks for feedback.

The issue could be reproduced by me.

We could simply use a float function to convert a string version for a floating-point number to an actual floating point number.

According to your description, I have added a Calculated column named Total in SharePoint list which is a currency with 2 decimal places. Besides, I suggest round the number to two decimal places in the list first.

In the flow, use a float function likes below:

float(triggerBody()?['Total'])

Then in the email body, the calculated number is showed as what it is in the list.

A screenshot for your reference.

Best regards,

Mabel
Shuvam 4 on at

Like
a
(1)

Report
Copy link

Link copied!

how to use it with array variable ?
dasmotz 3 on at

Like
a
(0)

Report
Copy link

Link copied!

I second that, Shuvam.

I have been able to apply the ROUND function in the Sharepoint List Calculated value, but need to feed multiple entries into an array in Power Automate.