1

I have list "A" in which i store name, email and product.

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 x@g.com 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)

cheers

ML

  • Are you absolutely not able to use 2013 workflows? It would make what you are trying to do so much easier. – Dylan Cristy Jan 8 at 20:38
  • i think your solution will return only one name, i need a solution that will return all where "car" is written – user80766 Jan 10 at 8:49
  • have you tried my answer, did it help you? – Zdeněk Vinduška Jan 18 at 14:30
0

SPD workflows do not have any looping capability. It is going to find the first one that has "car" in it and execute the workflow. You will have to incorporate some type of trigger on each list item and loop through it with code to trigger a workflow on each item in list B that has the product you are looking for and send the email. You can accomplish this with jQuery or RESTful type calls. I hope I am understanding what you are trying to do. You will have to work in a programmatic loop to trigger the workflows for each product in the secondary list you are trying to email to. You will more than likely have to put in some other hidden fields to use as flags for your workflow triggers. Use your code to change the email flags on your lists and then the workflow will trigger the email. I hope this makes sense to you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.