Send email 5 days from SharePoint Calendar Event

[SylvieLet17]

Hi all, 

I'm trying to create a flow to send an email if an event exists 5 days from today. 

I have a recurring scheduled flow that checks a SharePoint Calendar and there's a For Each with condition as follows:

@equals(formatDateTime(item()?['EventDate'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 5), 'MM/dd/yyyy')) 

EventDate is the name of the "Start Date" field for the calendar. The flow runs successfully, but it always returns False. I have tried to change the parameters to: 1 day, 4 days, etc. but it still runs false no matter what. 

Any advice?

Thanks!

[v-yamao-msft · Accepted solution]

Hi @SylvieLet17,

How is your flow created? Are you trying to get all the events first then filter out an event that exists 5 days from today?

I assume that you need to add an Apply to each and format the Start date of all the items.

Please check the following flow configuration for a reference.

Action Get items is used to get all the items form the Calendar, under Apply to each, add a Condition with the following code:

@equals(formatDateTime(items('Apply_to_each')?['EventDate'], 'MM/dd/yyyy'),formatDateTime(adddays(utcnow(),5),'MM/dd/yyyy'))

It works fine, items that will exist 5 days from today will be filtered out. Images for your reference:

Best regards,

Mabel Mao

[SylvieLet17]

THis seems to be working thank you Mabel!

It didn't seem to run this morning, but I changed the days to 2, then back to 5 and it is running again. 

I'll monitor.