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.
Solved! Go to Solution.
The dynamic content for both is 'Event List Description'. The SharePoint item/row ID is stored in the Calendar's description.
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 :
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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!