Power Query List.Contains

Hi,
Can someone tell me what I'm doing wrong with List.Contains,
I've looked at the ms doc and from description, cant see what's wrong,
I have code ;

Please Login or Register  to view this content.

Which give false, it does contain A and B ? , if I change to Any, i get a a true,

??
File attached,

Richard.

So it's not an OR criteria?

So with List.Contains( {"A", "B", "C", "D", "E"} , {"A", "B"} ) ,

List.Contai( { {"A","B"} , "B","C","D"} , {"A", "B"} ) is what I need. I think the penny's sought of dropped, just not sure

how this is different from list.ContainsAll ( ?

eg

Please Login or Register  to view this content.

Please Login or Register  to view this content.

but

Please Login or Register  to view this content.

just gets an error?


I thought List.Generate( using records could get complicted,.

This all started with uisng it as a filer in Table.SelecRows ;



Alist = list of A and B values; [Item] = Column to filter down,

Please Login or Register  to view this content.

I get this is sending a true false to select rows and selecting those that are true, but it still has more than one value?
I've attached workbook with this,



Richard.

Yes, I'd sort of realized that after replying. I'll mark this up closed.

Thanks,

RD

The List.Contains function can be a little tricky. Two things are confusing:

1. List.Contains has a list as first argument, and a single value as second. However, it checks for an 'exact' match of the value searched, within the list.
2. You can only provide a single value as second argument.



Alternatively, you can use List.ContainsAny

List.ContainsAny( {"A", "B", "C", "D", "E"} , {"A", "B"} )

Cheers,
Rick

Thanks,

RD