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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to trigger email b...
Power Automate
Unanswered

How to trigger email based on subject date and time (4 minutes before the event)

(0) ShareShare
ReportReport
Posted on by 292

Hello All,

 

I have onedrive excel wherein I have subject , start date and time of the meeting.

I would like to trigger email 4 mins before the meeting starts.

 

Please advice how to create flowevent date.png

Categories:
I have the same question (0)
  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @nagaraj007 

     

    Could you have a daily flow that collects all meetings with todays date and then run a for each on the dates/times with an add to time of -4 minutes to the time input and delay until the "add to time variable" before sending your email?

     

    DamoBird365_0-1613474713036.png

     

  • nagaraj007 Profile Picture
    292 on at

    Hello @DamoBird365 ,

    I just want flow to send reminder email to my Boss before the 4 minutes of meeting starts, so that he can go to the meeting right away. 

    I would be fine if the flow runs daily once for the that day's meeting. 

    Please advise about the flow so that i can incorporate the same

  • nagaraj007 Profile Picture
    292 on at

    Every day morning at 9 AM as meeting invite...so that they get a pop up message

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    The above flow example would be a component of the proposed solution.

     

    The full flow would be:

     

    It's a scheduled trigger - daily at 8am?

    Get rows from table in excel where start date is equal to today

    Apply to each of the meetings in the above result set 

         Add to Time -4

         Delay until the time calculated above

         Send Email or Flow Bot Message / Message in Teams Channel

    Flow Ends

  • nagaraj007 Profile Picture
    292 on at

    Hi @DamoBird365 ,

     

    I tried to add the flow as per your instructions, but i am getting some error. Please advise.

     

    Attachment 1: Flow 

    Attachment 2: Errorerror.pngflow.png

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    You might have to explore saving your date in Excel differently - see the following

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard