Central Out of Office Calendar -- Issue Filtering when searching for duplicates/existing items

[mborn81]

Hello,

I have searched endlessly through the forum and haven't found a good match for this need, so thought I'd ask!

I have an Events list on a team SharePoint site that I want to get a 1-way sync from each member's calendar for any out-of-office events they have (to create a central out of office calendar).  I am working with 2 separate flows to catch both triggers (create and modify). 

• To start, I initiate a variable to be able to tag matches (called "itemExists", Boolean, set to FALSE as default) 
• Then I check if is Out of Office status
• For no, I terminate... for Yes, I grab user profile, convert time zones (these work, confirmed), then do the below
• On both, I have a need to check the list for an existing event. 
• I do GET ITEMS for that events list (SharePoint list)
• To filter and look for existing items that match (ID in description), I have tried several methods so far to no avail:
• ODATA filter query for description -- results in errors based on the filter string, says is "null" (because some events don't have anything in description)
• Filter array after -- added 2 to solve for the issue with null above and to pull matches:
• Filter array remove null values:
• From Values (from get items from list), check if "Description" is not equal to (function) Null
• This one appears to WORK
• Filter array for matches:
• Tried basic mode for:
• Description equals ID
• Description contains ID
• Then tried advanced mode for:
• @equals(string(item()?['Description']), string(triggerBody()?['Id']))
• @contains(string(item()?['Description']), string(triggerBody()?['Id']))
• None worked -- all show the proper inputs, but no outputs
• After the filter, I set the itemExists variable to TRUE (or try to, but of course haven't been able to get any inputs to this because of the filter issues)
• When creating, I embed the event ID into the description (only open text spot to park it) -- hence the filtering using this criterion above.

Can anyone please help?  

Thank you,

Matt

Overview of entire flow:

Drill-down into filter section:

Drill down into last condition and create: