To calculate difference between today and date column in sharepoint list item

Like (0) Share

Report

Posted on 1 Apr 2024 13:45:21 by Ape Awakening

295

I want to trigger outlook mails, when the sharepoint list item's expiry date column is in next 30 days or 15 days (basically difference between today and expiry date).
Firstly I got the all items using Get Items action, and In apply to each , I'm using condition and expression I have set here is

div(sub(ticks(utcNow()),ticks(item()['ExpiryDate'])),864000000000).
The error what I'm getting is , Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language expression 'div(sub(ticks(utcNow()),ticks(item()['ExpiryDate'])),864000000000)' cannot be evaluated because property 'ExpiryDate' doesn't exist

Datediffexpiry.png

All responses (1)

Answers (0)

v-yetonggu-msft on 01 Apr 2024 at 14:04:14

Like (0)

Report
Re: To calculate difference between today and date column in sharepoint list item

Hi @apeawakening ,

Please check out your 'ExpiryDate' Column Internal Name.

For Example:

My Next_action_date Column：

When I changed its display name to 'ExpiryDate', its internal name was still 'Next_action_date'.

Here are the steps to view the internal name of a column:

When referencing the name of a column in an expression, reference the internal name of the column.

In addition to this, you have some problems writing expressions, please use items('Apply_to_each') instead of item() in the Apply to each loop.

Please try this expression:

div(sub(ticks(utcNow()),ticks(items('Apply_to_each')['InternalName'])),864000000000)

Best Regards,

Sunshine Gu