Creating/Updating 365 group event

[DonLimpio]

Hi, I'm trying to update/create events in a SharePoint/365 Group calendar with Power Automate when a SP list is modified.

I want to use Office 365 Outlook connectors Get event (V3), Update event (V4) and Create event (V4) instead of Office 365 Group connectors Create a group event (V2). The latter doesn't offer the possibility to assign attendees to an event and there is no connector in Office 365 Group to update events.

The Office 365 Outlook connectors Update event (V4) returns the following error :

Error

Action 'Update_event_(V4)' failed

Error Details

The specified object was not found in the store.
clientRequestId: XXX

serviceRequestId: YYY (YYY is different that XXX)

 

Is it possible to use Office 365 Outlook connectors to create/update Office 365 Group events, or is there another workaround around the Office 365 Group connector's limitations?

 

Thanks

[mjburley]

The Flow actions always seem to be lagging behind what users need.

I'm not overly familiar with the event actions, but generally I end up using the Graph API to do a lot of these things.  The create event API docs suggest attendees can be set on creation.

I know Graph API may not be 'low-code'  but once understood it is very powerful.

[DonLimpio]

Thank for you answer.

I don't really know anything about Graph, but it seems like It's still not possible to update/delete an event from a group calendar (If possible I'll give it a shot!)

Also, can you integrate Graph API requests in a Power Automate Flow?.

[mjburley]

Graph API can be used in Power Automate via the HTTP request action. You can play around with the API at Graph Explorer - Microsoft Graph which has examples built in.

Reading your original post again, I think the problem is something else. I successfully ran a similar Flow. Your error implies in the action Update Event (v4), that the ID in the id field does not exist. That field is populated with the id field from the previous step Get Event v3  - outputs('Get_event_(V3)')?['body/id'] ?

[DonLimpio]

You were able to use Update/Create Event (V4) in a 365 Group calendar!

Yes: 

Get_Event_(V3) check if the SP column AppointmentID value match one of the Event ID in 365 group calendar : "id": "@triggerOutputs()?['body/AppointmentID']"

• Success (ID found) : the flow run Update_Event_(V4) with the ID from Get_Event_(V3) : 
  "id": "@outputs('Get_event_(V3)')?['body/id']"
• Faillure (ID not found) : The flow run Create_Event_(V4) and save in SP column AppointmentID the calendar event ID (See connector Update_item_2) : "item/AppointmentID": "@outputs('Create_event_(V4)')?['body/id']" 

I deleted the ID and events to check on Create_event_(V4)

The connector has a strange behaviour, It's running multiple times, ends up creating ~100 identical events in the Group calendar, and terminates with the following error:

Output of Create Event (V4)

{
    "statusCode": 404,
    "headers": {
        "Pragma": "no-cache",
        "x-ms-request-id": “   FOO   ”,
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Cache-Control": "no-store, no-cache",
        "Set-Cookie": "ARRAffinity=   BAR   ;Path=/;HttpOnly;Secure;Domain=office365-cc.azconn-cc-001.p.azurewebsites.net,ARRAffinitySameSite=   BAZ   ;Path=/;HttpOnly;SameSite=None;Secure;Domain=office365-cc.azconn-cc-001.p.azurewebsites.net",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "true",
        "Date": "Fri, 08 Apr 2022 20:23:28 GMT",
        "Content-Length": "462",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 404,
        "message": "The specified object was not found in the store.\r\nclientRequestId:   foo   \r\nserviceRequestId:   bar   ”,
        "error": {
            "message": "The specified object was not found in the store.",
            "code": "ErrorItemNotFound",
            "originalMessage": "The specified object was not found in the store."
        },
        "source": "office365-cc.azconn-cc-001.p.azurewebsites.net"
    }
}

It seems like we have the same issue with the ClientRequestID and ServiceRequestID not matching.

Isn't it weird that the flow is still able to create the event in the group calendar but still ends up failing?

[mjburley · Accepted solution]

Actually I made a mistake and did not get it to work on a group calendar.

But what I did was use the 'Office 365 Groups' action 'Send an HTTP Request'. This is a simpler way of using the Graph API.

First one needs to get the id of the group calendar, so do a HTTP Get with the below URL inserting the relevant group ID.

https://graph.microsoft.com/v1.0/groups/@{outputs('an_example_group_ID')}/calendar

and get the id from:

body('Send_an_HTTP_request_to_get_Calendar_ID')?['id'].

With this an event can be created using the same HTTP action:

The body of the request is described on the Create event API page, so just copy and paste and change what is needed. (I would remove the transaction ID line at the bottom).

The ID of this event can be captured from the action response like before, and this ID can be used to update the event (doc here)

Hope that makes sense. My example Flow I uploaded to GitHub

[DonLimpio]

Thank @mjburley  for the solution!

I had to put the Body of the HTTP request in a compose instead of writing it directly in the connector, it still works fine. (I think it's because I wasn't able to upload the .zip, had to go in the json file to see what you had done, so our flow are probably a bit different)

One last thing, is it possible to have a line break in the "content" to format a bit what is displayed in the event description. I tried <br> since the contentType is HTML but it's not working?