0

We need a logic to add event to M365 users' personal calendar according to a company calendar (saved in SPO). We didn't have Power Automate plan so it is not an option.

Could we use SPD2013 workflow? Could we use PowerShell for SPO?

1 Answer 1

1

PowerShell might be a better choice since SharePoint Designer 2013 workflow needs a manual trigger or to be built on a specific object.

If the personal calendar is saved in a SharePoint list, here is a sample script you can use to add new events:

#Variables
$SiteURL = "<SiteURL>"
$CalendarName = "Calendar"
 
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)
 
#Add Event to Calendar
Add-PnPListItem -List $CalendarName -Values @{
    "Title" = "Team Meeting";
    "Description"= "Monthly Team Meeting";
    "Location"= "Ballroom";
    "EventDate" = [datetime]"11/04/2020 8AM";
    "EndDate"=[datetime]"11/04/2020 6PM";
}

Reference: SharePoint Online: Add Calendar Item using PowerShell.


UPDATE:

If the events are not in SharePoint list, then that is out of SharePoint’s scope. You will need to use Exchange Online PowerShell instead.

Please see the reference here: Use mail flow rules to automatically add meetings to calendars in Exchange Online.

2
  • "Personal calendar" means the calendar for each user's outlook online calendar. Is it possible?
    – Mark L
    Commented Nov 4, 2020 at 8:06
  • @MarkL Please see the updated answer. Commented Nov 4, 2020 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.