How to update multiple records in flow designer?

Joyce4 · ‎05-06-2021

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?

Muralidharan BS · ‎05-09-2021

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

View solution in original post

Muralidharan BS · ‎05-10-2021

You've Welcome, there is no rollback functionality within flow designer, you have to navigate to sys_user table and then mark the records to its original state. From the flow execution you can get the records flow updated.

Joyce4 · ‎05-11-2021

Thanks. Do you know if the background color of Studio can be changed? It is usually dark green by default and I would like to change it to a different color, to easily identify which environment I am working in (training, production, development)