Countdown Timer from Date Column

[pure96]

Hello!

I have a flow that produces a 30 day reminder email based on a calculated column in a MS List. In that email it says "...this item will be past due in 30 days". I want to know if there is a way to pull the date from the renewal date column on the list (last day before the item needs to be renewed) and subtract the current day and put that in the email so it will be like a countdown timer.

For example if the renewal date is 07/31/22 and today's date is 07/14/22, the email should automatically say "...this item will be past due in 17 days" and keep going down until it reaches 07/31/22.

Thank you!

[v-qiaqi-msft · Accepted solution]

Hi @pure96,

Do you want to create a recurrence flow to remind everyday until the due date?

Could you please tell me more about your scneairo?

Here is a simple demo, please check as below.

formatDateTime(items('Apply_to_each')?['RenewalDate'],'yyyy-MM-dd')

formatDateTime(utcNow(),'yyyy-MM-dd')

div(sub(ticks(formatDateTime(items('Apply_to_each')?['RenewalDate'],'yyyy-MM-dd')),ticks(formatDateTime(utcNow(),'yyyy-MM-dd'))),864000000000)

You should make sure the the renewal date is greater than utcnow() and the date difference should be in 20 days, if it is, you should directly reference to the date difference from the div() function.

[pure96]

This worked! Thank you!