Calculate the number between Two Dates (Day in Sharpoint List and Today) to send email (for incomplete status) .

(0) Share

Report

Posted on by YanisaSC

I want to create a flow that will send me an email how many days are left in the Incomplete task (remaining days). I entered the command exactly as it is shown in the image, but the Action 'Condition' failed. How do I correct this?

Action 'Condition' failed:

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

Flow :

Output that i want :

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

No need to use FormatDateTime. Use utcnow() as is.

Was this reply helpful? Yes No
YanisaSC 50 on at

Like (0)

Report
Copy link

Link copied!

thank you for helped me.

I have changed the command to just utcnow() but it gives error like in the picture.

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @YanisaSC

Please try:
int(split(dateDifference(outputs('Get_item')?['body/Day'],utcNow()),'.')[0])

Best Regards,
Dezhi

Was this reply helpful? Yes No