How to set a lookup column?

Joerg_K.

• Created November 28, 2024 14:49

I have a Document Library that is used as a sublist to a regular List. When you add a document via the regular list a lookup back to the parent item is set.

However, when somebody adds a document to the folder of the parent item of the regular list, the lookup of course keeps empty.

Now I want to set the lookup column "LookuoToTime Tracking Test" at the document programmatically with "Update item"

Sadly, just entering the ID of the item at the regular list (parent item) is not working, nor the Title of the item at the regular list (parent item) is working.
The variables I have created do hold the ID and the Title of the parent item the uploaded document belongs to. So combining them like this:


Is also not working!? Any idea how to achieve this?

Many thanks
Kind regards
Joerg

0

• 

  Joerg_K.

  • November 28, 2024 14:52

  Haha, I got it it will work as the above image shows, I found that I had a typo - it's ;# and not as in the image :#

   

  0
• 

  Christof

  • November 28, 2024 16:26

  I think it should work as well with just the ID of the target item as Assignment Expression as mentioned in Value formats of all column types -> Lookup - single selection
  In your example with:

  =[[@Variables.vApplicationID]]

  0
• 

  Joerg_K.

  • November 29, 2024 05:18

  Hello Christof,

  correct, I just tested it with your value format and it worked too. Seems this was the only variation I did not test :)

   

  0

Please sign in to leave a comment.