Sharepoint 2010 Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint 2010       RSS Feeds

Workflow Column Lookup Error

  Asked By: Nathaniel    Date: Apr 18    Category: Sharepoint 2010    Views: 5663

Hi, I'm trying to simulate a list lookup under the same list item and the columns I have in place as follows:
There basically 2 requirements:

1 Generate GroupID value whenever ReplyTo is empty.
2 Perform a GroupID lookup on the condition of ReplyTo is equal to RefNo.

List Name: myList

List Columns Definition
Title - single line
RefNo - single line
ReplyTo - single line, lookup to RefNo
GroupID - single line * system generatedID

Data Entry Simulation

Entry: 1
Title: SP2010
RefNo: 101
ReplyTo: None

At this stage the GroupID will be created since ReplyTo is None

Entry: 2
Title: SP2010 Core
Ref No: 333
Reply To: 101

Workflow Design:
If Current Item: replyto is empty
Update item in Current Item
Set Variable:vrGroupID to myList:groupID
then Set groupid to Variable:vrGroupID

The Set statement has valuing condition
Data source: myList
Field from source: groupID

Find the List Item
Field: refno
Value: vrGroupID

But the Else condition doesnt return any value from vrGroupID. Strange thing when I give a manual value under Find the List Item to 101 then vrGroupID returns ABCDE, which is correct and meet the second requirement.

Can you share your thoughts to fill-up the missing part? Your help will be appreciated.




No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Workflow Column Lookup Error Or get search suggestion and latest updates.