Send email 5 days from SharePoint Calendar Event

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft on at

Like (0)

Report
Re: Send email 5 days from SharePoint Calendar Event

Hi @Anonymous,

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Send email 5 days from SharePoint Calendar Event

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.

Was this reply helpful? Yes No