I have a Data table which requires a search by a particular column. This is my datatables Items:
This is the error:
Sort( Filter( Table_View_WSMInTouch_WIP, IsBlank(TextInput2_4.Text) || StartsWith( Description, TextInput2_4.Text ) ), ID, SortOrder.Descending )
Didnt Have one, Was just the data source Table_View_WSMInTouch_WIP.
what was your original formula before you started trying to use the search function?
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?
@jamescosten what is your current formular in the table? before you start trying to use the search function?
Nope, I thought maybe its because of the column format, but its Text.
Search(Table_View_WSM_InTouchWIP,TextInput2_4.Text,"Description")
This should work as expected . Whole formula you just try replacing with this
Have you tried
Search(Table_View_WSMInTouch_WIP ,TextInput2_4.Text,"Description")
Same outcome, shows the exact same entries as above images.
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional