Creating a starting event that then creates events around it - Outlook

[cdocherty28]

Hi, I need help as I've never used PowerFlow before and was wondering if something like this was possible;

Create initial 'event' in the calendar in Outlook

Then from that, other events that are 1 week before, 2 weeks before, 1 week after, etc are immediately created and are 'linked' to the initial event

And if possible, if the initial event date were to change, it would adjust the surrounding events dates automatically

[v-yujincui-msft]

Hi @cdocherty28 ,

Do you want to create schedule/recurring events in outlook?

I have made a test for your reference.

https://docs.microsoft.com/en-us/connectors/office365/#create-event-(v4)

1. Here is my sharepoint list.

2. Here is my flow.

addHours(triggerOutputs()?['body/StartTime'],8,'yyyy-MM-ddTHH:mm:ss')

addHours(triggerOutputs()?['body/EndTime'],8,'yyyy-MM-ddTHH:mm:ss')

Result Screenshots:

 In addition, you could edit all events in the series.

Best Regards,

Charlie Choi

[cdocherty28]

Thank you for your reply. Unfortunately, this is not quite what I'm looking for. To be more specific this is what I needed;

-12 weeks before = event 1

-6 weeks before = event 2

-2 weeks before = event 3

-1 week before = event 4

0 = Initial event created 5

+2 weeks after = event 6

+ 6 weeks after = event 7

+ 24 weeks after = event 8

A series of events to be created at specific week points around the initial event, if that makes sense? Each event is different and will have a different title

[v-yujincui-msft · Accepted solution]

Hi @cdocherty28 ,

You could try to create two Flows to achieve your needs, the first Flow is for creating events and the second Flow is for modifying events. I have selected three events to test as your reference.

In addition, I modified my list to add some columns that store the IDs of created events.

Flow1:

addHours(triggerOutputs()?['body/StartTime'],8,'yyyy-MM-ddTHH:mm:ss')
addHours(triggerOutputs()?['body/EndTime'],8,'yyyy-MM-ddTHH:mm:ss')
addDays(addHours(triggerOutputs()?['body/StartTime'],8,'yyyy-MM-ddTHH:mm:ss'),-7)
addDays(addHours(triggerOutputs()?['body/EndTime'],8,'yyyy-MM-ddTHH:mm:ss'),-7)
addDays(addHours(triggerOutputs()?['body/StartTime'],8,'yyyy-MM-ddTHH:mm:ss'),14)
addDays(addHours(triggerOutputs()?['body/EndTime'],8,'yyyy-MM-ddTHH:mm:ss'),14)

Flow2:

@not(equals(triggerOutputs()?['body/Created'], triggerOutputs()?['body/Modified']))

Result Screenshots:

Best Regards,

Charlie Choi