I am making a workflow that will read through all of the documents in a library and if they meet criteria send a notification to 3 various users that are responsible to review them. So in order to accomplish that I need to query some values from two different lists. My primary list has all of the document data including the business unit. The secondary list contains a business unit and 3 email addresses for each unit. When the workflow runs I want to be able to pass the 3 emails as variables to the TO field. I can get Nintex to query the values from the primary list with a Query List, For Each and Set Variables for each item I need to pass. But when I try to bring in the values from the second list I don't return any values. The For Each is centered on the Document ID and I set the criteria so that the first email would be queried from the child lookup list.
This is the config for the variable that isn't working.
Any advice on how to get around this would be appreciated.