Sharepoint lookup value from list?

I have used AJAX in the past to query a separate list on page load, though I can't find the code at the moment. There are several web services exposed by SharePoint that allow querying and this page seems to offer a solution that may be able to be adapted, using SOAP and jQuery. If I can find the time and the code, I'll happily post what I can soon EDIT: Workflow notifications can have links to the item being created or modified (whatever triggered the email) - If you have not seen this page: Send e-mail in a workflow then it contains instructions for several modifications, including links to the item.

With Sharepoint Designer, you can modify the View-Item page for items in that list so that they display other information related to the item, such as Richard's information.

I have used AJAX in the past to query a separate list on page load, though I can't find the code at the moment. There are several web services exposed by SharePoint that allow querying and this page seems to offer a solution that may be able to be adapted, using SOAP and jQuery. If I can find the time and the code, I'll happily post what I can soon.

EDIT: Workflow notifications can have links to the item being created or modified (whatever triggered the email) - If you have not seen this page: Send e-mail in a workflow, then it contains instructions for several modifications, including links to the item. With Sharepoint Designer, you can modify the View-Item page for items in that list so that they display other information related to the item, such as Richard's information.

Thanks CJ, this could be a viable solution for many scenarios but I think email is a little different. I cannot launch a webservice from within the workflow email. Could you think of some other approach I could use?

– L. De Leo Aug 9 at 16:12 If I understand correctly, you are trying to insert data from List B (based upon an item in List A) into the workflow email sent by the server. I'm not sure how to do this (if it is possible), but more information would be useful.

What is the goal of inserting the data (that is, getting Robert's ID)? Would a landing page that shows the information you want be acceptable? What browsers and email clients must be supported?

– Code Jockey Aug 9 at 16:44 Concerning the possibility of a landing page, also consider the regulatory implications of what you are trying to inject into the email. If this is a military or government system, my experience is that emails should be simply a notification such as "There is new information available through your account on System XYZ" and cannot provide or contain links, PII, or instructions/orders/commands (this is due to lack of encryption and/or a digital signature on the email). – Code Jockey Aug 9 at 17:13 thanks for your answers.

You understood the problem correctly. I'm trying to get Robert's ID in the email to build a link. Any workaround (including a landing page that displays the information) would be acceptable.It isn't a military site anyway.

Just some big paranoid corporation :) – L. De Leo Aug 10 at 8:42 Alright - unfortunately, a complete discussion of how to implement a landing page is not possible here - and digresses from the original question. I don't think the injection is possible with only SharePoint Designer and the web interface.

AFAIK, it would require server-side code. – Code Jockey Aug 10 at 17:44.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.