Hello,

What duplicates are you seeing in the output?

Is it coming from the Course or Date list?

One way around having multiple lists,

• Make 1 master list of data.



• Use choice columns on your SharePoint list and add them to your form. (You could do this with Courses and Premises)



• You can pass values from these choice fields into your list lookup(s) on the form.



• Create a new list view(s) that returns the specific values you need.

I have not done this with 3 tiered cascading lists, but I know it will remove the duplicates from a 2 tiered list.

If you can apply a view to your source master list, you may be able to achieve a 3 tiered cascade easier. I have had success using this method, but I think I had to use the Group By function in creating my custom view in order to pull back 1 value of each.

You can also try the below Javascript article that I found helpful.

https://community.nintex.com/t5/Community-blogs/Remove-Duplicates-from-cascade-lookup-column/ba-p/81259

it does work with that java :

NWF$(".lookupinput").on('mousedown', function() {
var usednames = {};
NWF$(".lookupinput option").each(function() {
if (usednames[this.text]) {
NWF$(this).remove();
} else {
usednames[this.text] = this.value;
}
});
});

+ the java input : «lookupinput». altought, there is one control that once i select one entry, the other one doesnt see it, but when i select something else in the same control, it does work perfectly.. My lookup list is perfectly filled. once i selected java in my name column, it doesnt work. But then i selected the other course i got and it worked