web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Fixing the Search Func...

Power Apps

Unanswered

Fixing the Search Function

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I have a search function that I want to fix that is attached to a sharepoint gallery, and the formula looks like:

SortByColumns(Filter([@'Lessons Learned'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

How can I fix the formula so that is filters for the entire gallery entry instead of just the first word it starts with?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

You can consider changing your formula to the following:

SortByColumns( Search('Lessons Learned', TextSearchBox1.Text, "Title") ), "Title", If(SortDescending1, Descending, Ascending) )

Note: this is not a delegable operation and will produce a warning as such. If record limits are not a concern, you can ignore it.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey Randy, I put your formula in place of mine on the app, but all of the entries are gone that is supposed to be searching for and the search bar doesn't seem to be working when I try to preview the app. Any fixes?

Was this reply helpful? Yes No

Join the conversation