Power Platform Community Forum Thread Details

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!

Categories:

Building Power Apps

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