cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cdocherty28
New Member

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1646963904481.png

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)
vyujincuimsft_1-1646964074174.png
vyujincuimsft_2-1646964149649.pngvyujincuimsft_3-1646964609636.pngvyujincuimsft_4-1646964755364.pngvyujincuimsft_5-1646964797221.png

Flow2:

 

 

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

 

vyujincuimsft_6-1646965131494.pngvyujincuimsft_7-1646965337833.png

 

Result Screenshots:

vyujincuimsft_8-1646965580241.pngvyujincuimsft_10-1646965697747.png
vyujincuimsft_9-1646965675831.png

 

Best Regards,

Charlie Choi

View solution in original post

3 REPLIES 3
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_2-1646898070014.png

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')
vyujincuimsft_3-1646899113647.png

Result Screenshots:

vyujincuimsft_5-1646899282736.png
vyujincuimsft_4-1646899268435.png

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

vyujincuimsft_6-1646899381533.png

 

 

Best Regards,

Charlie Choi

cdocherty28
New Member

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
Community Support
Community Support

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.

vyujincuimsft_0-1646963904481.png

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)
vyujincuimsft_1-1646964074174.png
vyujincuimsft_2-1646964149649.pngvyujincuimsft_3-1646964609636.pngvyujincuimsft_4-1646964755364.pngvyujincuimsft_5-1646964797221.png

Flow2:

 

 

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

 

vyujincuimsft_6-1646965131494.pngvyujincuimsft_7-1646965337833.png

 

Result Screenshots:

vyujincuimsft_8-1646965580241.pngvyujincuimsft_10-1646965697747.png
vyujincuimsft_9-1646965675831.png

 

Best Regards,

Charlie Choi

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,339)