cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trevco
New Member

Search for ID of o365 calendar event ID using Google event ID.

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

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:8.jpg

The flow works successfully as below:9.JPG

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:10.JPG

 

11.JPG

The flow works successfully as below:12.JPG

 

13.JPG

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-xida-msft
Community Support
Community Support

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:8.jpg

The flow works successfully as below:9.JPG

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:10.JPG

 

11.JPG

The flow works successfully as below:12.JPG

 

13.JPG

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,540)