I have a document lib with a lookup field called "Customer Name". When I try to use that field in the Blackpoint workflow, it adds characters to it. For example, for Customer "Test", Blackpoint renders it as "24;#Test". I thought maybe the 24 was the ID of "Test" in the list of customer names that it's looking up to, but it's not. Additionally, I can't get Smartobjects to work on this. What should I do?
Page 1 / 1
I was able to parse the lookup value using a Reference Event:
- Add a Reference Event to an activity.
- Add a reference to the Microsoft.SharePoint.dll (c:program filescommon filesmicrosoft sharedinisapi)
- Select the Microsoft.SharePoint.SPFieldLookupValue constructor that takes a string value parameter
- Map the fieldValue parameter to the lookup field value (formatted as 1;#value)
- Assign the LookupValue property to a data field using the Retrieve Value, Execution = After
- The data field should now contain the value of the lookup field without the ID
Sorry no screen shots.
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.