Skip to main content
Nintex Community Menu Bar

lookup using ID from listlookup throwing an error

  • August 4, 2020
  • 1 reply
  • 3 views
Forum|alt.badge.img+1

I'm trying to do what I thought was a fairly basic function. I have a list of equipment serial numbers and the addresses for that equipment. When the serial number is selected from the Listlookup control I want to use a rule with a lookup to populate the address fields. If I hard code the lookup with a list ID it works perfectly.

 

code: lookup("lstEquipmentList", "id", 836, "address")

 

If I use the variable for the listlookup I get an error.

 

code: lookup("lstEquipmentList", "id", [Form].[lstSNum], "address")

 

error: Microsoft.SharePoint.Client.InvalidClientQueryException"

    1 reply

    Forum|alt.badge.img+1
    • Steve-W
    • Author
    • August 5, 2020

    I was helped with a solution to this issue. I had to create a parseLookup variable, and tie the rule to the variable instead of the Lookup filed. This worked perfectly.

     

    Variable code: 

    parseLookup([Form].[ddlSerialNumber], false)

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement