Power Platform Community Forum Thread Details

Hi Everyone,

The flow does what it needs to do, send email notification if the days remaining is between 30 and 0. On the image below we see that Days Remaining = 0. But the flow still fails for 87 items in the Apply to each loop.

Days Remaining =

div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks(items('Apply_to_each')?['New_x0020_Review_x0020_Date'])),864000000000)
 
^
|
 
Which it calculates days remains between two dates, utcNow() and New Review Date.
 
 
Error message: Unable to process template language expressions in action 'Set_variable:_Days_Remaining' 
inputs at line '0' and column '0': 'The template language function 'ticks' expects its parameter to be a string that represents a timestamp. 
The provided value is of type 'Null'. 
 
As mentioned, the flow does the job, but I am not sure why is failing.