Showing results for 
Search instead for 
Did you mean: 
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



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

Suggestions are welcome

Thank you in advance!

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




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)?



Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (8,791)