Flow help to update a user record

[Bidduam]

I have a list collector on a catalog item called

u_admin_users

I then also have a custom variable on the sys_user table that is a true/false field called:

u_admin_account

So I have the flow as follows:

2. Look up records where sys_user.sys_id = u_admin_users.sys_id

Then a For each item in 2. look up records update the u_admin_account so = true.

For some reason it is not picking up the records to update.

I have tried changing 2. Look up records where sys_user.sys_id = u_admin_users.sys_id to a few different field values.

- sys_user.user_id = u_admin_users.user_id 

- sys_user.name = u_admin_users 

- sys_user.name = u_admin_users.name 

For some reason 

user_id - nothing found at all

sys_user.name = u_admin_users - found all users and shows sys_id, but count = 0

sys_user.sys_id = u_admin_users.sys_id - nothing

[Bidduam]

@Swapna Abburi 

Would you know how I can then do the opposite as well, where I do the equivalent of a "is NOT one of"

There is no real option for that and I've tried using 'is not' and 'does not contain' but it is still updating the records I'm trying to exclude.

So what I'm trying to do is update the user records listed in the list collector and add the tick to the checkbox, but then I want to go through all other records and make sure that those ones are not checked.