web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter gallery by numb...
Power Apps
Answered

Filter gallery by number, text, and lookup columns using one searchbox

(0) ShareShare
ReportReport
Posted on by 17

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.  2017-07-19_23h45_15.jpgThanks!

Categories:
I have the same question (0)
  • Verified answer
    v-yamao-msft Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard