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

[Swapna Abburi]

Hi @Bidduam 

In lookup records flow step, use condition as below.

sys_user.sys_id IN u_admin_users

[Bidduam]

@Swapna Abburi  Thanks for the advice, unfortunately there doesn't appear to be an 'IN' option

[Swapna Abburi · Accepted solution]

@Bidduam 

Please select "is one of"

[Bidduam]

@Swapna Abburi worked perfectly, thank you heaps