I have a main list with field "site" and a secondary list with field "site" and "manager name". There are 10 sites and each have manager name. I have created lookup field site in main list and value is taking from secondary list. When user select any site mail need to be trigger to its correspondent manager. Like secondary list has value Site = AMS and Manager = XYZ
When I fill the main list and select site = AMS , a mail need to be trigger to xyz. How can I acheive this using sharepoint designer workflow.
Do I need to configure secondary list with lookup field