Unanswered

Getting events from Group Calendar

(0) Share

Report

Posted on by ChadVKealey

1,393

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.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

Mari on at

Like (0)

Report

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

Was this reply helpful? Yes No
ChadVKealey 1,393 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bigshow 60 on at

Like (0)

Report

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

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

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

Was this reply helpful? Yes No
mercobenitas 14 on at

Like (2)

Report
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.

Was this reply helpful? Yes No
ChadVKealey 1,393 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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=contains(subject%20,%20'PTO')%20and%20start/dateTime%20ge%20'2023-01-31T18:08:35.0648948Z'&$orderby=start/dateTime%20asc&$top=100",
................
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.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report

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

Was this reply helpful? Yes No
venus_knight 2 on at

Like (0)

Report

Can you specify the Schema for the Parse JSON?

Was this reply helpful? Yes No
cdat 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No