Remove duplicates from a dropdown connected to a dataset filtered by a second dataset

You might want to try using the distinct() query function to eliminate duplicates. See Example: Remove duplicates from connected dropdown options using distinct() query to see how it’s used.