Answered

Filter Stopped Working

(1) Share

Report

Posted on by CU14082326-0

My app consists of a gallery, where it is getting data from a SharePoint list. It used to work perfectly, until a few weeks (maybe months), it stopped filtering when you enter a name or case number in the Search bar. I had this running on a tablet for check in, where the user would tap 'Check In' and it patches to SharePoint. Now it is not filtering.

The way it used to work, is that as soon as I would type in a few letters, it would filter based on First Name, Last Name, or Case Number, using the formula below. When I run the app on a computer, it does sort as expected, but I now have to 'Click Out' of the search bar for it to Search. I cannot do this on a tablet, as it does not have a mouse cursor.

SortByColumns(
Filter(
'D17 - Check in',
Status.Value = "Not Present" &&
(StartsWith('First Name', Search.Value) ||
StartsWith('Last Name', Search.Value) ||
StartsWith(Title, Search.Value) ||
IsBlank(Search.Value))
),
"Name",
SortOrder.Ascending
)

Not sure what has changed, but any suggestions would be greatly appreciated.

Categories:

General Questions

All responses (4)

Answers (1)

Michael E. Gernaey 41,007 Super User 2025 Season 1 on at

Like (1)

Report

Filter Stopped Working

This sounds more like your integration object of your original app got deleted, or become corrupted. that's the only logical reason doing it again would solve it.

Actually, if you still had the old, it would be interesting to verify the integration object is there, and if not re-add it

Just for kicks :-) since you already resolved it.
Verified answer

CU14082326-0 11 on at

Like (1)

Report

Filter Stopped Working

Update: I was able to solve the issue by simply going back to the SharePoint list, clicking on 'Integrate' and then selecting 'Create An App'. For some reason, doing it this way brough back filtering back dynamically just by typing in a few letters/numbers.

I had to rebuild my app, unfortunately, but this resolved my issue.
Suggested answer

Michael E. Gernaey 41,007 Super User 2025 Season 1 on at

Like (2)

Report

Filter Stopped Working

Hi,

Its silly to have to do, there was a change that essentially stopped the OnChange event / what you need to happen.

Its 130AM for me and my brain is still bleh to remember how to tell you to fix it with the setting.

However, and I KNOW it stinks.. You could add a Filter button. The button could do NOTHING, except say

"Execute Filter" or whatever. Until I can remember lol.

They dont have to click out, just "leave the focus" of the Text Input. Having a dummy button would do that.

Ill come back with the other fix.
WarrenBelz 146,645 Most Valuable Professional on at

Like (2)

Report

Filter Stopped Working

Hi CU14082326-0,

There is nothing I can see wrong with your code as far as structure or Delegation goes. So we can eliminate something, try with a Classic Text Input (the output will be .Text, not .Value ) and see if that works. I also assume Name is a Text field.