Create Calendar Events in Different SharePoint Site Collection Using Flow
I have recently been asked to create a solution where different calendars in the departments feeds into one master calendar. It is fairly simple, but very useful especially the ability to create events in a completely different site collection. This is where Flow is great!
Normally, when we enter the site names all the lists get populated in the drop down list, but calendar (‘event’ type) lists are not yet included. I don’t know why! Initially, I thought of achieving this by calling Graph API, but it turned out to be easy!
All we need to do is click ‘Enter custom value‘ and type the name of the calendar list and we are sorted. Here is the trigger when an item is created in the calendar list on the root site.
Based on the trigger, an new item is created into a separate site collection where I have a master calendar. Note that we will need to ‘Enter custom value’.
Happy SharePointing!
5 Comments
cbbrown · October 23, 2017 at 14:26
This is great! Thanks so much.
Dimitri Hendriks · December 23, 2018 at 18:12
Take in mind that: When you use this, you can’t select a day event when making a new item. Then it will create a 2 day event when copying the item. Updates or deleting this item will also not change on the copied item.
Ximena Villaveces · April 8, 2019 at 17:01
How do you manage deletions or updates? whenever the item is updated int he calendar, it gets duplicated in Sharepoint.
SharePointer · April 9, 2019 at 21:35
This might be tricky, but you can try by keeping the ID of the item and trigger the flow on created/modified. Remember, now we have an Event web part which you could use to roll events from other calendars. This would eliminate the issue of delete/update.
Bob · August 2, 2019 at 23:55
Works great except that my calendar form has the ‘all day event’ which we use 95% of the time. We use this to schedule projects by days not meetings, etc. (for that we use Outlook). This doesn’t transfer over to the other calendar very well if checked. I get multiple calendar entries because it occurs for 24 hours which contains two dates (8PM-7:59PM the next day).