When I use a lookup from a table that has grouped items, I often only want to select one of the many duplicate names in that table. How do I filter the Lookup options so that only one unique option shows up.
I have already tried
Item settings -> Filters like:
[Target Table].Filter([Target Table].Name.Unique().FormulaMap(RowId(CurrentValue)).Contains(CurrentValue.Name.RowId()))
None of those work