Hello! I have 2 tables in my database:
'Employee Directory' with fields: Name, Seniority, Department, and Email.
'Equipment Requests' with fields: Request, Employee (linked), Department (lookup), Email (lookup), and Status.
I would like to create an automation where, upon the creation of a request (trigger), an email is sent (action) to the manager of the same department where the employee works.
After setting up the trigger ('when a record is created'), I attempted to configure an action ('find records') that operates on the 'Employee Directory' table, finding records based on a condition. The condition should be 'where Department is' some dynamic condition. However, I am unable to select a dynamic item for the Department; it appears grayed out and states "Cannot assign list of string to string".
Could you please assist me with this issue?
