Contains doesn't work properly with string variables
I think it's a bug, although it could well be that I am doing something wrong.
I created a flow that picks up an RSS news feed and adds the relevant news (based on conditions) into a SharePoint list. Sometimes the feed outputs the same news title, so I am trying to remove the duplicates.
I created a string variable called All News at the beginning, to which I'm appending the existing titles from my SharePoint list. the flow finds the contains criteria false, saying that the new piece of news is not in the existing string variable, even though I can see it when I run the flow. So it tries to insert the existing piece of news, and then fails because I set up the SharePoint list to have unique title values.
See example below: The News title is " Why Flexible Gas Generation Must be Part of Deep Decarbonization" and we can see it in the String variable above, but the contains criteria doesn't catch it and tries to append it to the list.
And this is the last part of the flow - it fails at the contains: