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
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!
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.