Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Filter stopped working, Not a valid connector Error response.

Problem: Yesterday a gallery stopped loading on two of my apps, they have been running fine with the code below  

Gallery items= Filter('[dbo].[NewTblAppTrips]', cmvLocationid=Dropdown5.Selected.LocationID&&'Trip Date' <Now()) 

Testing: I built a new app for testing, created a gallery and added (same) Azure SQL Cloud as my data source.

Gallery items= '[dbo].[NewTblAppTrips]' 

Gallery loaded no issues.
Changed to

Gallery items=  Filter('[dbo].[NewTblAppTrips]','Trip Date'>Now())

I got the following error. “An error occurred on the server. Server Response: Not a valid connector Error response.”

I have multiple DATE columns all gave same error when testing.
Filter does work on nondate fields.
Turned on/off Experimental Performance improvements, no help.
Also refreshed data source within PowerApps.
Limited Rows to 100
This is happening at multiple locations,  platforms and Apps.
 I saw nothing odd within the Azure portal.
Under Connections Azure SQL Server Status is “Connected”
Trip Date Data Type datetime2(0)
Table has 300 Rows
Did Microsoft change something?
Is my Filter missing something?
Any ideas or comments are appreciated.

Helper III
Helper III

I am experiencing the same issues.  I have narrowed it down to the <, >, >=, and <= symbols. If you test with = or <> the filters work.  But none of the others. 

I got the sasme results as you = and <> filters correctly.

There was a new release 3.19074.24. I am wondering if something changed. All of my filters worked correctly last night, but today nothing works. I collect all of my data based on dates for my app.  This is a huge problem that this isn't working. 

Update, filter works on Sharepoint list but you get a Delegation warning.

Filter(tblAppTrips,'Trip Date'<Now())

Can some else from the community support team confirm the same results on Azure and Sharepoint.

Community Support
Community Support

Hi @cmv ,

Is your data larger than 2000?

Deleagtion is PowerApps itself limit. PowerApps could only deal with 2000 records locally. If your data is large, you should use delegable funtions. Or else your result may not be right.

If your data is larger than 2000, you should modify your formula and use delegable funtions:

If your data is smaller than 2000, the delegation warning will not effect your app performance.

Just do not remember change the non-delegable limit to 2000.delegation.jpg


Best regards,

Community Support Team _ Phoebe Liu


Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate I
Advocate I

I've got the same problem. Any news on this?

New Member

I am currently getting this same issues as a well in a new app a I am building. I have used this before and it worked. Same error message as well. Defiantly does not like the = sign. 

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,312)