I’ve been going through some old unresolved posts. This one in particular. The original request is asking for global access to the signed in user for filtering. I do see a new filter option in staging that would definitely solve this problem, so I’m excited about that.
The reason for this post is another idea I had after rereading through the old thread. What I’m thinking is a modification to the relation column that would let us Invert the results of the relation and return everything that does Not match. Probably not something that would be used often, but could help in certain situations.
In my situation I have a list of users. In that sheet I set up a relation to a Task form response sheet using email address. I then created a Lookup column to get an array of completed Task Names. With this array of Task Names, I was thinking that I could create a relation to a Task sheet, but invert the results so the relation only returns tasks that are not contained in the Task array.