I have 2 SharePoint 2016 lists, one is a lookup list and the other is a list for request form. Unfortunately we do set the employee division in AD only the Department. The employee's department and division needs to be added to the request form. So I created a look up list that lists all of our departments and the associated division:
On the Nintex Form (Classic) I have a calculated field that populates the employee's department:
To populate the employee's division (based on their department), I added another calculated field:
The department is populating correctly but the division is blank. I've also tried using parse lookup, singe quotes, spaces, no spaces. Nothing seems to work. Here are some of the different ways I have tried to auto-populate the division field:
I would really appreciate if someone could point me in the right direction!!
Best answer by MegaJerk
Though it's difficult to say what's going on without any other info of the values from your list, I would say that a little sanity checking could go a long way in your case.
Because your original lookup() function syntax is correct, the first thing I would do is check to see what happens if you were to just manually enter the string of said Department into your arguments like:
That should get you *something* back. If it does, then you know your problem is somewhere to do with the reference to the value of your {Dept} Control.
If you get NOTHING back, and you know that it *should* be valid, then it's time to start digging a bit deeper.
The next questions are:
Is the Target List ("DivDeptLookup") on the same Site as the Form?
No: Then you need to add the relative url path and a pipe delimiter before the target List Name, like: "/sites/siteCollection/siteA|customList"
What are the *actual* Column Names of the Columns that you're targeting?
Though it's difficult to say what's going on without any other info of the values from your list, I would say that a little sanity checking could go a long way in your case.
Because your original lookup() function syntax is correct, the first thing I would do is check to see what happens if you were to just manually enter the string of said Department into your arguments like:
That should get you *something* back. If it does, then you know your problem is somewhere to do with the reference to the value of your {Dept} Control.
If you get NOTHING back, and you know that it *should* be valid, then it's time to start digging a bit deeper.
The next questions are:
Is the Target List ("DivDeptLookup") on the same Site as the Form?
No: Then you need to add the relative url path and a pipe delimiter before the target List Name, like: "/sites/siteCollection/siteA|customList"
What are the *actual* Column Names of the Columns that you're targeting?
Thank you! That was an excellent explanation! This worked perfectly when using a lookup field. But I am using a calculated field that uses the User Profile Lookup. So I added another calculated field that captures this value then added this field to the fn. It is working perfectly. Thanks again!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
