cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Date string comparison: am I doing something wrong?

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

date_comparison.png

 

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

Suggestions are welcome

Thank you in advance!

2 REPLIES 2
Highlighted
Kudo Kingpin
Kudo Kingpin

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

 

date_comparison_2.png

Highlighted
Microsoft
Microsoft

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (13,720)