Sharepoint Workflow Email - Lookup field changes when trying to use as a link ?? [modified]
-
Hi Guys Okay I'm going to try and explain this. I have a workflow that sends an email when a new task is created. One of the fields in the task is a single line of text for a user to copy and paste a path to a directory on our network. When the email is sent I want to then make this field a hyperlink so the user that receives the email can just click it and they're taken to the directory. Sounds easy... here's the code.
A HREF="[%FCDrawing Request:Drawing Mark Ups%]">LinkThe entry in the field might look like this O:\01. Operations\02. New Sites\NSW\S1500 Testing\05. Drawings\01. CAD Files\Archive (Superseded)\Candidate A - Prime - Iss 02 Preliminary Design Now... when the email is sent the data in the field changes and it removes some spaces, which obviously means the link doesn't work. Here's what the link is now O:\01. Operations\02.New Sites\NSW\S1500 Testing\05. Drawings\01. CAD Files\Archive (Superseded)\CandidateA - Prime - Iss 02 Preliminary Design (look between '02.' and 'New Sites', the space has been removed) Any ideas why this might be happening?? If I don't include it as a link and just get the field to display in the email then it displays fine, the space is there and I can copy and paste the link and it works fine. Thoughts? Thanks Nicmodified on Thursday, September 17, 2009 7:54 PM
-
Hi Guys Okay I'm going to try and explain this. I have a workflow that sends an email when a new task is created. One of the fields in the task is a single line of text for a user to copy and paste a path to a directory on our network. When the email is sent I want to then make this field a hyperlink so the user that receives the email can just click it and they're taken to the directory. Sounds easy... here's the code.
A HREF="[%FCDrawing Request:Drawing Mark Ups%]">LinkThe entry in the field might look like this O:\01. Operations\02. New Sites\NSW\S1500 Testing\05. Drawings\01. CAD Files\Archive (Superseded)\Candidate A - Prime - Iss 02 Preliminary Design Now... when the email is sent the data in the field changes and it removes some spaces, which obviously means the link doesn't work. Here's what the link is now O:\01. Operations\02.New Sites\NSW\S1500 Testing\05. Drawings\01. CAD Files\Archive (Superseded)\CandidateA - Prime - Iss 02 Preliminary Design (look between '02.' and 'New Sites', the space has been removed) Any ideas why this might be happening?? If I don't include it as a link and just get the field to display in the email then it displays fine, the space is there and I can copy and paste the link and it works fine. Thoughts? Thanks Nicmodified on Thursday, September 17, 2009 7:54 PM
First of all we need to know a little on SharePoint lookup fields before proceeding further. Lookup fields are the reference fields created in any SharePoint list or library which provides a mapping between columns from another list i.e. it is just like a foreign key which helps build relationship between lists. While developing custom solutions there is often a need to retrieve data from a list or update data in a list but it's a bit different when the task is performed for a lookup field. Generally lookup data are stored as ID - Name pair separated with some special characters (i.e. ID;#Name). http://www.mindfiresolutions.com/lp/sharepoint-development.htm[^]
Cheers, Eliza