Unanswered

Calendar two way sync between tenants

(0) Share

Report

Posted on by marekkonecny

Hi guys,

how are you? I need a little help here. I was able to create a flow that will create event in another tenant based on whats created in the first tenant. However problem is that I cannot update event in another tenant because I got this:

Invalid filter clause
clientRequestId: 69a0db0c-6639-4d0a-a7db-d8015810e034
serviceRequestId: 5a845c10-b585-41cf-ab08-ed086d00a3bd

Im trying to do it by this: When an event is modified (V3) > Get Events (V4) ( tried also v3 ) > Update event (V4)

In Get Events I'm trying to filter by event ID which dont work and also when I leave filtering empty in Get Events then Update event ( based on ID ) will end up with error above or by this:

The specified object was not found in the store.
clientRequestId: d20383ca-736b-48c0-b249-7122b733c0f2
serviceRequestId: 03e4ed1e-5843-40c4-8d23-de027f753943

If you have any idea how to do this, could you help me please?

Thanks to all!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-duann-msft on at

Like (0)

Report

Hi @marekkonecny

Thank you for posting.

According to your description, you would like to sync events between two calendars.

Actually, we can’t use EventID to filter events in different calendars. The EventID is generated by O365 exchange, even though you copy this event from other calendar, we can only copy its title, time, attendees or location except EventID.

So in your case, I recommend you need to use ‘get events (V4)’ and filter based on subject. Please try to filter something unique instead of EventID.

You can also refer below similar threads:

https://powerusers.microsoft.com/t5/Building-Flows/Get-Events-2-filter-by-organizer/td-p/163422

https://powerusers.microsoft.com/t5/Building-Flows/OData-filters-on-O365-Events/td-p/250017

https://powerusers.microsoft.com/t5/Building-Flows/Filter-Query-Event-Attendee-then-Delete-All-Events/td-p/859903

Hope the content above may help you.

Best regards,

Anna

Was this reply helpful? Yes No
marekkonecny 6 on at

Like (0)

Report

Hello @v-duann-msft,

Thank you so much for tips. I did it by subject but im unable to add another condition to it so it will be start time just to not false positive edit event which may have same subject. However by this im unable to get edit working but flow runs good so idk where is the problem.

I have 2 separate flows 1: Create event, thats working great 2: Modify event which doesnt work

In filter array first subject is from trigger, second subject is from get events next up is classic edit event and data inserted are from get event. This way flow runs good but doesnt edit mentioned event. Also when I use data from trigger it gives me an error so it doesnt run so I suppose this way its good.

Any idea how to solve this please? Also trigger connection to tenant one ( source ) get events connection to tenant 2 ( destination ) Update event tenant 2 ( destination )...

Also how can I add starttime parameter to filter array as another condition please?
Thank you!

Was this reply helpful? Yes No
v-duann-msft on at

Like (0)

Report

Hi @marekkonecny

Thank you for your information.

In your case, I recommend you can use 'condition' action instead. Then, we can set up multiple conditions to filter.

Best regards,

Anna

Was this reply helpful? Yes No
marekkonecny 6 on at

Like (0)

Report

Hello @v-duann-msft,

here's my flow. When I test it everything is great but it doesnt edit the event in destination tenant at all. I decided to do a full screenshot with description of each. I'm kinda stuck here, I don't really know whats wrong right here and why it doesnt work if the flow looks like it succeeded.... If you will have any questions just let me know. And just to mention it does not update anything everything is the same.

Thank you!

Was this reply helpful? Yes No
marekkonecny 6 on at

Like (0)

Report

Hi @v-duann-msft,

do we have any updates? Or isnt it possible or what am I doing wrong please? 😕

Was this reply helpful? Yes No
ScarePoint 2 on at

Like (0)

Report

@marekkonecny— screenshot looks incorrect.

Under the Condition card, if you choose the Subject from "When an event is modified (V3)" is equal to Subject from "Get events (V4)", then it should give you TWO "Apply to each" loops; one for the source and one for the destination.

And in the Update event (V4) action, make sure the id value is the one from the destination while all other values are from the source.

Was this reply helpful? Yes No
Tedster69 2 on at

Like (0)

Report

Hi there @marekkonecny @, did you manage to figure this out? Sitting with the exact issue.

Easy to sync initial meetings but changes are ignored .

Was this reply helpful? Yes No