Strange Contains behavior

[Ingo_Bartel]

Hello,

I encountered a strange behavior of contains which does not make sense to me.
What I’m trying to do is Importing data from a table and update other tables if the values actually changed. For demo purpose I created a simply doc to show my use case in a simplified form and at the bottom you see the different result. A simple “.Join(,)” in the false condition makes the difference which I just found out by accident when debugging my action.

The test doc is here

Thanks,
Ingo

[Scott_Collier-Weir]

Hey there!

I think you issue is that you are trying to run a contains() on a list of lists value, rather than just a simple list.

Heres a GIF where I added a listCombine() to your formula to transform your list of lists into a single list, and I believe it solves your problem

Let me know if not!

[Ingo_Bartel]

Hi @Scott_Collier-Weir,

Thanks for your fast response. ListCombine() alone works indeed for the testdoc but not for my real life use case. What does work if i do ListCombine().Join(",").Split(",").Contains(xxx) - which still looks weird to me.

Thanks,
Ingo