Showing results for 
Search instead for 
Did you mean: 
Level 8

Filter function silently fails

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.

Community Support Team
Community Support Team

Re: Filter function silently fails

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.




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level 8

Re: Filter function silently fails

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.

Helpful resources


Power Apps Super User Class of 2020

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,408)