When an event is added, updated or deleted (V3) Filter Query

(0) Share

Report

Posted on by ClaudiaSp

Hi all,

I try to create an automated sync between two exchange calendars.

Regarding this goal, i've created a flow who creates a new event in calendar B whenever a new event is created in calendar A.

In the creation process, the ID of the event from the source calndar A will be stored in the body of the new event in calendar B.

That means, that every body will end with SYNC-ID-<RANDOM NUMBER>. (Random number means, that there will be the unique ID-number from the source event, added to every new event).

In a second step, I need to update also existing events.

To do so, I'd like to filter one specific event in calendar B by using the right filter query and search for the "SYNC-ID" with the ID of a source event on calendar A, where an update is triggered.

How can I filter by a specific string (with one variable ID-value based on the source event) in the body of an event?

Thank you so much for your help!

Kind regards

Claudia

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ClaudiaSp

could you please explain why you are trying to sync two exchange calendars? What is the use case you try to accomplish with this? Maybe there is a better way then using Power Automate Flows, it can be quite difficult to solve all possibilities of keeping the calendars in sync.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Have a look at this: https://ivasoft.com/pusheventsflow.shtml
You can use it as a base of your flow.

Was this reply helpful? Yes No
ClaudiaSp 7 on at

Like (0)

Report
Copy link

Link copied!

Hi @MarvinBangert and @VictorIvanidze
Thank you for your feedback.
I know, that this will be a really complex thing, but I've the case, that I'm currently working for two companies at the same time and I need to keep both calendars up to date to make sure, that everyone could see, when I'm available. Unfortunately, there is no option to make a trust between the companies.

In a frist step, I tried to only copy all the events from calendar A to calendar B including event updates and removement.

I found a solution (I decided to store the ID information in the "location" field) where the trigger "ADDED" and "DELETED" works fine, but I have some troubles with "UPDATED". Everytime, when I manipulate an event, a new one will be created and afterwards, both (the new and the old one) were getting updated. But this will result in a lot of double events. Do you have any idea to solve that?

I saw, that the flow is triggerd twice (once with action type "added" and once with action type "updated"). So the flow works well, but I found no solution to prevent the add function from creating a new event, if an event with the same ID already exists.

Please find attached the whole flow.
I start with the trigger When an event is added, updated or deleted (V3) followed by a switch based on the action type (ADDED, UPDATED, DELETED)
Note: Trigger DELETE: I deliberately chose "update date" instead of deleting for testing.

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Hi @ClaudiaSp,

you can create a scheduled flow that runs every 5 minutes to eliminate the problems of "When an event is added, updated or deleted (V3)" trigger.

Was this reply helpful? Yes No
ClaudiaSp 7 on at

Like (0)

Report
Copy link

Link copied!

Awesome! This solved my problem, thank you?

Was this reply helpful? Yes No