cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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

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

0 Kudos
Reply
1 Reply
Workflow Hero

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

I used the Form variable to collect the data. But now the issue is i have got the output with brackets []. If anybody faced please help me

Thanks

Yogesh

0 Kudos
Accept as Solution Reply