Solved

Nintex Forms for Office 365, Lookup function not returning values from Lookup column.

  • 11 March 2024
  • 1 reply
  • 39 views

Badge +6

Hello.

I’m building a “New Responsive Design” form and am having an issue where the Lookup function does not return any value if the “Output Column” is a lookup column.

lookup("zzz_Parts","Part Number",toUpper([Form].[PartNumber]),"Buyer")

The “Buyer” column is a lookup to the Title field in a list of Buyers. 

I am able to return values for every other, non-lookup, column in the list.

This same function returns the expected “<ID>;#<Value>” when used in the other form designs. 

This is my first time using this function in a New Responsive Form.  Is this a limitation?

icon

Best answer by nicksha 11 March 2024, 21:58

View original

1 reply

Userlevel 2
Badge +9

Hi @ethurber, I tested this and captured a network trace. I see that the following error from SharePoint Online is returned when using the lookup() to retrieve the value of a Lookup column:

 

"The query to field '[Column Name]' is not valid. The $select query string must specify the target fields and the $expand query string must contains [Column Name].

I see that you have an open support case regarding this inquiry. I’ll work with the case owner and the product team to determine how we can move this forward. In the meantime, this doesn’t seem to be possible.

Reply