I am using a fetch records to narrow the output of a lookup picklist, when I reun the fetch records, and then add them to the picklist I am getting multiples of the same, and the sorting doesn't seem to work. When the form loads there aren't doubles, just when you narrow the results. Here is the code to narrow:
I put a clear in to ensure that they were clearing before adding...
hazards = (Hazard_Register[(Site == input.Location || Site == "All Sites")].Hazard_Name sort by ID).getall();