Getting events from Group Calendar

[ChadVKealey]

I want to create a flow that will send an email once a week with a list of upcoming events from the calendar associated with a M365 Group. There is no action in the Office 365 Groups connector to get calendar events from a group calendar. I tried using that actions in the Office 365 Outlook connector ("Get events (v4)" and "Get calendar view of events"), but Group calendars don't show up in the drop-down of my calendars. 

I suspect that I could give one the O365 Outlook actions the ID (guid) of the Group calendar, it would work. However, there doesn't seem to be a way to get that. I've tried getting the group's properties (via Power Automate and Graph Explorer), but none of the methods has produced that calendar ID as an output.

[Mari]

Hi! Have you tested this already: List calendars - Microsoft Graph v1.0 | Microsoft Docs?

[ChadVKealey]

I didn't try that specifically, but I did use the Graph Explorer to "get all my calendars" (from the Outlook section) and it only returned those that listed under "My calendars" in Outlook (that is, my personal calendars and Planner calendars that I've "added to" my personal calendar), none of the calendars for any of my Groups/Teams show up.

[Bigshow]

Hi all

Has anyone found a solution to this? i too also want to be able to get group events and send them on an email on a regular basis

[VictorIvanidze]

Hi @Bigshow, have a look at https://powerusers.microsoft.com/t5/General-Power-Automate/Easiuest-way-to-get-calendar-id-for-the-O... 

[mercobenitas]

I have it working; see below my flow.

Step 1. Go to https://developer.microsoft.com/en-us/graph/graph-explorer and sign in with your credentials

Step 2. Go to Section Groups

Step 3. Go to "all groups I belong to (direct or indirect membership) with count" and 'Run query'. Then find the 'id' of the group with the SharePoint Group calendar, and copy or write this down.

Step 4. Go to "group's events", use the id you just wrote down, then 'Run query'. In theory, you should see your group calendar events returned.

Next, go to Power Automate and create a 'scheduled cloud flow'. The trick is to work with Action "Send an HTTP request" and use the URL from the Graph Explorer (in my example below I filter on all events with 'PTO' in the subject):

https://graph.microsoft.com/v1.0/groups/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/events?$filter=contains(subject , 'PTO') and start/dateTime ge '@{utcNow()}'&$orderby=start/dateTime asc&$top=100

My flow (I'm sure others can make it more efficient and look better, but it works for me)

Let me know if you have questions.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[ChadVKealey]

Thanks! I'll have to give that a shot.

[Anonymous]

Ok, I have the group ID, but I can not get past HTTP request.   

Under OUTPUTS I see 

{

  "error": {

    "code": 400,

    "message": "URI path is not a valid Graph endpoint, path is neither absolute nor relative or resource/object is not supported for this connector. Resources: me,users Objects: messages,mailFolders,events,calendar,calendars,outlook,inferenceClassification. Uri: https://graph.microsoft.com/v1.0/groups/0z00000z-0000-00zz-0zz0-0z000z00z0zz/events/?$filter=contain...",

    ................

I see we can use spaces instead of %20, yes? 

Does the group ID need {curly brackets} or quote marks, or just typed in as shown?   Number typed in here is fake for security reasons

Could be a permission issue? or would that be a 500 error instead of 400?  I am running from inside the teams environment on the team with the calendar so that should be ok. 

[VictorIvanidze]

It looks like you are using wrong "Send an HTTP request" action. It should be the one from "Office 365 Groups" connector.

[venus_knight]

Can you specify the Schema for the Parse JSON? 

[cdat]

mercobenitas, can you post the schema for the JSON parse? Thanks.

[MelArlo]

{
    "type": "object",
    "properties": {
        "value": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "id": {
                        "type": "string"
                    },
                    "createdDateTime": {
                        "type": "string"
                    },
                    "lastModifiedDateTime": {
                        "type": "string"
                    },
                    "changeKey": {
                        "type": "string"
                    },
                    "originalStartTimeZone": {
                        "type": "string"
                    },
                    "originalEndTimeZone": {
                        "type": "string"
                    },
                    "iCalUId": {
                        "type": "string"
                    },
                    "reminderMinutesBeforeStart": {
                        "type": "integer"
                    },
                    "isReminderOn": {
                        "type": "boolean"
                    },
                    "hasAttachments": {
                        "type": "boolean"
                    },
                    "subject": {
                        "type": "string"
                    },
                    "bodyPreview": {
                        "type": "string"
                    },
                    "importance": {
                        "type": "string"
                    },
                    "sensitivity": {
                        "type": "string"
                    },
                    "isAllDay": {
                        "type": "boolean"
                    },
                    "isCancelled": {
                        "type": "boolean"
                    },
                    "isOrganizer": {
                        "type": "boolean"
                    },
                    "responseRequested": {
                        "type": "boolean"
                    },
                    "showAs": {
                        "type": "string"
                    },
                    "type": {
                        "type": "string"
                    },
                    "webLink": {
                        "type": "string"
                    },
                    "responseStatus": {
                        "type": "object",
                        "properties": {
                            "response": {
                                "type": "string"
                            },
                            "time": {
                                "type": "string"
                            }
                        }
                    },
                    "body": {
                        "type": "object",
                        "properties": {
                            "contentType": {
                                "type": "string"
                            },
                            "content": {
                                "type": "string"
                            }
                        }
                    },
                    "start": {
                        "type": "object",
                        "properties": {
                            "dateTime": {
                                "type": "string"
                            },
                            "timeZone": {
                                "type": "string"
                            }
                        }
                    },
                    "end": {
                        "type": "object",
                        "properties": {
                            "dateTime": {
                                "type": "string"
                            },
                            "timeZone": {
                                "type": "string"
                            }
                        }
                    },
                    "location": {
                        "type": "object",
                        "properties": {
                            "displayName": {
                                "type": "string"
                            }
                        }
                    },
                    "recurrence": {
                        "type": "object",
                        "properties": {
                            "pattern": {
                                "type": "object",
                                "properties": {
                                    "type": {
                                        "type": "string"
                                    },
                                    "interval": {
                                        "type": "integer"
                                    },
                                    "month": {
                                        "type": "integer"
                                    },
                                    "dayOfMonth": {
                                        "type": "integer"
                                    },
                                    "daysOfWeek": {
                                        "type": "array",
                                        "items": {
                                            "type": "string"
                                        }
                                    },
                                    "firstDayOfWeek": {
                                        "type": "string"
                                    },
                                    "index": {
                                        "type": "string"
                                    }
                                }
                            },
                            "range": {
                                "type": "object",
                                "properties": {
                                    "type": {
                                        "type": "string"
                                    },
                                    "startDate": {
                                        "type": "string"
                                    },
                                    "endDate": {
                                        "type": "string"
                                    },
                                    "recurrenceTimeZone": {
                                        "type": "string"
                                    },
                                    "numberOfOccurrences": {
                                        "type": "integer"
                                    }
                                }
                            }
                        }
                    },
                    "attendees": {
                        "type": "array",
                        "items": {
                            "type": "object",
                            "properties": {
                                "type": {
                                    "type": "string"
                                },
                                "status": {
                                    "type": "object",
                                    "properties": {
                                        "response": {
                                            "type": "string"
                                        },
                                        "time": {
                                            "type": "string"
                                        }
                                    }
                                },
                                "emailAddress": {
                                    "type": "object",
                                    "properties": {
                                        "name": {
                                            "type": "string"
                                        },
                                        "address": {
                                            "type": "string"
                                        }
                                    }
                                }
                            },
                            "required": [
                                "type",
                                "status",
                                "emailAddress"
                            ]
                        }
                    },
                    "organizer": {
                        "type": "object",
                        "properties": {
                            "emailAddress": {
                                "type": "object",
                                "properties": {
                                    "name": {
                                        "type": "string"
                                    },
                                    "address": {
                                        "type": "string"
                                    }
                                }
                            }
                        }
                    }
                },
                "required": [
                    "id",
                    "createdDateTime",
                    "lastModifiedDateTime",
                    "changeKey",
                    "originalStartTimeZone",
                    "originalEndTimeZone",
                    "iCalUId",
                    "reminderMinutesBeforeStart",
                    "isReminderOn",
                    "hasAttachments",
                    "subject",
                    "bodyPreview",
                    "importance",
                    "sensitivity",
                    "isAllDay",
                    "isCancelled",
                    "isOrganizer",
                    "responseRequested",
                    "showAs",
                    "type",
                    "webLink",
                    "responseStatus",
                    "body",
                    "start",
                    "end",
                    "location",
                    "recurrence",
                    "attendees",
                    "organizer"
                ]
            }
        }
    }
}

[z3019494]

After quickly reading through @mercobenitas ' post, and digging into the Graph Explorer myself, it seems that unlike a calendar that is part of a user's mailbox, a Group Calendar doesn't have another Calendar ID that is separate to its existing Group ID (as there can be multiple calendars per user, but only one calendar per Group)

Bonus "discovery"/hypothesis about Channel Calendars in Teams

The Teams Channel Calendar implementation seems to be quite odd as well. There doesn't seem to be any property that indicates how Teams filters out non-Channel meetings. The only thing I can find in a joinUrl property which contains the Channel ID (e.g. 

19%3a292d8916972740f595f07915f6a65483%40thread.tacv2

If you created an event (i.e. non-Teams meeting) in the Group Calendar using Outlook or Power Automate, the joinUrl property obviously wouldn't exist as it's not an online meeting. My suspicion is that the Channel Calendar somehow reads this joinUrl property, and where the Channel ID corresponds to the current channel's ID, then it'll show it; otherwise it'll not display the meeting.

            "onlineMeeting": {
                "joinUrl": "https://teams.microsoft.com/l/meetup-join/19%3afed07587e72c45a78a5f973645f460a4%40thread.tacv2/1696660038405?context=%7b%22Tid%22%3a%2205a0e69a-418a-47c1-9c25-9387261bf991%22%2c%22Oid%22%3a%22c468cfa5-d677-4cc8-a4db-b414b3c95b2b%22%7d",
                "conferenceId": "90107459",
                "tollNumber": "+61 2 8318 0088"
            },

Which then explains why it's impossible to create a non-meeting event in a Channel Calendar: it expects the joinUrl property and where an event doesn't contain that property, or the Channel ID buried in that joinUrl isn't the same as the current Channel ID, it'll just ignore the event.

[Farshad1]

@mercobenitas The question is that when I used this flow, why I got the following error in Apply_to_each loop?

Error: ExpressionEvaluationFailed The execution of template action 'Apply_to_each_1' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['value']' is of type 'Null'. The result must be a valid array.
Actually, at the beginning of the loop it will be stopped because of this error!