Hi there,
I managed to copy a calendar entry from one calendar to another (in order for it to be visible for a group).
But I also want to update and even delete that entry in the group calendar when changes are made to the original entry.
Now I can't seem to get my head around how I can update this entry when the source entry (the one it has been copied from) changes.
I found an action that can update a calendar event but only when its ID is known but in the flow I only know the ID of the source
that triggered the flow but not the id of the destination.
Is there a way to search for a calendar entry and return its ID?
How would you update a calendar entry that you don't know the ID of?
Best regards,
Chris
Solved! Go to Solution.
Hei @HerrOlsen ,
This should be quite doable. What you have to do is when you create a new event, you have to put the ID of both the original ID and the new ID in a sharepoint list for example, to use that as a support table. Like this:
1. Create a SP list with two columns (OrigID, NewID - for example)
2. Make a switch depending on which action is happening (added, deleted or modify).
3. When an event is created, create the subsequent event in the new calender and collect both of the IDs in the same sharepoint list by using create item with both of the IDs.
When a event is deleted:
1. Use a get item and filter on the column with your OrigID (Remeber Filter query is case sensitive, so you have to put the exact column header string where i have 'Title', then 'eq' and the ID of your orignal event.
2. Then put in a deleted event and use the NewID value from your sharepoint list, which is connected to your OrigID in the sharepoint list.
This should do the trick, but let me know how it goes 😄
{ Please click Accept as solution ✔ if my post answered your question. }
{ This will in turn help others find solutions to similar questions. }
Best Regards
Heartholme
Hei @HerrOlsen ,
This should be quite doable. What you have to do is when you create a new event, you have to put the ID of both the original ID and the new ID in a sharepoint list for example, to use that as a support table. Like this:
1. Create a SP list with two columns (OrigID, NewID - for example)
2. Make a switch depending on which action is happening (added, deleted or modify).
3. When an event is created, create the subsequent event in the new calender and collect both of the IDs in the same sharepoint list by using create item with both of the IDs.
When a event is deleted:
1. Use a get item and filter on the column with your OrigID (Remeber Filter query is case sensitive, so you have to put the exact column header string where i have 'Title', then 'eq' and the ID of your orignal event.
2. Then put in a deleted event and use the NewID value from your sharepoint list, which is connected to your OrigID in the sharepoint list.
This should do the trick, but let me know how it goes 😄
{ Please click Accept as solution ✔ if my post answered your question. }
{ This will in turn help others find solutions to similar questions. }
Best Regards
Heartholme
Hi @Heartholme,
works like a charm.
Since I am quite a newbie I didn't even think about using a sharepoint list as a mappingtable between the two event-IDs.
Thank you very much.
Chris
Glad to hear that it works like intended! Once you get a bit more experience, solutions like this comes natuarally. A lot of it has to do with just knowing what you can use to solve specific issues, so keep at it! 😄
works great. i was able to create and delete. but still can't seem to figure out to update since it creates duplicates
Hi @kkvirani-phx,
You could have two actions in the updated switch, first a delete and then a create with the new updated information. That's one way to do it.
Let me know how it goes.
User | Count |
---|---|
85 | |
38 | |
23 | |
20 | |
16 |
User | Count |
---|---|
127 | |
48 | |
46 | |
27 | |
25 |