I have a dropdown selecting the groupID of an item in a SP list called GroupTitleDD
Another SP list called Students there is a number field called GroupID
I want to collect all the students with the GroupID equal to that selected in the dropdown.
ClearCollect(ColStudents1,Filter(Students,GroupID = GroupTitleDD.Selected.ID))
The result constantly collects twice, then more items than the total of the filtered list by duplicating the items in the collection. What's going on?