Answered

When an event is added, updated or del (v3) | Flow: SP List > Create works, Update/Del does not

(2) Share

Report

Posted on by Zepolian-STL

Hello!

I am working on setting up an overhead calendar view on SharePoint so that our users can quickly check the availability of meeting room resources. When new, updated, or deleted events occur, a flow is triggered to send the information to the designated SharePoint list.
Currently, the flow works well for new events, but it fails for updates or deletions.

I've come across similar setups online, but haven't found a solution yet. Before I spend more time trying to figure this out, I'd like to know if it's even possible to make this work. If it is, how does the flow identify the correct SharePoint calendar/list entry to modify or delete?

Here's what I have so far. Any assistance would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

Reason why it fails in update and delete action is because the id field value used in update or delete item is wrong. The id value you are passing is id of event object, while list item id is different. That is why error occurs and update/delete item got failed all time.

To avoid that you have to get id of list item where the event details are stored and then pass that list item id either to update /delete item.

see below how to do that. Suppose in below case, i have stored event details in SP list. Title in SP list is having event subject which i am considering now is unique.

Now see the flow design- here i have switch rather than if-else

Coming to updated- it looks like below

Here i used Get items and use Odata filter query to filter based on title column of SP list with value as event subject as i am assuming that event subject is unique for my case.

Now using the output of get items- i use the following expression to compute the id of list item and place in id field of update item.

first(outputs('Get_items')?['body/value'])?['ID']

Simmilar approach is done for delete item as well.

Expression used-

first(outputs('Get_items_2')?['body/value'])?['ID']

If you have unique field in sp field which can distinguish each event and that value won't change- use that as in odata filter query to filter out list details. Or another way would be to create a field in SP list which stores event id use that in odata filter query to filter based on event.

It would help as well.

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
Zepolian-STL 8 on at

Like (2)

Report

Thank you Nived, you are a genius!
Appreciate your assistance!

Was this reply helpful? Yes No