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.
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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.