Editing a dropdown with list from external data

My app data comes from Google Sheets.
I am editing a dropdown that contains Brand Names. I got it to display the Brand Name of the specific item I am editing. But when I expand the dropdown, it doesn’t show me the unique list of Brand Names from google sheets, it shows the entire list including duplicates. How can I display unique items only.

:unique elements perhaps? (That’s a rhetorical question.) Operators & Comparisons - Bubble Docs…-unique-elements

I have it already in the source field, but it doesn’t work

It looks like your API request is returning a list of objects.
unique elements is checking all the properties of the objects to see if the are the same.
Probably the Brand property is the same for multiple objects but other properties are not, therefore the objects are not the same and they are not filtered from the list.
If you want to show a unique list of Brand, assuming it is a text, the type of choices should be set to text and the choices source should be your API request each item Brands unique elements

You are right and it worked
Screenshot 2023-02-01 150510

1 Like