Unanswered

Flow to send emails 5 days before a calendar event automatically

(0) Share

Report

Posted on by OliverOK

Hi,

I am trying to set up a flow so that power automate will send an email automatically 30,10 and 5 days before an event in my outlook 365 calendar. I can set up 3 different flows for different time scales but I just can't figure out how to do it.

Right now I have:

When an upcoming event is starting soon (V3) -> Delay 5 days -> Send an email (V2)

But I am super confused by the delay... surely it is delaying sending an email until AFTER the event not sending one before. But somehow I have managed to get the flow to trigger with events on the same day.

I would appreciate any help! Thank you.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

Hi @OliverOK,

Have this flow run with an daily occurrance.

This flow action will take out all calender events 5 days from today.

Use this expression :

formatDateTime(adddays(utcnow(),5),'yyyy-MM-dd')

After you've added the expression, add 00:00:00 in start time and 23:59 in end time.

Then add a send an email, and send an mail to each recipient you want.

✔ Marking my post as a solution not only confirms that your question has been answered, but also helps others find solutions to similar problems.
By doing so, you'll be making a valuable contribution to the community.

Best Regards
Heartholme

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

To add to this, if you want to iterate through a set of dates, you can do the following:

Add a compose as step 1.

Put your calender action in an apply to each and use this expression in start time and stop time, to iterate through the set of days in advance.

formatDateTime(adddays(utcnow(),items('apply_to_each')),'yyyy-MM-dd')

Br

HH

Was this reply helpful? Yes No
OliverOK 5 on at

Like (0)

Report

Thankyou @Heartholme however I am super confused. When I try and enter what you type into get calendar view of events it gives me error messages. I cant even get the fx icon to appear.

Please can you treat me like a baby/idiot as I have literally been trying this all day... and no success.

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

@OliverOK

Sorry, I didn't know that you were completely new to PowerAutomate.

Click on the filed you want the expression, and click here to insert the acutal expression:

Paste the information in there to get the (FX) expression. Then write the 00:00:00 afterwards behind in the Start time/End time, as regular text.

Let me know how it goes!

Best Regards
Heartholme

Was this reply helpful? Yes No