Skip to main content
Nintex Community Menu Bar

How to pull another columns information when using a list lookup

  • January 10, 2017
  • 4 replies
  • 28 views

Forum|alt.badge.img+7

Hello,

     Currently I am using a List Lookup column type so users can select a "Transaction Name". With this, I would like to also pull the "Transaction Number" associated with the "Transaction Name" to use within the workflow. The list I'm referencing (Transaction List) resides on the same SharePoint Collection site as the Form. How can this be done? Thanks in advance!!!

 

     List Lookup Column (Form List)                List i'm referencing (Transaction List)

              v                                                                                v

197550_pastedImage_1.png 197551_pastedImage_2.png

4 replies

Forum|alt.badge.img+14
  • Scholar
  • January 10, 2017

probably the best option for you will be to place calculated value control on the form and use lookup() function within it to query for respective transaction number.

there is as well possibility to configure 'additional fields' to be brought in along with primary lookup field when you configure lookup field in the list.

however, disadvantages are that only fields of certain datatypes are supported, and that these additional field are only populated after you submit item to the list.


Forum|alt.badge.img+7
  • Author
  • Nintex Partner
  • January 11, 2017

I was actually able to accomplish what I need through the "Set Variable" workflow action. I first created a "Single Line of Text" workflow variable and within the the "Set Variable" workflow action, I set the created variable to equal "List Lookup". From the drop down that follows, the 'Transaction List' was the "source", "Transaction Number" was the "field", 'Transaction Name' was the "when" and it is set to equal the List Lookup Column on the form. Works like a charm! Thanks for the help though


Forum|alt.badge.img+14
  • Scholar
  • January 12, 2017

ah, ok. I understood you want that extra info already in forms.

if you have resolution to your question, mark it answered.


Maisa
Forum|alt.badge.img+2
  • Novice
  • November 18, 2019

You can just use calculate value , and it works , this is the step:

  1. Create a column single txt on your SharePoint list 
  2. On nintex form set a calculate value based on lookup in the function : lookup("name of the list","FieldList",parseLookup(NameOfYourcolumntoextratevalueinNintex,true),"FieldTodisplayInTheNewColumn") 
  3. Connect the calculate value to your List Colomn 

It works for me !