My app was working perfectly some weeks ago and without any changes isn't working now. I did some changes today in the filter in order to understand the error... and I discovered that if I use a Date field in the filter, the application doesn't show any information and the following message is showed: "An error occurred on the server. Server response: Internal Server Error" and the PowerApp doesn't generate the SQL (I'm using Data Gateway to connect in my SQL Server database and monitoring with SQL Profiler)
I simplify my filter for:
### PROBLEM FILTERING BY DATE ###
Filter('#Data Source#', date = DatePicker1.SelectedDate)
if I change the filter for the following filter (without filter by date), the SQL is generated and the data showed:
Filter('#Data Source#', TextSearchBox1.Text in description)
-- It shows that the DataBase and the Gateway are working well.
General informations about my environment:
- Database version Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
- Database date type: [datetime]
- Using Database Gateway;
- I tested on PowerApp Desktop Tool and on the web Tool, experiencing the same error.
Looks like a bug in the Power App Server but, Anyone has any suggestion?
I just tested the filter with SQL Server 2016 datatime column, and the filter works:
Are there any related information under SQL profiler when the following error occurred?
"An error occurred on the server. Server response: Internal Server Error"
Besides, any configurations that you have made for the datepicker control?
i am facing the same error when i try to filter a galler by a datepicker control... i am using CDS backend...and actually this error shows up on the runtime, but when i go to edit the error, it just refreeshes the formula, and the error is gone (in edit mode), then when i test again on mobile the same error comes at the beginning of the app launch, but the app is functioning normally and the data is filtered when i choose different dates.
it is just annoying to see this error, which i think is some kind of a bug in powerapps datepicker control.
I'm still seeing this... the workaround I have is using:
Filter('[dbo].[vw_PowerApps_RunTickets]', Value(TicketDate) >= Value(DatePicker1.SelectedDate))
but it can't be processed remotely, so it's not an ideal solution. I'm on SQL Server 2012, and have verified that TicketDate is a Date value, not DateTime... has anyone come up with a better solution?
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.