AnsweredAssumed Answered

Filter list to find primary and secondary email addresses

Question asked by wooly on Jun 18, 2018
Latest reply on Jun 19, 2018 by wooly

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 

Outcomes