cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
derk
Helper I
Helper I

Calculated SharePoint field in Flow email showing extra 0's

Hello,

 

 I have a calculated field in a SharePoint list that calculates the days between two dates. I added this field into a flow email, but it adds 0's to the number like this. How would I go about removing the decimal place and the 0's? I changed it to a number field and chose 0 decimal places with no such luck.

 

I found this post, but not sure I understand how to accomplish this - https://powerusers.microsoft.com/t5/Using-Flows/sharepoint-caculated-columns-showing-13-decimal-plac...

 

Here is my formula

 

=IF(ISERROR(DATEDIF([From Date],[To Date],"d")),"",(DATEDIF([From Date],[To Date],"d"))+1-INT(DATEDIF([From Date],[To Date],"d")/7)*2-IF((WEEKDAY([To Date])-WEEKDAY([From Date]))<0,2,0)-IF(OR(AND(WEEKDAY([To Date])=7,WEEKDAY([From Date])=7),AND(WEEKDAY([To Date])=1,WEEKDAY([From Date])=1)),1,0)-IF(AND(WEEKDAY([From Date])=1,(WEEKDAY([To Date])-WEEKDAY([From Date]))>0),1,0)-IF(AND(NOT(WEEKDAY([From Date])=7),WEEKDAY([To Date])=7),1,0))

 

Total Days:3.00000000000000

 

Thanks,

 

Derek

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @derk,

 

Why don't you use this:

 

first(split(triggerBody()?['Difference'],'.'))
 
In my case Difference is the calculated field.
 
 

View solution in original post

12 REPLIES 12

Hi @derk,

 

Why don't you use this:

 

first(split(triggerBody()?['Difference'],'.'))
 
In my case Difference is the calculated field.
 
 
derk
Helper I
Helper I

Hi @Pieter_Veenstra

 

I tried to put this in and it's telling me invalid expression.

 

first(split(triggerBody()?[‘Total Days’],’.’))

Hi @derk,

 

Can you make sure that you have the correct quotes? you should only have ' and no `

Hi @derk,

 

Can you make sure that you have the correct quotes? you should only have ' and no ` 

 

I would type first(split( in the express window. Then switch to the Dynamic contents tab and click on the calculated column. That will ensure that you have the right quotes.

 

okay, so that let me save the expression.  I tested and it still shows the .0000 in the email. I kept total days in the details of the email. Do I need to select something different?

Can you submit a screenshot of both the run history and the flow in edit mode?

I figured it out. I had to add the expression to the details email instead of the Total Days field.  Thank you for your help!

 

msflow.png

I would probably reference the output from Compose 2 in your email. That way you separate the complicated stuff from the doing stuff.

@Pieter_Veenstra  how would I do that?

 

Click in you email body text that you have at the moment so that the cursor is in the place where you want the output from the compose to appear.

 

Then go to the dynamic content tab and add the output from the compose action ( you migth have to click on the show more link) 

that was it. I didn't click on see more. Thanks. 

hs_drk
Regular Visitor

Hello everybody! 

 

This is quite the same problem i'm facing today. 


I've tried the suggested solution by @Pieter_Veenstra , but ended up with this result: 

 

example1.png

Screenshot from my flow:

example2.png

 

 The expression which was used: 

 

 

first(split(triggerBody()?['Gesamtbetrag'],'.'))

 

 

 

 


I'm really looking forwar for help! Thanks!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,264)