Announcements
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?
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()
Hi
The search function allows to search multiple columnsJust separate with a comma
Search( DailyWorkSheet, TextInput.Text, Street, 'Work Order' [, Column3, ... ] )
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?
Hi, Unfortunately, Search only works with text columnsRather 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.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 414
WarrenBelz 377 Most Valuable Professional
Kalathiya 315 Super User 2026 Season 1
