flow designer - connect 2 tables

[JulietD]

Hi,

when a new sc_task created with the assignment group as 'aks' and short description 'abc' creted, the flow designer should trigger. There is a table named sc_req_item were there is a field named termination_username. This field value is required for further checks.

Also, There is another table named alm_hardware, the assigned_to variable is required here for further checks.

Take the termination_username value from the sc_req_item table, give this to assign_to field in the hardware table. If any record exists when we search using the name, add a note in the sc_task, 'thank you'. If there is no record associated with the user, directly close the sc_task. how to implement this? how can we take value from one table and use in another? how many lookups should use and the conditions

[Ankur Bawiskar]

@JulietD 

it's an easy requirement.

what did you start with and where are you stuck?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[JulietD]

1. 

2. 

condition: 'terminated individuals name->name' is 'trigger-record created->catalog task record'

3. 

condition:'assigned to->name' is '1 lookup records->requested item records

4. 

if '2 lookup record -> hardware record -> assigned to -> name' is empty

5. 

trigger record created -> catalog task record

6. 

trigger record created -> catalog task record.

pls have a look

[JulietD]

@YaswanthKurre  pls have a look and pls correct me if i am wrong

[YaswanthKurre]

Hi @JulietD ,

It looks correct to me , you can skip step 2 and get req item terminated user from trigger-> req item-> terminated user.

Mark this as helpful and correct, if this helps you.

Thanks,

Yaswanth

[JulietD]

Actually I am getting error in the third step.  I am not able to dotwalk to u_terminated_user_name, as there is no option to dot walk from the requested item recors