I am querying a list that has four columns - Country, Manager, Role & UserId (Email address). The role is either Primary or Secondary. The process is to send an email to both managers. The workflow is sending an email to the first entry that matches the Country but not to the second. I have created a variable that filters the list based on Secondary but whilst that will work it sends it to the first person who has Secondary based on their role but ignores the country filter. Is there a way to make both fields be true and return the email address as the result. I could not find how to do this. Any suggestions are welcome.
Example: Country = Australia & Role = Secondary then Email is fred.nerk@abc.com.au where fields for Country & Role are single line of text fields