SharePoint List to Google Calendar

[Mike44]

I've created a flow wherein when a new row is added to a SharePoint list and event is created in a Google calendar.  I now realize I will also need it to make updates  and deletions to the calendar as they occur in the SharePoint list.  Below are images of my flow.

Prior to adding the conditions and controls to the flow, it ran without failures.  Since adding them, the flow fails at the first condition (see last image of message failure).  My thought process was to add the SharePoint list item ID to the description section of the calendar, thus the condition there reads - if the Event List Description does not contain the SharePoint list item ID, then create the calendar event.  Condition 2's - if the Event List Description contains the SharePoint list item ID, then update the calendar event.  Since adding these conditions, my flow fails at all points.  Any help would be greatly appreciated.

[v-bofeng-msft]

Hi @Mike44 :

Could you please tell me:

• Is the error reported in condition or condition1?
• What these two dynamics contents are?

Best Regards,

Bof

[Mike44]

Condition.

The dynamic content for both is 'Event List Description'.  The SharePoint item/row ID is stored in the Calendar's description.

[v-bofeng-msft]

Hi @Mike44 :

The point is that the data type of 'ID' is number but Event List Description is a string.

You can first convert the ID to a string and then use the contain condition to compare.

Please try :

string(triggerOutputs()?['body/ID'])

Best Regards,

Bof

[Mike44]

I made the update you suggested and now my flow's gone crazy.  I think it's stuck in some sort of loop.  It's creating multiple duplicate calendar events.  I don't think your update is the cause, but any idea on what's going on?  See pics.

[v-bofeng-msft · Accepted solution]

Hi @Mike44 :

Do you want to create a new event when the just created item does not exist in the events of the calendar? If this is the case, I suggest you adjust the flow logic.

Best Regards,

Bof