Solved

Query List and Lookup Field

  • 23 October 2015
  • 1 reply
  • 142 views

Userlevel 3
Badge +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?

 

 

icon

Best answer by brentless 23 October 2015, 18:18

View original

1 reply

Userlevel 3
Badge +9

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"

Reply