I have a problem with the Lookup function in Forms (Nintext for O365); the lookup itself is functioning (slowly) if the lookup returns a single record, but if there are multiple records matching the 'filter value', it still only returns the one record (first match).
I looked at the help from within Designer, which says lookup(List Name, Filter Column Name, Filter Value, Output Column Name, Server Relative URL, Array Separator), so I added the array separator, but this didn't change anything for me (URL parameter = "").
But then I looked at the help online, and the documentation is very inconsistent and confusing, and the Lookup has different parameters in the documentation; these articles don't take "Server Relative URL" and "Array Separator" at positions 5 and 6, but they take "multiple values" and "values data type":
Can someone help and clarify this and/or can the documentation get corrected?
Also, how do I effectively get multiple values returned using the Lookup function?
Couldn't spot an existing post about this either, which baffles me since this seems like something others would run into as well??
What sort of column are you looking up? I will see if I can replicate it.
Could you send me your form to firstname.lastname@example.org ?
I created some dummy records in Excel, and created a SharePoint list from the Excel 'table' using the out-of-the-box feature in Excel:
This results in the list you see in the screenshot below. I believe this to be a normal SharePoint list (and it behaves as such) but I thought I'd include this informaiton anyway.
In this list, I'm using the Application Number to get the Account Number, the Customer Name and the CIF. As you can see, there can be multiple records returned for a single Application Number:
Not sure what @SimonMuntz used to replicate this.
I understand. So you want to return multiple list items properties in a lookup function. At this time the Lookup function will only return queries from a single list item. The "Array Separator" in the lookup property in New Responsive relates to querying a multi-choice column.
We will look to add functionality to query multiple list items in the Lookup function in a late release.