My users profiles contain a field with department name.
How can I make the unique values from department available in a select list within a content type field? i.e. Sales, Marketing, IT, etc. (to avoid duplicates).
I created Entity Reference > Select List > User (target type) + a view with ER that contains the user profile field department, but Query settings DISTINCT still doesn't get rid of the duplicates.
I even tried views_distinct module with Filter Repeats.