Search/Sort Function

(0) Share

Report

Posted on by Shaguar357

211

Greetings,

I'd like to be able to combine a Search and Sort Function to the attached. I was able to figure out the Sort function, but have not been able to successfully combine with the Search. Any help would be greatly appreciated!

Categories:

General Questions

All responses (7)

Answers (0)

SebS 4,204 Super User 2025 Season 1 on at

Like (0)

Report

Re: Search/Sort Function

LoL I think I never put space between words in the column name so hard to notice for me 😛
SebS 4,204 Super User 2025 Season 1 on at

Like (0)

Report
Re: Search/Sort Function

@Drrickryp @Shaguar357

I think Search ignoring Space in column Name

Sort(Search(DailyWorkSheet, TextSearchBox1.Text,"StreetName"),'Date Installed',Descending)
SebS 4,204 Super User 2025 Season 1 on at

Like (0)

Report

Re: Search/Sort Function

@Drrickryp 🙂

Good Eye, I never asked him what he actually serchiong for LOL
SebS 4,204 Super User 2025 Season 1 on at

Like (0)

Report
Re: Search/Sort Function

@Shaguar357

Sorry my bad 🙂

Sort(Search(DailyWorksheet,TextSearchBox1.Text,"DataInstalled"),'Data Installed',Descending)
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

Re: Search/Sort Function

@Shaguar357

It looks like you are searching for a street name. In that case, the Items of your gallery should be

Sort(Search(DailyWorkSheet, TextSearchBox1.Text,'Street Name'),'Date Installed',Descending)
Shaguar357 211 on at

Like (0)

Report

Re: Search/Sort Function

Hi @SebS ,

This is what happens after entering:
SebS 4,204 Super User 2025 Season 1 on at

Like (0)

Report
Re: Search/Sort Function

Hi @Shaguar357

Replace Textinput.text with name of Your Textinput Search control

Sort(Search(DailyWorksheet,TextInput.Text,'Data Installed'),'Data Installed',Descending)