Exclude items from view using a filter (“does not contain”)

Unfortunately “Not contains” is not a valid operator in a CAML Query and thus not usable in a list view either.

What you could do is to add a yes/no column called “Superseded” and have a Flow or Workflow (you did not specify what SharePoint environment you are working with) that updates this field whenever an item is changed.
Then, update your view to exclude items that has Superseded = Yes.

Here is an example using Flow:

enter image description here

The formula I used is:

greater(indexOf(toLower(triggerBody()?('{Name}')),'superseded'),0)

Which will set the field to Yes if the function (lowercase file name includes ‘superseded’) equals true.


Depending on your environment and document libraries there could be other viable solutions as well.