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,474 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
YanisaSC 50 on at

Like (0)

Report

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
Hi @YanisaSC

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

Best Regards,
Dezhi

Was this reply helpful? Yes No