Hi all,
short question:
i am alredy connected to our mssql server.
now i want to use a gallery to display my records.
i also placed a datepicker on the form.
Now i want to filter the results in the gallery depending on the datepicker.selectedvalue.
but i always get errors.
gallery1.items=Filter('[dbo].[Data]'; Text(datumSORTIERUNG; "[$-de-DE]yyyy-mm-dd hh:mm:ss") = '2017-01-10 17:00:00')
i also tried this:
gallery1.items=Filter('[dbo].[Data]';datumSORTIERUNG >= '2017-01-10 17:00:00')
and also tried this:
gallery1.items=Filter('[dbo].[Data]';datumSORTIERUNG >= DatePicker1.SelectedValue)
and tried many other things 😕
The mssql field "datumSORTIERUNG" is smalldatetime.
Can you help me please :-))
Thanks in advance
jup
Hello jup! 🙂
Try to use DateTimeValue in your Filter
Filter('[dbo].[TestTable]'; datumDate = DateTimeValue("2019-01-22"))
Maybe this will work for your scenario.
Good luck and best regards
Vasii
Hey! Thanks for this hint.
But I dont know what to do.
I tried the solution explained but it doesnt work.
Please help me in your words what i have to do.
I just created a simple table
and used this formula:
Filter('[dbo].[TestTable]'; datumDate = '2019-01-22')
also
Filter('[dbo].[TestTable]'; datumDate = DatePicker1.SelectedDate)
Noting !!! Every time errors.
Please please help me...
I tried this also with smalldatetime AND date. noting.
Hi @jup
There is a bug in PowerApps where filtering by dates doesn't work. There are more details about this issue here...
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1