Create Flow that updates SharePoint item

[MikeM44]

I've created a flow with Power Automate where each time a new event is added to my Outlook calendar, it adds it to a SharePoint list.  The problem I'm running into is I can't figure out how to update the list if the event is modified or deleted from my calendar.  If someone could point me to a article, video, or provide some detailed information on how to accomplish this it would be greatly appreciated. 

[chasestreetdev]

In the SharePoint list, create a new column for Event ID. When you create the list item, give it the ID of the event from your Outlook calendar. When an event is modified or deleted (there's a trigger for that), just look up the item in the list where the Event ID matches that event, then modify the list item as needed.

[Mike44]

I appreciate your help.  I've done what you suggested, but after adding a column for Event ID and assigning the ID of the calendar to that field I keep getting the following error.

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/EventID' is required to be of type 'Number/double'. The runtime value '"AAMkAGUyNWMxYzU4LWNiOTktNDk3Yi1iMjVlLTY0ZDk2NzAzMDM4ZQBGAAAAAADiBJl9UX85T68yIiRccG1IBwB5T3F5KCRtR4V8FxCJjOGbAAAAAAENAAB5T3F5KCRtR4V8FxCJjOGbAAHWIwxBAAA="' to be converted doesn't have the expected format 'Number/double'.

The Event ID type is set to number.  I don't see and option for setting to number/double.  The flow runs fine without EventID.

[chasestreetdev]

What happens if you change the Event ID column to be a single line of text instead of a number?

[Mike44]

I could swear that I had tried that and it failed, but this time it ran.  With regards to creating the flow to to update, I'm exactly sure of the steps that are needed.  This is what I've tried, but nothing seems to happen.  Sorry, but I can't get it all in one screen shot, so there are two.

[chasestreetdev]

When an event is modified/deleted use the "get items" operation to query for any item where the Event ID matches the event that was modified. The result of "get items" will be an array of list item IDs, so use the "apply to each" control to update/delete each list item as necessary (even though you'll probably only have one item in the array).

[Mike44]

I appreciate your patience, but I just don't understand the process or what to add where.  This is all new to me.  This is what I tried:

[chasestreetdev · Accepted solution]

@Mike44 This is difficult to explain, so I put together a blog entry on how I use it for my business. The first part doesn't really apply to you (it's more about triggering a flow with an API webhook) but this link will take you to the part of the example that should show you how to update a specific list item: https://chasestreet.dev/2021/04/01/updating-an-existing-item-in-the-teams-list-app/#get-the-name-of-...

[Mike44]

I appreciate you hanging in there with me.  I read the post, which was well written and very easy to follow.  Below is now what my flow now looks like.  When I test the flow, it says it ran successfully, however the updates are not applied to the list.  Am I missing a step?

[chasestreetdev]

@Mike44 It looks like you're just putting the original list information back into the item. I don't see any of the new calendar data being input into the update. All your dynamic content with the updated data should have the little blue calendar icon next to it, because that's where you get the new data from.

[Mike44]

I was just thinking the same, thanks for confirming.  We're getting there.  If I modify a calendar event (e.g., change date or time), it gets updated in the list, however, if I delete an event all data in the row is deleted except the Event ID and the ID.  Seems like the row should be deleted.  As the trigger is a 'when event is added, updated, or deleted' it should add new events, which does not happen.  Seems like another control or condition needs to be added somewhere in the path (i.e., if new calendar event, create item; else if updated event, get item, apply to each, update item; else if deleted event, get item, apply to each, delete item).  If I'm correct, I not sure how to set that up.

[Mike44]

I finally figured it all out.  Thanks for all of your help in getting this accomplished.  As soon as I can figure out how to post the complete flow in one screen shot, I'll post the results.

[Mike44]

Answer

[Mike44]

I would like to give you credit for the solution.  How can I do this?  Don't see 'Accept Solution'.

[chasestreetdev]

@Mike44 Your flow looks great! If you're new to this, you've picked up a lot really quickly. Thanks for the kind words.

[Al95]

@Mike44 I've tried this and it almost works perfectly. When I add an event it's all good and shows up on SharePoint. When I change the date or timing of an event I find it shows as several duplicates on my SharePoint calendar and then it also deletes the other events which no longer show up on the SharePoint end but still appear on the outlook end. 

Example I add 3 events labelled Monday, Tuesday and Wednesday, all shows up fine on SharePoint. I now update Monday, on SharePoint end it shows up to 5 times on calendar and then the other events get deleted. 

Have you had this issue? There must be something I'm missing but I have replicated your above flow. 

[222lovebirds]

I am having the same issue. At first, it seemed working fine then it started acting wonky. Now it adds two or three of the same event when a single event is created. Need help!! Please.

[222lovebirds]

@MikeM44 This flow is 98% there. I followed your screenshots, and it works well except it creates duplicates for some reason. Did you encounter such an error? Do you have any suggestions? Thank you in advance. 🙂