cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Contains doesn't work properly with string variables

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.

 

flow_1.PNGflow_2.PNG

 

And this is the last part of the flow - it fails at the contains:

 

flow_3.PNG

 

Hope this makes sense - any thoughts?

 

Thanks!

Ana

2 REPLIES 2
v-alzhan-msft
Community Support
Community Support

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
Not applicable

Hi Alice, 

 

Sure.

 

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

full_flow.PNG

 

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Users online (3,787)