Contains doesn't work properly with string variables

[Anonymous]

Hi everyone,

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:

Hope this makes sense - any thoughts?

Thanks!

Ana

[v-alzhan-msft]

Hi @Anonymous ,

Could you please share a full screenshot of the configuration of your flow?

And could you please share the full screenshot of the run history of the flow?

Best regards,

Alice       

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

[Anonymous]

Hi Alice, 

Sure.

This is the full flow - it's quite big, I tried to screen shot it.

I can't run it with a previous failed run because all the following runs were successful at the moment, but I'll add a failed run if I get one this week.

Thanks for your help!

Ana