AnsweredAssumed Answered

How to connect a Lookup calculated value of a cascaded lookup list

Question asked by hpyogesha on Aug 23, 2018
Latest reply on Aug 24, 2018 by hpyogesha

I  have a list called departments in coulmn dept . 

another list called approvers , fields are dept is lookup column from department list and email id is another column. 

 

Now i have a form where in field department will be filled by the user and the approvers based on the dept i want to populate the email ids off under that dept.

 

I used calculated value in the form and used the 

below formula 

lookup("Approvers List","Dept",Departments,"EMail ID",true)

 

Now the question is how i can connect to mail list column. Please help me

 

Thanks

Yogesh

Outcomes