Logo 
Search:

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: 5778

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
GroupID: ABCDE

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

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

Workflow Design:
If Current Item: replyto is empty
Update item in Current Item
Else
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.

Cheers,
r2c3

Share: 

 

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.




Tagged: