Howdy!
I’ve been having a hard time getting the right formula/function to work. I currently have a search box and a dropdown box with a Gallery. I can get the two to work together with the Gallery, but only when it uses StartsWith. This isn’t ideal since I would like to search for any part of the “Title” column. The two formulas below have each worked individually, but when I try to combine them, they create an error. I understand that the SortByColumns(Search( might cause delegation issues, but my dataset will never go over 200, so it shouldn’t be an issue (hopefully).
Goal: Is to be able to search by first and last name (which are both in “Title” column) and/or by the dropdown box (which uses Choices) while still sorting the columns alphabetically by “Title”.
Data source: SharePoint List
SortByColumns(Search(‘Directory',TextSearchBox1.Text,"Title"),"Title",If(SortDescending1,SortOrder.Descending,SortOrder.Ascending))
(Can’t use dropdown box, but able to search by any part of “Title”)
SortByColumns(Filter([@'Directory'],StartsWith(Title,TextSearchBox1.Text)&&(Dropdown4.Selected.Value="Choose Department"||Department.Value=Dropdown4.Selected.Value)),"Title",If(SortDescending1,Descending,Ascending))
(Only searches by “StartsWith”)
I'm very new to this so any help will be appreciated! 🙂
