I have a lookup field in my list (called Request ID) which, of course, when I click on it, I am taken to the item in the lookup list. I'd like to provide this same functionality/link when I send an email using 'Send Notification' in my workflow. In the email, when I insert a link and provide the field in the address section of the link, it does not provide the correct url. Any ideas?
Page 1 / 1
When you include the field in the address, what are you getting? Is it an ID or the value of the associated lookup value? You should be able to manually put in the URL associated with the list that the lookup is in, along with DispForm.aspx?ID= at the end. I would guess the field will use the value of the lookup by default, not the ID. You may need to query the list that holds the lookup values and return the ID from it in order to generate the proper ID.
I accomplished this by adding a text field called Item URL to the list of the Lookup. When the Lookup item is created, I populate the text field with the url of itself. Then, When I Lookup this record from another list, I can check the URL field to be included. I can then use this field in an email.
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.