Skip to main content

Notifications

Community site session details

Community site session details

Session Id : gkU8BMENqZDEOD7jwyAQfq
Power Apps - Building Power Apps
Answered

Datatable Search Bar not working

Like (0) ShareShare
ReportReport
Posted on 20 Nov 2023 11:51:27 by 629

I have a Data table which requires a search by a particular column. This is my datatables Items:

 

jamescosten_0-1700481006112.png

 

This is the error:

 

jamescosten_1-1700481034062.png

Categories:
  • Verified answer
    amyharkus86 Profile Picture
    720 on 20 Nov 2023 at 13:53:58
    Re: Datatable Search Bar not working

    Sort( Filter( Table_View_WSMInTouch_WIP, IsBlank(TextInput2_4.Text) || StartsWith( Description, TextInput2_4.Text ) ), ID, SortOrder.Descending )

  • jamescosten Profile Picture
    629 on 20 Nov 2023 at 13:49:44
    Re: Datatable Search Bar not working

    Didnt Have one, Was just the data source Table_View_WSMInTouch_WIP.

  • amyharkus86 Profile Picture
    720 on 20 Nov 2023 at 13:46:59
    Re: Datatable Search Bar not working

    what was your original formula before you started trying to use the search function?

  • jamescosten Profile Picture
    629 on 20 Nov 2023 at 13:40:30
    Re: Datatable Search Bar not working

    jamescosten_0-1700487616424.png

     

  • amyharkus86 Profile Picture
    720 on 20 Nov 2023 at 13:28:02
    Re: Datatable Search Bar not working

    You could add the descending on the end might help

    Search(Table_View_WSMInTouch_WIP, TextInput2_4.Text, "Description")
     Descending
    )

    What are you results with the above?

  • amyharkus86 Profile Picture
    720 on 20 Nov 2023 at 13:22:27
    Re: Datatable Search Bar not working

    @jamescosten what is your current formular in the table? before you start trying to use the search function? 

  • jamescosten Profile Picture
    629 on 20 Nov 2023 at 13:15:57
    Re: Datatable Search Bar not working

    Nope, I thought maybe its because of the column format, but its Text.

     

    jamescosten_0-1700486122387.png

     

  • Akash1ve Profile Picture
    112 on 20 Nov 2023 at 13:02:22
    Re: Datatable Search Bar not working
    Search(Table_View_WSM_InTouchWIP,TextInput2_4.Text,"Description")

    This should work as expected . Whole formula you just try replacing with this 

  • amyharkus86 Profile Picture
    720 on 20 Nov 2023 at 12:59:29
    Re: Datatable Search Bar not working

    Have you tried

     

     

    Search(Table_View_WSMInTouch_WIP ,TextInput2_4.Text,"Description")

     

  • jamescosten Profile Picture
    629 on 20 Nov 2023 at 12:57:39
    Re: Datatable Search Bar not working

    Same outcome, shows the exact same entries as above images.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard