Power Platform Community Forum Thread Details

When creating an o365 event from a google calenadar event i save the google event ID as the body. When deleting how can I search for that google event ID to find the o365 event ID?

Categories:

Using flows

Hi @trevco,

Could you please share a screenshot of your flow’s configuration?

Do you create two separated flows on your side?

Could you please show a bit more about body of O365 calendar event? Is it the Body preview content?

Further, do you want to search for the google event ID which is stored in body of O365 calendar event to find O365 event ID when deleting the google event?

I have made a test on my side and please take a try with the following workaround:

The first flow: Creating an O365 event from a google calendar event and save the google event ID as the body of O365 event:

The flow works successfully as below:

The second flow: search for the google event ID which is stored in body of O365 calendar event to find O365 event ID when deleting the google event:

Add a “When an event is deleted from a calendar” trigger.
Add a “Get events (V2)” action, specify Calendar id.
Add a “Filter array” action, From set to output of “Get events (V2)” action, click “Edit in advanced mode”, type the following formula:

@equals(formatDateTime(item()?['Start'], 'MM/dd/yyyy'), formatDateTime(triggerBody()?['start'], 'MM/dd/yyyy'))

Add a “Apply to each”, Input parameter set to output of “Filter array” action. Within “Apply to each”, add a “Html to text” action, Content set to Body dynamic content of “Filter array” action. Then add a Condition, left input box set to output of “Html to text” action, right input box set to Event List Event Event ID dynamic content of the trigger, within middle drop down, choose is equal to.

Within “If/yes” branch of Condition, add a “Get event (V2)” action, specify Calendar id, Item id set to Id dynamic content of “Filter array” action.

Image reference: