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

Announcements

News and Announcements icon
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:
  • WarrenBelz Profile Picture
    156,520 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,970 Super User 2026 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,970 Super User 2026 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 394 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

Last 30 days Overall leaderboard