How to remove decimal places from a power automate

(0) Share

Report

Posted on by Community Power Pla...

I have a calculated column used in getting the difference between Actual Qty received and Initial Qty delivered.

On SharePoint, the qty is showing without decimal point.

But displaying it on pdf file as output, I have almost 13 decimal places.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

shoog 2,164 on at

Like (1)

Report

You can wrap the input in an int() function to make sure it's an integer.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How to remove the decimal values from tile values in power automate directly using expression in dynamic content?

Was this reply helpful? Yes No
elkhawase2 45 on at

Like (0)

Report

how can we do that?

Was this reply helpful? Yes No
arunramanathan 25 on at

Like (0)

Report

use the output in the place mentioned below and use this fx to remove decimal , cause some time int() will need specific format and will give you error and also using format number will give you error due to data format. so use the float fx first then use formatNumber to remove decimal .
formatNumber(float(use the output here),'0')
if you want to make this number to integer then use below
int(formatNumber(float(use the output here),'0'))
hope this works.

Was this reply helpful? Yes No
arunramanathan 25 on at

Like (0)

Report

use the output in the place mentioned below and use this fx to remove decimal , cause some time int() will need specific format and will give you error and also using format number will give you error due to data format. so use the float fx first then use formatNumber to remove decimal .
formatNumber(float(use the output here),'0')
if you want to make this number to integer then use below
int(formatNumber(float(use the output here),'0'))
hope this works.

Was this reply helpful? Yes No
arunramanathan 25 on at

Like (0)

Report

use the output in the place mentioned below and use this fx to remove decimal , cause some time int() will need specific format and will give you error and also using format number will give you error due to data format. so use the float fx first then use formatNumber to remove decimal .
formatNumber(float(use the output here),'0')
if you want to make this number to integer then use below
int(formatNumber(float(use the output here),'0'))
hope this works.

Was this reply helpful? Yes No