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

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
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.

secondImage

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 (12,347)