Expression for date that includes Month, Date, and Year

[annabelh12345]

Hi Everyone,

I am currently building out a recurrence flow to scan my SharePoint List, and send an email when the End Date equals today's date. I have gotten this flow to work when I specify month and day, but when I incorporate year, the flow does not recognize the dates in my SharePoint list.

The flow will say it ran successful, but when I have a date in the SharePoint list that is today's date, it does not recognize it.

Here is the flow, and my current expression which works for Month and Day.

Functions I have tried that were unsuccessful:

• formatDateTime(utcNow( ),'YYYY-MM-dd')
• formatDateTime(utcNow( ),'MM-dd-YYYY')

Any help is appreciated!

[abm · Accepted solution]

Hi @annabelh12345 

Use the expression formatDateTime() for both end of the conditions (EndDate and UTCNow). Also try yyyy-MM-dd format.

[abm]

Also you can change the condition to Equals

[annabelh12345]

Thank you for the response! Could I ask for clarification on what you mean by using formatDateTime() for both ends of the condition? Possibly with an example.

I am fairly new to expressions.

[abm]

Hi @annabelh12345 

Thanks for your reply. Please see below

So left hand side map the SharePoint Date column with formatDate() expression and on right hand side UTCNow() with formatDateTime() expression. Hope it make sense.

Thanks

[annabelh12345]

Hi, this response solved my problem. I appreciate your help. yyyy-MM-dd fixed my problem.