@Anonymous
Not and In are not delegable!
One trick you can try is with AddColumns. The AddColumns function actually returns a table, so all operators are usable on a table.
So for example.
Filter(AddColumns(table1, "sName", Name), Not(sName In Gallery1.AllItems.Name))
-or- if you want to shorthand the Not
Filter(AddColumns(table1, "sName", Name), !(sName In Gallery1.AllItems.Name))
This works because the filter is really on the Table that AddColumns returns, not on the datasource.
As an FYI:
This will work fine except you need to consider the size of records. If table1 has more records than your advanced setting are set for, then you will get potentially incomplete results.
Delegation and record limit are two different things. Solving one does not solve the other.
I hope this is helpful for you.
