Show only unique values with Lookups
If we could include the option to include only unique values when building a lookup control it'd be swell!
I.e. I have a list of Departments with their corresponding Group. Each Group has multiple Departments, so there are multiple lines of each Group in the list. I want to be able to show only the unique values for Group when I build a lookup!
Thanks for your suggestion Scott. We are soon to begin building the List Lookup control for Universal Forms and will put this into consideration when building the new control.
Eric Rozensher commented
Hi danial Kinal. The question is "how to get only unique values from source column" and not how to use columns with unique values.
In your tutorial State values are already unique and this is not the case
AdminEmily Billing (Admin, Nintex) commented
Cascading drop down functionality is not available on Nintex Forms for Office 365, at least not yet! So that's why you can't see any filtering option.This is planned for a future release.
Hang Cheng commented
The tutorial show the filtering option. However, on my Office 365 the nintex form do not have the filtering option. Am I looking at the wrong place?
When parent and child List lookup controls connected to list columns to act as cascading dropdowns, having an option to filter list column data and/or ability to get only unique values from source column could be useful.