Skip to main content

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?

 

 

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