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.
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.
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.
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.
Can some else from the community support team confirm the same results on Azure and Sharepoint.
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.
Community Support Team _ Phoebe Liu
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021