Introduction

When working with SharePoint Service instances in K2 Workspace, the way that the SmartObject Service lookup field values were returned has changed. Previously (K2 blackpearl 0807), the format of the return value of a lookup was ID;#Value. This changed (in K2 blackpearl 4.5) to only the Value being returned and the ID was then returned separately in the ID Property.  This has now been made configurable, to either use either the old or the new return values.

An example of an InfoPath form with the SharePoint SmartObjects lookup field containing the K2 blackpearl 0807 format.


 
An example of an InfoPath form with the SharePoint SmartObjects lookup field containing the new K2 4.5 format.

 

An example of the new K2 4.5 Workspace SharePoint Service Instance page. Notice the ReturnInitialValue where the default is set to false. If you require it to function in the previous format, set the ReturnInitialValue to true.

 

Error Scenario

Note: The circumstances described in this article are one scenario under which this issue may, or is known to occur. The description is intended to be specific to the scenario described and does not take into account all possible scenarios or circumstances.

To reproduce this error:

  1. Create two SharePoint Lists, one with a lookup column to the other. 
  2. Add items to both SharePoint Lists. 
  3. Refresh the SharePoint Service instance. 
  4. Create a SmartObject based on the List with the lookup column. 
  5. Execute the Load method of the SmartObject. 
  6. Notice that only the #Value property is returned.

Error Message

There is no error message, this is an enhancement.

Error Resolution

This Hotfix is contained within the latest K2 Update. Install the update package to resolve the error.