
I have a gallery that I want to filter using a text box that searches multiple columns to find what I'm looking for. The problem that I have is one column has text(description) one column has numbers(order number) and one column has a lookup(customers). How can I do this? Below is a picture of what i have so far. Thanks!
Hi radtadBrad,
According to your description, I create an app based on a SharePoint list.
There are Text, Number, Lookup column in the list.
The code I am using is:
SortByColumns(If(IsBlank(TextSearchBox1.Text),ProjectEmail,Filter(ProjectEmail,StartsWith(TextSearchBox1.Text,Title)||Value(TextSearchBox1.Text)=WunderlistID||TextSearchBox1.Text=AA.Value)),"ID",If(SortDescending1,Ascending,Descending))
In my case, WunderlistID is the Number column, I use a Value function to convert a string of text to a number.
More details about Value function, please check this documentation:
https://powerapps.microsoft.com/en-us/tutorials/function-value/
Hope this could be a reference for you. Please try it on your side.
Best regards,
Mabel Mao