I have list "A" in which i store
I have a list "B" which should trigger an email based on some values. One of these values is
product. If I chose "car", the workflow should then look into list "A" and see which email addresses store the same product. So if user X with email firstname.lastname@example.org has a product "car", it should send an email to his address. The problem is that this works only if there's just one person with a car. List A has multiple people with the same product. I somehow need to join all the mails into one or multiple emails and send them an email.
Something like an filter for product and return all emails that match that filter... any ideas?
I use sharepoint 2016, also infopath 2013 or SPD, but workflow 2010 (hope its not an issue)