Answered

Update SharePoint list when Calendar Event is updated/modified or deleted

(1) Share

Report

Posted on by Mike44

266

First and foremost, creating a flow is very new to me, so if it's not too much to ask, providing detailed steps or visuals would be greatly appreciated.

I have successfully created a flow where, whenever a new event is created in Outlook calendar it's added to a SharePoint list. I'm now trying to create one that will update the list if the event is updated or deleted. Pictures of the flow I created are below along with the error I receive. Please note, I'm not even sure if the process/steps are correct. The error I receive is:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')?['EventID']' is of type 'String'. The result must be a valid array.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Mike44 can you please let me know why you have apply to each action configure with Event ID?

Was this reply helpful? Yes No
Mike44 266 on at

Like (0)

Report

My logic, though it could be completely wrong, was that I needed to collect the Event ID of the calendar event that was updated/modified or deleted and then apply the update to the SharePoint list where the Event ID's matched. Again, my steps or the process outlined could be completely wrong. This is all very new to me.

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@Mike44 okay, in that case you have an extra Apply to each action which uses EventID, remove that apply to each. The update item action should be added directly under "apply to each 2" action. Also when you are updating the SharePoint items in update item action, shouldnt you be using dynamic content from trigger for column values?

Was this reply helpful? Yes No
madelinelabouf 28 on at

Like (0)

Report

@Mike44 Was this solution correct? I'm trying to do the same thing. I've figured out how to add new events on Outlook and have them go to SharePoint, but I'm struggling with the updating and deleting aspect.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@madelinelabouf can you please elaborate what issue are you facing on updating and deleting?

Was this reply helpful? Yes No
Mike44 266 on at

Like (0)

Report

I honestly don't remember, but I believe it was the correct solution. I'm no longer using this flow, so I'm not able to go and check.

Was this reply helpful? Yes No
madelinelabouf 28 on at

Like (0)

Report

No worries, thank you!

Was this reply helpful? Yes No
madelinelabouf 28 on at

Like (0)

Report

The first attachment is the flow that I have to create items, it is working.

The second attachment is the flow that I've made based on what Mike44 posted. I intend for it to modify or delete calendar events in SharePoint when an event is modified/deleted in Outlook. For this flow I am getting "failed" when it runs.

Thank you!

modify_delete_eve...

create_event_flow...

Was this reply helpful? Yes No
madelinelabouf 28 on at

Like (0)

Report

Update: I think these attachments are close to what I'm supposed to have for this situation. However, I still seem to be missing something as the run is still failing.

modify_delete_1.png

modify_delete_2.png

Was this reply helpful? Yes No