Answered

Send email every 14 days after Due Date in Power Automate – float() error

(0) Share

Report

Posted on by NK-07041026-0

Hi everyone,

I'm trying to build a Power Automate flow that sends a recurring reminder email every 14 days after the Due Date – so on day 14, 28, 42, etc. – as long as the status is still active (for example: "Open", "Reopen", or "Monitor").

This is the expression I'm currently using in my condition:

mod(float(split(dateDifference(formatDateTime(utcNow(),'yyyy-MM-dd'), formatDateTime(item()?['field_17'], 'yyyy-MM-dd')), '.')[0]), 14)

Although the email does get sent, I keep getting the following error in the flow run history: The template language function 'float' was invoked with a parameter that is not valid.
The value cannot be converted to the target type.

How can I safely rewrite this expression so that it:

Sends an email every 14 days after the due date

Doesn't throw errors if the field is empty or badly formatted

Works consistently and reliably?

Thanks in advance for your help!

Best regards,

Nuran

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report

After the For each block (not inside the loop, but outside the loop), add a Compose and throw any value in it e.g. ok
Configure the Run After property as shown below

Was this reply helpful? Yes No
Chriddle 8,441 Super User 2025 Season 2 on at

Like (1)

Report

If the difference between the two dates is less than one day, the return value of the dateDifference function will be different (there is no '.', hence the first item of the split is not convertable to float). To avoid errors, check this in advance.

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,073 on at

Like (1)

Report
Try to use this:
mod(int(first(split(dateDifference(formatDateTime(utcNow(),'yyyy-MM-dd'), formatDateTime(item()?['field_17'], 'yyyy-MM-dd')), '.'))), 14)

Was this reply helpful? Yes No