Skip to main content
Community site session details

Community site session details

Session Id : qflLw37D/aRDzPaQ3DGZpK
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 30 Dec 2022 18:52:37 by 7

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

  • ClaudiaSp Profile Picture
    7 on 04 Jan 2023 at 07:02:36
    Re: Get events (V4) Filter Query

    Awesome! This solved my problem, thank you?

  • Verified answer
    VictorIvanidze Profile Picture
    12,536 on 03 Jan 2023 at 14:49:16
    Re: Get events (V4) Filter Query

    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.  

  • ClaudiaSp Profile Picture
    7 on 03 Jan 2023 at 14:42:37
    Re: Get events (V4) Filter Query

    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.

  • VictorIvanidze Profile Picture
    12,536 on 01 Jan 2023 at 10:58:47
    Re: Get events (V4) Filter Query

    Have a look at this:  https://ivasoft.com/pusheventsflow.shtml

    You can use it as a base of your flow.

  • MarvinBangert Profile Picture
    1,922 Most Valuable Professional on 30 Dec 2022 at 21:38:02
    Re: Get events (V4) Filter Query

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading complete