Remove zeros from email

(0) Share

Report

Posted on by EBMRay

1,712

Hello everyone !

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula:

=DATEDIF([Column 1],[Column 2],"D")

But when i trigger the calculated column in a flow and show the days calculated in an email it look likes for example:

In the list it shows the number without zeros:

So what i should use in the formula or in flow to remove all the zeros ? Any help would be appreciated.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Pstork1 69,581 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried putting an INT() function around the rest of the calculation?

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pstork1,
Nope, i am not using the integer function i am implementing this one:
=DATEDIF(StartDate,EndDate,"yd")
If i should use INT() what it would be the function ?

Thanks

Was this reply helpful? Yes No
Pstork1 69,581 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
As I said, put the INT() around the result like this.

=INT(DATEDIF(StartDate,EndDate,"yd"))

The DateDif is generating something that is being interpreted as a whole number. Putting that inside an Int() should get it interpreted as an integer instead.

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1
I have used the formula you mentioned but it keeps showing the zeros in the email.
I am not using this formula in the flow, i am using it in the column list.
So i am only calling the Duration column from the dynamic content in the send email action.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,581 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Sorry, I forgot this was the formula in a calculated column. What I should have said is put an Int() around the calculated column in the Flow when you insert it into the email. I did a test and my column was called 'Caculated2'.

int(body('Get_item')?['Calculated2'])

The column is already set to be a number, but when you put it into the email you need to specify that you want an integer.

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1
I am not using the Get_items action, i am using when an item is created so what it should be my expression ?

Was this reply helpful? Yes No
Pstork1 69,581 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hover over the field that you put into the email in the past. That should show you what the code is in your flow. Just use that and put it inside an Int().

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! It works.

Was this reply helpful? Yes No