Skip to main content

Hello everyone,

After looking up and down the list of HowTo's and so on and so forth, after seeing quite some video on YouTube and after trying almost every combination of varible types, I kind of fed up with not being able getting an "easy" website workflow up an running. I would really appreciate your help and time!

 

Aim :
Query list of checked out documents and check them in .

Give me a counter of successful cycles and a lookup for the name of document within the loop.

 

Error:

### An unhandled exception occurred during...
System.ArgumentNullException: Value cannot be null. ###


Explanations:

"Action Item]
Property = "Value]

 

######################################

;Query List]

List = ;Documents]

Filter = ;Checked Out To]

     Property = 6Name]

     6is not null]

 

#Count Items In Collection]

Target = fcollection_ID]

     Type = Collection

Total items = rnumTotal]

     Type = Integer

 

-- until here it seems working
-- cnumTotal] = 3 for the 3 checked out documents


"For Each]

Input Collection = ccollection_ID]

     Type = Collection

Output Value = llist_ID]

    Type = Integer                                     <== HERE IS MY PROBLEM                 

Output Index =

     Type = Integer

 

Set Variable] > used in aProtocol]

Variable = ]txtDocName]

     Type = Text

Value = xLIST LOOKUP > SOURCE : Documents

                                       | FIELD : Name

                                       | WHEN : ID

                                       | EQUALS : Workflow Variable ylist_ID] ]

 

 Check In Item]

Item = rDocuments]

Where : ]ID] EQUALS Workflow Variable nlist_ID]
Check In Type :              

-- fcheck in type] is the absolute default, no checkout neccessary i.e.

 

Where is my faulty thinking leading to that mistake?
I tried for type TXT , INT , NUM , GUID and even DIC in my desperation for .list_ID], but none worked. How can I fix that?!

Best regards from Germany,
Andy.

Hi,

Make sure in your query List you set the "Output Type" to "Separate output per column" (This is the key).

You can then use a Text Variable in your For Each "Output value".
Then use this Text Variable in your Check in Item action Where ID equals the text variable.
Thank you. Sorry, I'm late saying this. This is quite a trick to get things working!

Reply