web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Send email 5 days from...
Power Automate - Building Flows
Answered

Send email 5 days from SharePoint Calendar Event

(0) ShareShare
ReportReport
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!

I have the same question (0)
  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    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:

    1.PNG2.PNG

     

     

    Best regards,

    Mabel Mao

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans