-Notlike not working for comparing to array - Powershell

Question

Hello Guys,

I did a script where I can list all items from a SharePoint site

I want to exclude some kind of files (ex: PNG, PDF, etc)

$SystemItem =@(".PDF", ".PNG")
$Item = $ListItems | Where {$_["FileLeafRef"] -notlike $SystemItem}

this command is not working, I keep receiving pdf's and png's files

If I change the variable $SystemItem to $SystemItem =@("*.pdf"), the script runs perfectly, any pdf's files show up
once I use the variable $SystemItem as an Array it doesn't work

Anyone knows How can I use "-notlike" with arrays?

Thank you so much
Cheers

Answer 1

I think the M365 community could help you out best, Regardless, let me give it a go

$SystemItems =@(".PDF", ".PNG")
$notlikelist = foreach ($systemitem in $SystemItems){
$Item = $ListItems | Where {$_["FileLeafRef"] -notlike $systemitem}
$Item
}
$notlikelist

For their community please check https://techcommunity.microsoft.com/t5/microsoft-365/ct-p/microsoft365

Hope this helps!

----------

If it solves your question, please accept the answer and upvote!

Answer 2

Try this.

$Item = $ListItems | Where {$_["FileLeafRef"] -notmatch ".pdf|.png"}  

Answer 3

If you compare a scalar to an array you aren't comparing the individual elements of the array -- you're comparing the object that contains the array elements.

Try it this way:

$Item = $ListItems | Where-Object {$SystemItems -notcontains $_["FileLeafRef"]}