Microsoft Flow – Handling calculated fields in Microsoft Flow

Have you noticed that when you have a calculated field that for example displays the difference between two date fields in SharePoint and Microsoft Flow you will get a number like 13.00000000000 returned:

 

This is not always what you want, is it?

There is an easy way to clean this up:

 

Below you can see Compose 2 simply displaying the Difference field and the result will include all the 0s.

The second Compose action uses the following expression.
~~~~
first(split(triggerBody()?[‘Difference’],’.’))
~~~~
Advertisements

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.