Skip to main content
Nintex Community Menu Bar
Solved

Query List and Lookup Field

  • October 23, 2015
  • 1 reply
  • 177 views

Forum|alt.badge.img+9

I am using the Query List and Get Item from Dictionary commands.

 

When I query a lookup field and return the ID and Title, I get something that looks like this:

 

{"PositionLookup":[{"ID":1,"Title":"IT Engineer"}],"FileLeafRef":"Sample Doc One.docx","Notice_x0020_Date":"2015-10-30T05:00:00Z","Reminder_x0020_Date":"2015-10-23T05:00:00Z"}

 

It is easy enough to get the other text and date fields using something like this:

Get Item from Dictionary with Path = "(0)/FileLeafRef" where 0 is the index

 

However, I cannot get the values of the PositionLookup lookup field.  What is the syntax to reach the ID or Title?

 

 

Best answer by brentless

Bleh, figured it out as soon as I posted...

The correct syntax is:   (index number)/LookupFieldName(0)/ID

Where 0 is the first (and only) item in the Lookup Field "array"

1 reply

Forum|alt.badge.img+9
  • Author
  • 56 replies
  • Answer
  • October 23, 2015

Bleh, figured it out as soon as I posted...

The correct syntax is:   (index number)/LookupFieldName(0)/ID

Where 0 is the first (and only) item in the Lookup Field "array"