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 Apps
Answered

Search Function

(0) ShareShare
ReportReport
Posted on by 70

I Need Help

 

if i search by title (arifin) my apss can do it. but if i try with another(task or area) it didn't works.

maybe somebody can guide me.

Screenshot_20231026_012440.png

Screenshot_20231026_012426.png

Thanks

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

    Hi @fadel13 ,

     

    Do you want to use "Search" function to filter multiple columns in datasource?

    Please try this:

    Search(ProjectMaintenance,TextSearchBox1.Text,"ColumnName1","ColumnName2",...)

     

    Best regards,

    Rimmon

  • Jonathan Manrique Profile Picture
    2,695 on at

    Hello @fadel13 

    First you are not doing a search but a filter. They are different functions

    Let me explain Search allows you to search the table and you can tell it not only to search for you in one or more attributes of the table, for example in your table you could search using textsearch in the fields title, name, etc.

    Now if you decide to use a filter and search by more than one parameter, it is most recommended that you have more than one field to use as a textsearch and this allows you to do a double filter, in case you want to do it with the same attribute you must decide what happens when the first filter returns values (and you may need to create a collection to filter from), and then filter the second part

    I recommend, depending on what you need, to use Search for searches and Filter only when you need to filter by one parameter or more.

    An example of a filter for more parameters would be

    Filter(Filter(Expenses; 'Expenses (Views)'.'Draft Expenses');Employee.'Full Name' = UserVar.FullName)

    Search(Expenses;text;"ine_descripcion";"ine_Employee")

     

    If I have answered your question, please mark your post as Solved.

    If you like my response, please give it a Thumbs Up.

    You can accept more than one post as a solution

     

  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Hi @fadel13 

     

    You can modify your formula to include additional conditions using the Or function.

     

    SortByColumns(
    Filter(
    [@ProjectMaintenance],
    StartsWith(Title, TextSearchBox1.Text) ||
    StartsWith(Task, TextSearchBox1.Text) ||
    StartsWith(Area, TextSearchBox1.Text)
    ),
    "Title",
    If(SortDescending1, Descending, Ascending)
    )

     

    Thanks!

     

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

     

  • fadel13 Profile Picture
    70 on at

    So far i try this function and it's works.
    Thanks!!

  • fadel13 Profile Picture
    70 on at

    something new for me. Thanks for explanation @Jmanriquerios 

  • fadel13 Profile Picture
    70 on at

    Thanks @Rajkumar_404 i will try using your function!!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 396 Most Valuable Professional

#2
11manish Profile Picture

11manish 134 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 101 Super User 2026 Season 2

Last 30 days Overall leaderboard