Text Search Box

(0) Share

Report

Posted on by Shaguar357

221

Good Day,

Can anyone offer a solution as to how to format the Text Search Box to Search for Street Name, House Number and/or Work Order Number?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

Re: Text Search Box

You need to change your Gallery's Items property to do this.

Search(Sort('DailyWorkSheet', 'Date Installed', Descending),TextSearchBox1.Text, thecolumnsyouwanttosearchin)

Was this reply helpful? Yes No
Shaguar357 221 on at

Like (0)

Report

Re: Text Search Box

Hi @zuurg

I tried that and received the following:

Any other advice?

Thanks!

Was this reply helpful? Yes No
zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

Re: Text Search Box

Just typing Date Installed as the column name won't work. I think it has to be enclosed in double quotes, and if there's a space in the column name, you might have to convert that space to _x0020_. Also, if you're searching for a date and the Date Installed column is a DateTime type, you're going to need to convert what you're searching for to a DateTime type.

I suggest maybe starting with a Text column type to see how it should be working.

Was this reply helpful? Yes No
Micky 365 Moderator on at

Like (0)

Report
Re: Text Search Box

Try using the code below, this will prompt delegation warning, I suggest you store your data source in a collection to prevent/remove delegation warnings, but overall this should work.

Filter( Sort(DailyWorksheet,'Date Installed',SortOrder.Descending), Or( searchTextInput.Text in 'Street Name', searchTextInput.Text in Text('House Number')//Converted House Number to Text(), searchTextInput.Text in Text('Work Order Number')//Converted Work Order Number to Text() ) )

Actual Result

Was this reply helpful? Yes No
Shaguar357 221 on at

Like (0)

Report

Re: Text Search Box

Good Afternoon @zuurg

I apologize for just getting back with you. I made the changes you suggested and it seems to be getting closer or at least there are less errors showing up:

Any idea how to get the data to show in the app now?

Thanks again for your help!

Was this reply helpful? Yes No
zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

Re: Text Search Box

Please show the actual error where the code is underlined in red. The Descending part needs to be SortOrder.Descending - the SortOrder part disappears when the descending part isn't selected.

Is Street a Text column?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Text Search Box

Hi @Shaguar357,

Have you solved your problem?

I suggest you use the SortByColumns():

SortByColumns(DailyWorksheet,"Street",SortOrder.Descending)

Was this reply helpful? Yes No