Date string comparison: am I doing something wrong?

(1) Share

Report

Posted on by efialtes

350

Hi all

I have defined a flow triggering everytime a new item is stored on a sharepoint list.

The flow evaluates the content of the column "Fecha" (date) and sends an email with different Subject if it is greater (or not) than utcnow()-1. The body of te email includes the date obtained from the Sharepoint item.

Surprisingly, no matter I store a date from next year, or a date from last century, the condition evaluation resulta is the same

Please see attached screenshot with the flow and the two emails received

This kind of date comparisons used to work fine last May-June.

Suggestions are welcome

Thank you in advance!

All responses (2)

Answers (0)

telu Microsoft Employee on at

Like (0)

Report

Re: Date string comparison: am I doing something wrong?

Hi efialtes,

Could you just add the Fecha token(output) in the left, just like the left branch below instead of "triggerBody()?["Fecha"]", while in the right hand side, could you use adddays(utcnow(), -1)?

Thanks
efialtes 350 on at

Like (0)

Report

Re: Date string comparison: am I doing something wrong?

I modified slightly the expressions compared in the condition block, to make sure I am comparing the same date formats, but it still fails

Please see attached screenshot with the flow and the two emails received