Announcements
28
Hi! I have a calendar on Outlook and I am wanting a SharePoint Events List to be updated when I update the Outlook calendar. I currently have this flow to add items to the events list when an event is created in Outlook, and it works:
I'm wanting to create another flow that will update the event (such as the time or name) or delete the event if these actions are performed in Outlook. This is the flow that I currently have, however, it is failing when it's run. I think I am missing something:
Hello
I also have a similar issue, but it is the opposite of the problem currently being discussed in this conversation. I want to update the Outlook Calendar when the SharePoint list is modified with the following workflow. However, when I run it, the Outlook Calendar immediately updates all activities on a single date.
The question is, how can I filter this query so that only modified items can be updated on the Outlook Calendar?
Awesome! It works just how I want it to now, thank you so much for your help and patience!!
Here is my final flow:
If yes expanded:
If no expanded:
If anyone else needs help on creating the Outlook Event ID I found the instructions on this link:
Solved: SharePoint Calendar and Events - Power Platform Community (microsoft.com)
The url I have ends in &Field=Outlook_x0020_EventID, so would I use Outlook_x0020_EventID or leave out the part in the middle?
For the filter query, you need to use the internal name of the field you added to your SharePoint list. Internal names would not contain any spaces. You can easily get the internal name by going to your list settings and clicking on the field name. Then look at the end of the URL in your browser. The internal name will be after "&Field=". Use that value in the filter query and it seems like you should be all set.
I've figured out how to make outlook calendar field which I named Outlook EventID. Here is my updated flow that incorporates the added, updated, and deleted all in one:
If yes expanded:
If no expanded:
It seems to be working for adding events. However, I'm getting an error message that says:
The expression "Outlook EventID eq 'AAMkADM0YWM1NjQ2LTIxYWUtNDdhMC05Y2IxLTJjMTM2ODQwZTkxYgFRAAgI241rQVKAAEYAAAAAxURMwUKJIUaDJ1P082G1QQcAN6XbpWCckEq1DnA4xB8krgAAZQZTbAAAN6XbpWCckEq1DnA4xB8krgABBwPDWQAAEA=='" is not valid. Creating query failed.
clientRequestId: c2f3a33d-5b52-4680-a112-d21d1093a573
serviceRequestId: c2f3a33d-5b52-4680-a112-d21d1093a573
So it seems the problems are in both of my Get Items.
Maybe, I would need to see the fields in your event list. However, normally every SharePoint list has an ID column, so you should not be able to add another ID column to your list. I am not sure how to explain it any easier, but you need to create a column in your SharePoint list to store the ID of the Outlook calendar event. After the Outlook calendar even is created, you need to populate the Outlook calendar ID field (any name you want) in your SharePoint events list when you create the item. This will establish the 1:1 relationship between the Outlook calendar event and your SharePoint list item.
When your other workflow runs when a calendar event is updated or deleted, you would then use the ID of that item to filter the Get items action in your SharePoint list as you show above.
However, I did notice one other problem. For your second workflow, which you want to run when the calendar event is updated, you are using the wrong trigger. You want to use When an event is modified (V3). The one you are using will also run when an item is created.
I made an ID column for the SharePoint event list and then added the following to the filter query:
Is this the correct way to do it?
My apologies, I am new to both SharePoint and Power Automate.
What I'm asking is how to set up the EventID. I had put that in my filter query because I'd seen it on another post. You mentioned that I'll want to add a field to my SharePoint list; I'm not quite sure what you mean by that--is this done in the settings of the list on SharePoint?
Thank you!
I am not sure what you are asking? To update only the one item in your SharePoint list that matches the Outlook calendar item, you need to use a filter query like you showed in your original post. If you are asking if this is done automatically, the answer is no. You need to set that up so there is a relationship between the two items. It is like setting up tables in a relational database using a unique key.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
