So I have a list that users enter process information. It has columns such as "description", "date" etc. Then it has lookup column which looks up information from another list called "process owner", with the column being called test. It looks like the process name from that list.
The second list (process owner) along with process name has column "owner" and is a people's field.
So i am trying to setup a workflow that when user enters information to first list, the workflow lookups second list and based on that sends the process owner an email. I tried using Query list but it did not work. As such.
Also how do i save Querylist output results?