Unanswered

Search Multiple Columns in Data Table

(0) Share

Report

Posted on by Shaguar357

221

I would like to be able to Search multiple columns in the data table, instead of just the "Street" column. For example the Work Order column, which is a Number in the Share Point List.

Would anyone know how this could be achieved?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

The Search() function can be used to search multiple columns at the same time. The one problem is that its not delegable. So if you are using a large data source you need to narrow down the results before applying Search()

Was this reply helpful? Yes No
Tolu_Victor 197 Super User 2024 Season 1 on at

Like (0)

Report
Hi
The search function allows to search multiple columns
Just separate with a comma
Search( DailyWorkSheet, TextInput.Text, Street, 'Work Order' [, Column3, ... ] )

Was this reply helpful? Yes No
Shaguar357 221 on at

Like (0)

Report

Hi @Tolu_Victor ,

Thanks for your quick reply!

I have entered another column, however, the data then does not populate in the app.

Could this possibly be because the Work Orders type is a Number in the Share Point list?

Was this reply helpful? Yes No
Tolu_Victor 197 Super User 2024 Season 1 on at

Like (0)

Report
Hi, Unfortunately, Search only works with text columns

Rather than search why don't you just use the filter function since you need to filter different column types

Filter( DailyWorkSheet, TextInput.Text in Street || Value(TextInput.Text) = WorkOrderNumber )

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No