web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Stopped Working
Power Apps
Answered

Filter Stopped Working

(1) ShareShare
ReportReport
Posted on by 11
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:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,079 Most Valuable Professional on at
    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.
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
    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.
     
     
  • Verified answer
    CU14082326-0 Profile Picture
    11 on at
    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.
  • Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard