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 function silent...
Power Apps
Unanswered

Filter function silently fails

(0) ShareShare
ReportReport
Posted on by 472

Filter function is silently failing on both employers tenant and my personal dev tenant. 

No Errors it just won't Filter the datasource any more. These tenants are not connected to the same sources, completely separate.

Categories:
I have the same question (0)
  • v-monli-msft Profile Picture
    on at

    Hi @KC,

     

    I just tested with the Filter of a SharePoint list gallery in my app and it works just fine. The gallery will only show the right items after I put some letters in the text input box. What is your connections in the problematic apps? Also please try to recreat the apps to have a test.

     

    Regards,

    Mona

  • CU11011415-0 Profile Picture
    472 on at

    Hi Mona, 

    I think this may be related to another issue I posted with the DataTable,

     

     I just changed the Filter from a dynamic value , variable rStatus is set based on user selection, to a hard coded value:

     

    rStatus can equal one the following: Pending, Approved, or Rejected

     

    Silently Fails:

    Filter('SPList', Status = rStatus) 

     

    Each of the following Fail with the WebAuthoring abnormal termination:

    Filter('SPList', Status = "Pending" ) 

    SessionID: fc957e35-2f51-cc44-4c7c-0e12fabea2c1

     

    Filter('SPList', Status = "Approved" ) 

    SessionID: 7512df7e-f93a-f517-4515-7e9c2cc4beb2

     

    Now when get to this point, the DataTable shows nothing even though I change the Status to either of the above or back to the variable rStatus. This is a new session due to the WebAuthoring abnormal termination.

    Filter('SPList', Status = "Rejected" ) 

    SessionID: No Session ID given, and it never Filters.

     

    Also I published this version and launched it into Dynamics365, this now shows the Red Error bar that the O365OfficeUsers.Manager  and O365OfficeUsers.MyProfile are throwing errors?, this does not happen in development mode.

    But now the DataTable will Filter once and ignore other calls to Filter.

     

    Thank you for looking into this.

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 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard