How to update multiple records in flow designer?

[Joyce4]

I am trying to look up for inactive users that are still marked active in SNOW and mark them as inactive, and locked out. 

I tried doing this workflow but it doesn't look right. In action (3) under Conditions User Id is 1 -> u_inactive records doesnt' allow me to actually specify that it is the user ID in the results from action (1).

Can someone please assist? 

[Akanksha Gupta2]

Hi Joyce s ,

Please refer below link :-

https://docs.servicenow.com/bundle/quebec-servicenow-platform/page/administer/flow-designer/referenc...

https://community.servicenow.com/community?id=community_question&sys_id=54998a59db2eac10b1b102d5ca96...

If it is helpful for you or correct , so Please Mark it.

Thanks , 

Akanksha

[Muralidharan BS]

I think Look up records need a for action following, after for you can use a update record action to make it work. Like below should work

[Joyce4]

I don't know how to match the results.UserID to the users in Sys_user table. When I drag the u_inactive Record.User ID the details in "Table" is cleared, and when I insert the value in Table the values in "Record" is cleared.

[Muralidharan BS · Accepted solution]

I believe "u_inactive_record" is a staging table and you want to populate the value in sys_user. For that you have to add "look up record" action below the for loop and do a update record action. Like below 

Below For

1. use Look up record, select table as sys_user and in condition, "user ID" is "u_inactive_record.user_id"

2. Update user record, active - false and lock out true

[Joyce4]

Thank you! I ran it successfully in the Test functionality. Do you know how to undo the changes made by the flow designer since its just a test?