Can't trigger a schedule email when matching dates as a condition

[James_Anderson]

I am attempting to create a scheduled flow that runs each day and checks against a list of our new starters and sends an email to them if their start date/first day is = today.

I am trying to use this expression in the condition but it is not matching the dates.

formatDateTime(utcNow(), 'yyyy-MM-dd')

What should the expression be to match the start date correctly?

[Sundeep_Malik]

Hey can you add the start date in a compose and show what output you are getting?

If not, you can just format both, like you can format the start date as well as today's date to a same format, so that they match. 

In start date also apply the same formula.

[Sundeep_Malik]

@James_Anderson 

Or the better approach can also be, 

In the get items, in the filter query, directly add the start date eq to utcNow, offcourse with the formatDateTime formula, 

Then you don't have to write the condition.

[James_Anderson]

The Start date using the Compose setting and sending myself an email is YYYY-MM-DD which is the same as the expression. 

[Sundeep_Malik]

@James_Anderson 

Did you try using the same in filter query of get items? Check if that is working or not.

[James_Anderson]

Can't say I have used that before, do you have a link to some documentation that shows how to use it/format it? 

I sent myself an email for ALL items in the loop and it is not returning anything after 2021, is there a max to the number of items a foreach can loop through? There is 345 total items to loop through and I only get 95 emails.

[v-bofeng-msft · Accepted solution]

Hi @James_Anderson ,

Please pay attention to the consistency of time, both startdate and utcNow are ISO8601-compliant datetime strings that contain time.

You could try(in the condition action)

startOfDay(StartDate) eq startOfDay(utcNow())

In addition, if this method doesn't work, consider the impact of the time zone

Best Regards,

Bof

[Sundeep_Malik]

@James_Anderson 

In filter query you write like this:

Start Date eq 'formatDateTime(utcNow(),'yyyy-MM-dd')' 

Or

Start_Date eq 

'formatDateTime(utcNow(),'yyyy-MM-dd')'

Add braces before and after the formatDateTime expression, currently travelling, on mobile expression option is not there.