Search/Sort Function

(0) Share

Report

Posted on by Shaguar357

221

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:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

SebS 4,582 Moderator on at

Like (0)

Report
Hi @Shaguar357

Replace Textinput.text with name of Your Textinput Search control

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

Was this reply helpful? Yes No
Shaguar357 221 on at

Like (0)

Report

Hi @SebS ,

This is what happens after entering:

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

Like (1)

Report

@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)

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
@Shaguar357

Sorry my bad 🙂

Sort(Search(DailyWorksheet,TextSearchBox1.Text,"DataInstalled"),'Data Installed',Descending)

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report

@Drrickryp 🙂

Good Eye, I never asked him what he actually serchiong for LOL

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
@Drrickryp @Shaguar357

I think Search ignoring Space in column Name

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

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report

LoL I think I never put space between words in the column name so hard to notice for me 😛

Was this reply helpful? Yes No