Answered

Filter returns zero results when blank

(0) Share

Report

Posted on by RobRoy

111

What part of the Filter function decides to show all results when a search box is blank? I get the results I want with this code:

SortByColumns(Filter(Events, TextSearchBox1_2.Text = MyAge), "EventDate", If(SortDescending1, Ascending, Descending))

But when the text search box is blank I don't get all results like I do with other galleries. All I need is for it to not filter when the search box is blank (Is Blank?)

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-micsh-msft on at

Like (0)

Report
Hi @RobRoy,

You may consider switch to the Startswith function within the Filter.

Take a try to change the formula as below:

SortByColumns(Filter(Events, Startswith(MyAge, TextSearchBox1_2.Text)), "EventDate", If(SortDescending1, Ascending, Descending))

The function reference:

Startswith function in PowerApps

If you have any further questions, please post back.

Regards,

Michael

Was this reply helpful? Yes No
RobRoy 111 on at

Like (0)

Report

Thank you, I tried your suggestion.Unfortunately due to the nature of the search, I get all results for any age that starts with "3", for example (3, 30, 31, etc.), instead of only events that happened at the age of 3. Using the = MyAge formula does produce the correct result, however erasing the search box does not cancel the filter and restore the gallery, and instead produces a blank gallery (no results).

Was this reply helpful? Yes No
Verified answer

m_takatsuka 33 on at

Like (0)

Report

Hi

You want to disable the Filter statement if the search box is blank?
Then, how about so
IF (ISblank (search box), sentence with filter, sentence without filter or datacource)

I hope your expression will be solved.

Was this reply helpful? Yes No
RobRoy 111 on at

Like (0)

Report
Thank you, that helped. I previously tried IsBlank but my syntax was off. I also had to rework the sort order to show records in descending order when the search box is blank. Here is the qworking code:

If(IsBlank(TextSearchBox1_2.Text), Sort(Events, EventDate, If(SortDescending1, Ascending, Descending)), SortByColumns(Filter(Events, TextSearchBox1_2.Text = MyAge), "EventDate", If(SortDescending1, Ascending, Descending)))

Was this reply helpful? Yes No