cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamras Kudo Kingpin
Kudo Kingpin

How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

My first flow creates a calendar event when a new SharePoint list is created.  I'm creating the next flow which should be triggered when the SP item is modified.  The Update Calendar Event requires an ID, how do I get the ID from an existing event?

 

Also, I'm assuming the both ID fields are identical since whenever i select one or the other both dynamic contents appear at the same time. One is required, the other isnt  and both have different descriptions.

 

CalUpdateEvent.png

 

 

Thank you

 

 

12 REPLIES 12
Community Support
Community Support

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hi Tamras,

 

Instead of using the "O365-Update event(V1)", I suggest that you could try to use the "O365-Update event(V2)" action, which does not have 2 "id" fields.

Capture.PNG

2.PNG

 

About the id field, it is actually the event id of this event.

 

PATCH: https://outlook.office.com/api/v2.0/me/events/{event_id}

 

See detailed explaination here:

https://msdn.microsoft.com/en-us/office/office365/api/calendar-rest-operations

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
mmangiante Helper V
Helper V

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hello @Tamras

 

I've done a similar thing and I can say that I haven't found a simple solution. What I've done:

 

  1. Created in the SP List a field (say IDCal) where store the calendar ID: the field is a simple text field (255 characters are sufficient)
  2. At the end of the new item flow, create an "update item" action where you can store the calendar ID (is the ID field present in the "Create Event" action) in the SP field previously created

Now start the "not so simple" solution: if you implement a similar solution like I suggested, when you create an edit flow (so with a trigger, not an action) you have a problem that this starts every time you fire a new item event, so if you have particulat actions on the edit flow those are excuted..and you don't want this; I resolved with this workaround:

 

  1. I created 2 hidden fields in the SP List that stores the original DateFrom and DateTo
  2. In the new item flow, when you use the item update action to store the IDCal, I save the actual dates in hidden fields created previoulsy
  3. In the edit flow, use the condition to compare the dates: if the actual dates are equal to those stored in the hidden fields, you have only used the action to update the item so I left the flow
  4. If the dates are different, you have started an update trigger, so and edit flow, so I don't go away, but I execute all the actions related to the update flow
  5. To compare the dates, I use to do the sum of the dates, so if it is 0 there is an "update action", otherwise you activated an edit flow (triggered)
  6. The formula I use is =SUM(DateFrom,DateTo) or =SUM(DateFromOriginal,DateToOriginal), the field is a calculated field with number as output and decimal set to "Automatic"

I haven't found a better solution, if another people have a simple one I'm opened to a suggestion.

 

--

Regards,

 

Marco Mangiante

mmangiante Helper V
Helper V

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hello @v-monli-msft

 

I've seen last week that there is a new event creation, but after one day it disappeared: it is now "Create event v2"?

 

What I'd like to see in that type of action is something similar to an "appointment" where you can set that I can not send an invitation when I create the event: so, for example, I create an event on a people calendar but without the user interaction, so no mail to accept the event.

 

 

--

Regards,

 

Marco Mangiante

Tamras Kudo Kingpin
Kudo Kingpin

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

@mmangiante Thank you.  I'm trying it now. This is the ID being generated:

AAMkADE2ZThjYjU0LTE3MTQtNDM4ZS1iNmViLTAzMTE5NmQ1ZTc1MQBGAAAAAAAlsc_igN2xSrrfmt1qHgisBwDg6XjCy3UESaYbrFRHw4HDAAAAAAENAADg6XjCy3UESaYbrFRHw4HDAAAaSjVkAAA=

 

Looks about right?

 

 

 

 

Tamras Kudo Kingpin
Kudo Kingpin

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

@v-monli-msft - I dont see that in the list of options. I only have one:

UpdateEvent.pngOnly one Update Event option

 

UpdateEvent2.png

mmangiante Helper V
Helper V

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

 

Hello @Tamras

 

I have a similar one: 

 

AAMkADkxYTNiOGE2LTI1MGQtNDQzZS04NzNjLWM2Mjg3YmZjMDkxMABGAAAAAAAhH37TopWDSbt5mUDxZSO0BwB3WknalCbSQbFI8e1u3K3IAAACoiTiAAB3WknalCbSQbFI8e1u3K3IAAAOy7OQAAA=

 

and it is unique; yours is right: with this I updated my event.

 

--

Regards,

 

Marco Mangiante

 

 

 

 

mmangiante Helper V
Helper V

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hello @Tamras @v-monli-msft

 

I have the new one:

 

flow new create event.png

 

I noticed it now, last week I used the event and only one day I've seen a new type of event (even if it is not called v2) that disappeared the day after.

 

--

Regards,

 

Marco Mangiante

Tamras Kudo Kingpin
Kudo Kingpin

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Oops, i run into another issue, how do you create a calendar event for another person? For example, if I am completing the form on behalf of another person, I want that person's calendar to be updated with the new event rather than mine?  Thanks.

mmangiante Helper V
Helper V

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hello @Tamras

 

this is the great problem of Microsoft Flow, in my opinion, at this time. It is not so simple to do a more general action because for its nature is bound to credential.

 

You have 2 options: one, certainly, is the simple one but it is not "usable" because it is the "collection" of user credential; on the home page, go to the Tools menu (the gear near your user) and select Connection: from there, click the "+" sign of "Office 365 Outook"; the drawback of this solution is that everyone must come to you to insert their credential.

 

The second option is a workaround but I don't if it works and is good for your flow: I use a "service" account, that is simply an Office 365 shared mailbox and sign in the create (or update) event with that account; I choose as "Calendar id" the default calendar (or even other calendar for that account) and fill the "Attendees Address" with the address of the people that you want the calendar is filled: the event is created (or updated) on the default "Attendees Address" calendar.

 

Hope this can help. Sincerely, I tried to find a better solution (maybe with some permission on the calendar is possible to do so but I tried with no luck) but until this time I haven't found nothing.

 

Let me know if I can help maybe with a screenshot.

 

--

Regards,

 

Marco

Tamras Kudo Kingpin
Kudo Kingpin

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hi @mmangiante, Thank you.  The event still need to be entered in the person's outlook calendar -- to block their calendar when scheduling a meeting invite. I tried adding the attendee's name and address in my current flow, but it still requires them to 'accept' the invite -- which will not block the event.  I'll try your 2nd option.  Thank you 🙂

mmangiante Helper V
Helper V

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Hi @Tamras

 

yes this is a little problem of calendar event; I suggested in a previous reply to @v-monli-msft to create an appointment action (or similar): if I remember well with the appointment you can specify if the attendee may receive the invitation or if it is, say this, accepted as defualt.

 

--

Regards,

 

Marco Mangiante

dimi Impactful Individual
Impactful Individual

Re: How to identify the ID for the Update Calendar Event (SharePoint / O365 Outlook)

Faced the same scenario and what i did was used a service account to execute the Get Calendars & Create/Update event, the only thing is that you have to have delegate rights in order to do these actions on someones calendar. So you can run this PowerShell command in order to gain these rights, you will only need to accept it in your service account (for each calendar you give access to) and thats it, with the Get Calendars action you can get the Calendar Id's and perform what you want to.

 

PS command is: Set-MailboxFolderPermission -Identity user@yourDomain.be:\CalendarName -User yourServiceAccount@domain.com -AccessRights Editor -SendNotificationToUser $true

 

Good luck all !

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,691)