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!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

efialtes 350 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
telu Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No