2

I am extremely new at SharePoint Designer. That being said, I need to set up a work flow to send an email to when a data is added to a field in a list. The email address would come from another list on the same page. We have a program where you choose the office and plant to send issues. Both are drop down and are in a list with an assigned email address. I did not create this. When the office creates the original issue for the plant an email is sent to the plant. There is a response item in the list. My manager would like a email sent back to the office when the plant enters a response. Any help would be greatly appreciated. I have tried to created the workflow and have been unsuccessful.

This is the work flow enter image description hereenter image description here

The emails addresses would not go in the list without hyperlink. But the work flow is Lookup as text.

  • So there is already a workflow emailing the plant when the issue is created? And the email addresses are kept in a separate list? – Erin L Jul 20 '16 at 16:56
  • Yes. There is also a different list for the plant to email the office when there is a problem with what the office send to the plant. So there are 3 list, one for offices, one for plant and a list of email addresses they both use. – Cynthia Fuller Jul 20 '16 at 17:54
1

First, you can use a Lookup instead of a choice dropdown to get email addresses of offices. Then you can include the email address from the email list in the settings for the office lookup field.

Lookup field settings

Then in your workflow, use the Wait for field to change action to wait for your Response field: Wait for Response to not equal Current Item:Response.

Then send your email with the Send Email action, with the "To" address being Current Item:Office:Email as Lookup Value (as Text)

  • I am going to try that now. Our system deleted your picture so I sent it to my self to see what it was. – Cynthia Fuller Jul 21 '16 at 19:14
  • I tried this and it did not work. I am going to try again, maybe I am missing something because the second time I tried I didn't get the option to have the lookup value as a text. The field for the email addresses is a email address which shows as mailto: then the email address. So should it be a text field? – Cynthia Fuller Jul 22 '16 at 20:41
  • Do you mean that the email address in the lookup list is a hyperlink field? – Erin L Jul 22 '16 at 20:51
  • A hyperlink field won't be available as part of a lookup field. You'd have to use text. – Erin L Jul 22 '16 at 20:57
  • Yes it is a hyper link. Is there a way to make it work with a hyperlink? Other wise how would it know which email address to send the message to? – Cynthia Fuller Jul 25 '16 at 12:14

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.