I'm building a flow that takes data from multiple SharePoint lists and combines it into one, either updating or adding as needed. As part of that, I was planning on using a Select function to get IDs from one list, then checks against the IDs of another using a Contains to see if the data has been imported yet. However, no matter what I try, none of the data coming from the Select triggers the Contains. I can get an array of [2, 3, 4], for example, and Contains will still say false if I ask it if 2 is in there. I've tried it on a stripped-down version of the flow, and Contains will not trigger if I get the data from the list, but if I hard-code in the EXACT SAME data, it works. I can get matches with a for-each and direct equals, but then I'd need to either use another nested loop so I can compare with both lists or use a filter and add another layer of complexity. I've also confirmed that this only happens with number columns; using it with a text column means it works as expected.
