Filter Multiple Collections based on Dropdown selected value
One of my Project, i got a requirement to filter multiple collections and display the values in the Gallery. Collection 1 - Employee Data - ID, Name, Manager Name, Grade ID, Collection 2 - ID, Manager ID Collection 3 - Manager Data - ID, Manager Name, Location. I have mapped the Dropdown with Employee ID. When User Select the Employee ID dropdown, I have Used Following Formulae and mapped it to Gallery. Filter( Manager, ID in Filter( Grade, ID in Filter( EmployeeID, EmployeeDropdown.SelectedText.Value in ID ).GradeID ).Manager ID ) Hope this helps.