Internal Server Error - Filtering by Date

[Anonymous]

Hi!

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?

[v-micsh-msft]

Hi @Anonymous,

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?

Regards,

Michael

[mokhawaja]

Hi,

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.

regards,

Mohammad

[pyee]

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?