Answered

Getting rid of zeros after the decimal

(0) Share

Report

Posted on by alopez222

160

I have a field, Days Change_Ship, that performs a calculation as you can see below. I use the calculation to display it on an email. The issue is that on the list it display as an integer, as you see below, but when I display it on an email it comes out with multiple zeros after the decimal. How can I remove all the zeros so that its only an integer?

Days Change_Ship Formula:

Days Change_Ship on List:

Email:

I have the same question (2)

All responses (4)

Answers (1)

Verified answer

Barret 652 Most Valuable Professional on at

Like (1)

Report

Re: Getting rid of zeros after the decimal

There is a Format Number action in Power Automate that you can use, then reference the output of that action in your email action. See Here.

You can also format the number inline in a few other ways. This guide has a number of different examples.

Was this reply helpful? Yes No
alopez222 160 on at

Like (0)

Report

Re: Getting rid of zeros after the decimal

I used the Format Number action as seen in the picture below. After testing it, I got an error, seen below, saying that I entered the wrong data type. I entered a string when I should have entered an integer or decimal. When I go to the field settings to see what the data type is, I see that it is a number data type. Unless I'm not understanding something, I don't see what I am doing wrong.

Error:

Field Data Type:

Format Number Action:

Was this reply helpful? Yes No
Barret 652 Most Valuable Professional on at

Like (0)

Report

Re: Getting rid of zeros after the decimal

Can you look at the output data from an example run from your action that is returning the data to your flow? Look at the raw JSON data that is in the response and an example of the Days_Change_Ship that is being returned. Ensure that the data isn't surrounded by quotation marks in the output. Just because your field is defined as a number doesn't necessarily mean it is being returned to your flow as a number in the JSON reponse.

Was this reply helpful? Yes No
alopez222 160 on at

Like (0)

Report

Re: Getting rid of zeros after the decimal

I didn't realize I was testing it wrong. I got the correct output but it wasn't the one I was expecting. My input was wrong.

Was this reply helpful? Yes No