Have you noticed that when you have calculated fields 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?
Below you can see Compose 2 simply displaying the Difference field and the result will include all the 0s.
first(split(triggerBody()?['Difference'],'.'))
References
Table of Contents
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. You can contact me using contact@sharepains.com