When I try my formula in browsegallery, I am only seeing data for the drop down CAATT ID and Requestor. I cant find out why my other dropdown choices arent working here. Could it be column type? or could it be the column names are wrong? I am getting my column names from MS List. If( Toggle2.Value = false, SortByColumns( Filter( [@'Documentation Tracker'], Or(Lower(Requestor_two) = Lower(User().Email), Lower(Approver.Value) = Lower(User().Email)) && TextSearchBox1.Text in Title ), If(Dropdown1.Selected.Value = "Documentation Type", "Doc_Type", Dropdown1.Selected.Value = "Requestor", "Requestor_two", Dropdown1.Selected.Value = "CAATT ID", "Title", Dropdown1.Selected.Value = "Status", "Approval Status", Dropdown1.Selected.Value = "Automation Type", "Automation Type", Dropdown1.Selected.Value = "Approver", "Approver", Dropdown1.Selected.Value = "Approval Date", "Approval Date",Dropdown1.Selected.Value = "CAATTS Name", "CAATTs Name", "ID"), Ascending ), SortByColumns( Filter( [@'Documentation Tracker'], TextSearchBox1.Text in Title ), If(Dropdown1.Selected.Value = "Documentation Type", "Doc_Type", Dropdown1.Selected.Value = "Requestor", "Requestor_two", Dropdown1.Selected.Value = "CAATT ID", "Title", Dropdown1.Selected.Value = "Status", "Approval Status", Dropdown1.Selected.Value = "Automation Type", "Automation Type", Dropdown1.Selected.Value = "Approver", "Approver", Dropdown1.Selected.Value = "Approval Date", "Approval Date",Dropdown1.Selected.Value = "CAATTS Name", "CAATTs Name", "ID"), Ascending ) )