Update event in SharePoint Calendar

[Kevor]

Hello everyone, I have successfully produced a flow which creates events in a Sharepoint calendar (User completes a Microsoft form which creates entries in a Sharepoint list, which in turn creates entries in a SharePoint calendar).

I would like to either create a seperate flow or alter my existing flow to enable automatic deletion of cancelled events (I envisaged using a form completed by the user for this) and to amend changed events (again instigated by the user through a form).

My Sharepoint list has an ID column which I have tried unsuccessfully to use to recall and amend events (I know the Sharepoint list is not neccesary but I wish to collect this info to manipulate at a later date). I suspect I may be using the wrong ID, but despite spending quite some time trying today and looking at possible solutions I have continually failed!

Can some one please point me in the right direction? 

Thanks, Kev.

[efialttes]

Hi!

"My Sharepoint list has an ID column which I have tried unsuccessfully to use to recall and amend events"

I assume you have implemented a recurrence trigger, a Sharepoint 'get tems' action block, then you filter those that are cancelled either via ODATA filter inside 'Get items' or via 'Filter array' action block. I also assume then you added an 'Apply to each' to iterate all thorugh the cancelled events... inside the 'Apply to each' you need the current iteration item ID to delete current event.

Is my assumption right? If so, the following expression should do the magic:

item()?['ID']

THere is also another approach that is to trigger when an item is created or modified, then evaluate if it is cancelled, if so delete item. Details how to proceed here:

https://powerusers.microsoft.com/t5/General-Power-Automate/Delete-Event-for-an-existing-calendar-inv...

Anyway, if you share a screenshot from your current flow design, we will suggest how to fix it

Thanx!

[Kevor]

I tried various things but got nowhere so deleted my efforts, can you tell me more about a recurrence trigger?

[efialttes]

Hi!
More info on recurrence trigger
https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks

Hope this helps

[Kevor]

Hello again everyone and thank you again for your help to date,

So far I have tried various things really only succeeded in making myself more frustrated, in the end I started again just trying to update my SharePoint list but got to the point where I didn't know if I was coming or going, or maybe even where I was!!

This is what I had at the point of giving up....

12

@efialttes