Strange Contains behavior


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


:wave: 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!
Screen Cast 2022-01-31 at 10.29.40 AM

1 Like

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.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.