This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Looking for solution in Power Automate
Difference of hours between created date from SharePoint list item and UTCNow
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
--please don't forget to upvote and Accept as answer if the reply is helpful--
@Pradeep Nemadi :
To calculate a difference between two dates / times in Power Automate, you must combine multiple expressions. Calculate the number of ticks for each date, and then divide it by a number to get the desired unit. Start from 100 nanoseconds (1 tick) and divide it by a number big enough to get the days/hours/minutes.
For example, to get the number of hours between yesterday and today:
div(sub(ticks(utcNow()),ticks(addDays(utcNow(),-1))),36000000000)
wont work for created date of SharePoint list item
What is the format for created date of SharePoint list item?
If it is in a different format than the one expected in the Expression tab of power automate then you will need to transform the date to the desired format and perform the operation mentioned above.
u can use default format of SharePoint list item created date of modified date as one date another date as UTC now.
but don't use UTCnow for both date