Unanswered

Create event at 8am one day before another created event

(0) Share

Report

Posted on by Puktomi

Hello,

I'm new to Power Automate, but it seems like it might solve a problem for me: creating an event at 8am one day before another manually created event's start time

Requirements:

When user creates calendar event "A", then create event "B" one day before that starts at 8:00AM and ends at 10:00AM.

The problem with event "A", is that ideally, it's Start Time can be scheduled at anytime, so simply using

addDays(triggerBody()?['start'], -1) or addHours(triggerBody()?['start'], -'x') doesn't really help if the Start Time for "A" could be at any time on the start date. I can create event B on the right day, but not at the right time. It also won't be created at a consistent time, so neither Start or Created Times seems to help.

Is there another method I can use preset or specify a start time at 8:00AM (perhaps some variable?), and then use addDays() to change the date?

Hoping for some help or to be pointed in the right direction, as I'm struggling to be able to create an event at a specific date and time in relation to another event which was created. Appreciate any ideas ahead of time. Here is what I've got so far:

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

sudharsan1985 1,325 on at

Like (1)

Report
Hi @Puktomi
Can you please try to use the below condition to set the date and time
convertTimeZone(addDays(triggerBody()?['start'], -1),'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm')
Refer this post too https://powerusers.microsoft.com/t5/General-Power-Automate/Formatting-Date-And-time-in-MS-Flow/td-p/71597

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
Puktomi 18 on at

Like (0)

Report

Hello @sudharsan1985

Thanks for your time. While converting the timezone is necessary for this project and was not yet implemented, it does not resolve the issue I created this post for.

The goal is to have "Event B" created at 8am one day before "Event A" was created, regardless of the Start Time of "Event A". Please see the resulting screenshot to see the issue.
Whether the "Event A" was made with a Start Time of "8:00am" or "2:00pm", or any other time for that matter, I need "Event B" to start at 8:00AM. In the picture above, the date of the 12th, should have the Event "B minus one" to start at 8:00AM. Currently, it is starting exactly 24 hours before "Event A" was set to start.

Thanks!

Was this reply helpful? Yes No
Verified answer

sudharsan1985 1,325 on at

Like (1)

Report

Hi @Puktomi
I asked you to use the code to specify the datetime for the 'Event B'. By using the code with the timezones, you will be able to create an Event for B on 8 AM.

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
Verified answer

Puktomi 18 on at

Like (0)

Report
@sudharsan1985

Sorry, I did not understand that I could change the last 'HH:mm' to a value that I wanted. I was under the impression that I could only change the order of the format.

On my last reply, this is what I tried.
convertTimeZone(addDays(triggerBody()?['start'], -1),'UTC','Mountain Standard Time', 'MM/dd/yyyy HH:mm')

But now, this is what I tried, and it worked:
convertTimeZone(addDays(triggerBody()?['start'], -1),'UTC','Mountain Standard Time', 'MM/dd/yyyy 08:00')

Thanks for setting me straight.

Was this reply helpful? Yes No
HC1 2 on at

Like (0)

Report

hi guys, could you please also help me with a similar issue....

I use MS Bookings and once a client books a time with me, I want to be able to 'block' that entire day by creating an all day event. This will allow me to ensure my calendar gets blocked for the day.

When a client books a time it automatically books into my Outlook calendar. I do get an 'invite' but it's a "no response required"

I am struggling to extract the 'day' of the event from this invite.

In short, I want to be able to do the following flow...

- if meeting invite/confirmation subject is "client meeting", then
- extract/get day of that event
- and create a new all day event called "block" on the same extracted date

for example, if the meeting invite is for 15/09/2021 from 1pm - 3pm
I want it to automatically create an all day event called "block" on the same date that is 15/09/2021

could you please help?

thank you

Was this reply helpful? Yes No