I'm trying to use the Lookup runtime function on Nintex 365 Forms to lookup a value in a list on a different site, but I'm having problems.
The documentation says:
lookup("list title", "column to filter on", "value to filter on", "output column")
List Title = To point to a list in another site, precede the list title with the server relative url path of the site, then delimit the list title with a pipe ‘|’ symbol, e.g. “/sites/siteCollection/siteA|customList”
On my form calculated field I have entered:
lookup("/squads/procurement|Person to Cost Centre","Title",Current User (Display Name),"Cost Centre")
There is an item in this list which matches my username. However, when I preview the form it just displays: #Value!
Using IE Dev tools to troubleshoot, the error says:
errMessage = "List 'Person to Cost Centre' does not exist at site with URL 'https://<OurCompany>.sharepoint.com/essentials/Concierge'."
This site URL is the path to the site the form is on, so it seems to be ignoring the path I'm providing before the pipe character in the "list title" parameter of the formula.
Can anyone see what I'm doing wrong?
Many thanks for any help,
Solved! Go to Solution.
I have raised this with Nintex Support and they have confirmed they can replicate the issue - it's now with their Development team "to be investigated".
I'll update this post when I hear more...
Just in case anyone wonders, this is the reply I've received from Nintex Support:
We have a feedback from Development team that currently Lookup runtime in O365 does not supported for cross site yet.
The help file provided has a miss information and we have fix the help file to strip off that information about this cross site.
We really do apologize for this mistake on the help file earlier.
Since the function that you have requested is still not part of our feature set, and if you think this will be a valuable addition to the Nintex product I kindly ask you to submit this new feature into Nintex User Voice (https://nintex.uservoice.com) as the voice of the customer is always valuable to the product team, who monitor features submitted by the "uservoice" tool.
We thank you for your understand with this matter.
So it's yet another thing you can't do with the O365 product. Sigh...